backup mysql:FAILED

[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.

[JonB]

Did you upgrade incrementally?

[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?

[JonB]

Did you use the mysqlupgrade CLI tool?

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

Good Luck

[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.

[JonB]

OK - glad that worked out