Maria DB

[AndyDeGroo]

I'm wondering if backing up with MySQL is a good idea and for those starting out with MariaDB should start from scratch.   Seems to me the way to go.

You had internal mysql tables in backup file because you had "mysql" in "MySQL Database" field on Database Setup Utilty. That database should not be messed with.
I'm surprised that you didn't have issues before. It might have appeared after moving to MariaDB because internal tables are different in MariaDB.

[Vanlen]

Thanks for the explanation.

Cheers

[704djs]

Just done a Tutorial on setting up Maria DB http://djgarybaldy.co.uk/maria-db-radiodj/

Should be fairly easy if your not used to a SQL server......

Hope this helps someone.

link not work Gary

[FL Coast]

The link works for me.


link not work Gary

[ghm72]

link not work Gary

Our  VPS fell over it should be up and running again now.

I've updated the original post about the tutorial to include a basic how to setup should my blog not be available.

http://www.radiodj.ro/community/index.php?topic=5339.msg31097#msg31097

[elsilva0]

I will also test it more and share my thoughts.

@Marius #Mairus Have u tested mariadb anymore? Does it really get more memory usage than mysql?

[ghm72]

Just to confirm to anyone reading this topic.

So far since July 2014 my database hasn't crashed once, hasn't spluttered it's just worked as it should.

So yes the answer to the question: MariaDB is really stable and works like a trooper.

Have u tested mariadb anymore? Does it really get more memory usage than mysql?

You tell the program how much memory to use when you set MariaDB up I have mine set at 300mb and as you can tell everything works.

[Hansen]

there is hope for mankind......

by that, i mean that even i, could install this....

works perfectly even flawless

[Marius]

 

[Jhonny]

Today had a funeral of my uncle, was a bit sad, but after reading the latest comments, I really had to 

@Marius #Mairus Have u tested mariadb anymore? Does it really get more memory usage than mysql?

No just less.
Hasta la vista elsilvaO, you have make my day. 
great boys... Thanks

JH.

[ghm72]

I've just upgraded my copy of MariaDB to the latest build https://downloads.mariadb.org/mariadb/10.0.21/

Top Tip: As I've just found out before you attempt to upgrade MariaDB you need to:

A) Backup your RDJ database
B) Shut RadioDJ down including the database backup tool.
B) Stop mysqld.exe as a service.

Then you can begin the install of 10.0.21 if all goes to plan, the installer should automatically restart mysqld.exe as a service then you should just be able to restart RadioDJ

5 minute job if that.

[ricky]

Have been using it now for over two months and as of yet no problems it just works and as you say it is not as hard to setup  on win 7 pc 

[ghm72]

I've been using MariaDB now since June 2014. I've never had a an SQL program that was this stable and easy to use.

Something would regularly go wrong with MySQL esp the 4 series but I don't seem to have that problem with MariaDB.

Only had to repair the database once to my memory and that was after a power cut. Other than that it's running absolutely flawless.

It's just nice when stuff works..... **Looks at Windows 10** 

[ghm72]

Wow has it really been 2 years this month since I first tried MariaDB ....

I don't know about anyone else but everything here is running as smooth as a nut...

It's been rare to have an issue. I haven't had to reinstall the database from scratch once. If I have had any issues they've been quickly sorted with HeidiSQL, The only time the DB has crashed was due to a power failure.

I love it when I can just leave software to do its own thing without having to constantly rebuild the database 

MariaDB & RadioDJ a partnership made in heaven? I think so.

[packzap]

Yes!  I concur.