Page 1 of 1

backup mysql:FAILED

PostPosted: 05. December 2012 23:44
by mths
I just installed xampp 1.8.1 after upgrading from a (much) older version. Now, when I run /opt/lampp/lampp backup PASS I just get:
Code: Select all
Backing up databases...
mysql: FAILED


Anyone has a clue where this goes wrong? The database is over a 100Mb when I export it uncompressed through phpmyadmin.

Re: backup mysql:FAILED

PostPosted: 06. December 2012 02:03
by JonB
Did you upgrade incrementally?

Re: backup mysql:FAILED

PostPosted: 06. December 2012 10:05
by mths
I did not upgrade incrementally, I did a fresh install. I tried upgrading step-by-step from version 1.6.7 but that faild. I then exported the databases one by one and imported them one by one. Exporting all of them and importing them didn't work and gave sql errors. The database seems to be working fine now. Is there a way to test if there are 'glitches' in it?

Re: backup mysql:FAILED

PostPosted: 06. December 2012 17:54
by JonB
Did you use the mysqlupgrade CLI tool?

http://dev.mysql.com/doc/refman/5.1/en/ ... grade.html

Good Luck

Re: backup mysql:FAILED

PostPosted: 07. December 2012 15:55
by mths
Thanks. It didn't work for me, the function mysql_upgrade just gave me a mysql-> prompt, I tried different arguments but it didn't make much sense to me. I solved it by reinstalling the whole thing and re-restoring the databases.

Re: backup mysql:FAILED

PostPosted: 07. December 2012 16:33
by JonB
OK - glad that worked out