Maria DB

[HMC]

Has anyone else tried to import a backup database that was generated by Maria?  I am running RadioDJ 1.7.0 (and yes both databases have been updated) on both machines.  Production machine is Windows 7 – 64, the test unit is Windows 7 – 32.  Am I the only one having this issue?   

I have and didn't have any problems. I made a backup and then screwed up one of my tables by deleting the procedure. Oops.. Anyway, I Truncated the DB and reimported the backup no issues.

[Vanlen]

Has anyone else tried to import a backup database that was generated by Maria?

I just did to see how it went and yikes!  I had the same problem
It gets part way to restore then stalls and errors with

Restore process was interrupted by an exception.
Import ErrorMySq.Data.MySqlClient.MysqlException:
Unknow column "0x" in 'Field List" at MySql.Data.MySqlClient.MySqlBackup.ImportS

Couldn't get the rest of the info off the screen.  I exited the backup and everything is running but not restoring could be a BIG problem here.

I'm on Win 7 - 64

Cheers

[FL Coast]

Yes Vanlen, my exact problem.  Since it is my test machine, I will rebuild with a fresh start of Maria DB to see if I can figure out where the problem is.  Beyond that, looks like I will be sticking with MySQL on the production machine.  The strange thing is it would restore the backup database from my production machine that is still MySQL.   

[HMC]

Did you check any logs to see what is causing it to hang or if it's a an error in the file? I can't imagine this being a big issue in a since that makes mariaDB unstable. mariaDB is pretty huge. It's already the default database on Linux Redhat EL 7 and CentOS 7. If you know anything about Linux you know that's a big thing for businesses.

http://www.zdnet.com/red-hat-enterprise-linux-7-beta-arrives-with-mariadb-as-its-default-database-7000024194/

So I'm not really trying to make excuses here but there is something weird here. I'm going to test it again on my pc but my main prod machine didn't have that problem when I restored. I backed up to a sql file actually using HeidiSQL and restored it. I didn't use RDJ's backup utility. I'll try it with that and see if I get the same problem.

I've been running mariaDB since the first day I installed RDJ because I knew mariaDB is a replacement for MySQL so i automatically downloaded that first. I haven't seen an issue yet and it also runs 24/7.  I'll do some exports and test.

[ghm72]

Has anyone else tried to import a backup database that was generated by Maria?

Yes - I just did a manual backup and restored it with no issues. Is Maria DB running with all the correct permissions?

[Marius]

Just tested to backup and then restore and no problems found at this end.

[AndyDeGroo]

I too have finally migrated my data to MariaDB and the best part was that mysql_upgrade_wizard.exe did everything for me apart from one issue with one skip-federated switch in my.ini which made upgrade service terminate on startup.

I also tested backup using Database Setup and resulting file didn't contain any strange column names. I could not reproduce this behaviour.

@Vanlen You can open the backup file in text editor and find the culprit by searching for "0x". It should be easy to correct using search and replace if the errors are not all over the file. Actually, I'd like to take a look at the file and Marius could also see if it is an issue in Database Setup.exe. Could someone having this issue place the backup online and post the link here?

[nchuijg]

I run MariaDB for a week, the change was not a problem, everthing goes wel, but there were frequinly heart audio effects not coused by loss of CPU power, now i am back to MySQL no problems at all.
RadioDJ 1.6.5.7 run on Del Optiplex 760 with Pentium Dual Core E5200 2.5 GHz with 2 GB memory Win 7 32 bit

Greetings Nico.

[Vanlen]

Thanks Andy for your offer.  But it turns out I'm a complete Idiot. I was loading up a backup from a 32 bit instance of my other system which was MySQL based and the proper backup from my MariaDB Test box (WIn 7 64) bit version version of MariaDB worked as it should and restored as it should.  So to clarify.  MariaDB is back to working like a charm.  Now I'll just run and stick my head in the sand for the rest of the day.

Cheers

[AndyDeGroo]

I was loading up a backup from a 32 bit instance of my other system which was MySQL based and the proper backup from my MariaDB Test box (WIn 7 64) bit version version of MariaDB worked as it should and restored as it should.

There shouldn't be any difference between .sql files generated on 32 or 64bit systems. That could happen only if you were restoring MySQL data directory from 64 to 32 bit system and not the other way.
Are we talking about the same method of backup? I meant backup using .sql file generated by Database Setup.exe or mysqldump. I'd still like to take a look at the file if it is possible.

[FL Coast]

I think my problem may go back to when I first installed MariaDB.  (See my previous post)  «Reply #38 on: June 30, 2014, 04:45:09 PM

After playing around with MariaDB for a while trying to discover why it would not import a database it generated, just for my personal curiosity, I deleted MariDB and made a new install with the latest version.  This time it accepted my naming of the database and I was able to access it in RadioDJ.  I imported the database from my 64 bit machine and everything was off and running.  I did a backup of that machines database and re-imported it on the same machine and it worked.  I moved the db backup to my 64 bit machine and imported it with no problems.

So I will continue to test MariaDB a few more weeks before I decide to take the plunge and install it on my production machine.

Thanks for everyone's commits.

[Vanlen]

@AndyDeGroo

Okay, here is a drop box link with the dump incase Marius wants a boo at it too.  I used the Backup/Restore from DBSetup up  1.7.1 Release

https://www.dropbox.com/s/07fivdyzgwcm6wu/20140719%20194530.sql

[AndyDeGroo]

You have backup of not only RadioDJ database, but MySQL internal schema tables. I don't know how you got them.
You would have unneeded tables in your RDJ database after restoring thins file as the file contains table create statements without database name.

Oh, I see now. You are using internal mysql schema for storing RDJ data. You should have created new database before running Database Setup. Otherwise you are in for rough ride when restoring RDJ data. Not only that, but also the backup file is much larger than it should be because it contains MySQL users, table structures, help reference and a lot more than you need.

I'll clean up the mess and try to restore on a test database to see if it stops somewhere.

Update: Removed all mysql tables and data from the file and restore went well. Your problem was caused by trying to restore to mysql database, which changes with each MySQL version and certainly in MariaDB. Please create new database and then I could assist you with the backup file.
Here is the clean file: 20140719 194530-RDJ-only.sql. Note that it is at least half the size of the original.

Note to Marius: Add Database Setup option to create new table for RDJ.

[Vanlen]

Wow, thanks for your help Andy and sleuth work.   I restored with the fixed backup and bam instant restore!.  But I'll follow your directions and do a fresh MariaDB database and take it from there. When everyone was raving about MariaDB I did a MySQL Backup then uninstalled MySQL and thought I had created a new Database and did a restore which worked but then after a while tried the restore and no go with the backup I posted which now I see why it would hang with all the extra baggage in it you found. LOL.   Since MariaDB is used only on a test box I'll start with it from scratch and try again.

Cheers and thanks

[Vanlen]

Okay, I created a new DB from scratch with MariaDB and the backup file that Andy created loaded without any issues.   Runnning solid.   I don't know how the MySQL extra tables and data was in there but was from a back up of MySQL BEFORE deleting MYSQL from my system and installed MariaDB 64 bit from scratchand loaded the RESTORE file that was fixed by Andy DeGroo and all is well.   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.


Cheers