backup mysql:FAILED

Problems with the Linux version of XAMPP, questions, comments, and anything related.

backup mysql:FAILED

Postby mths » 05. December 2012 23:44

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.
mths
 
Posts: 8
Joined: 05. December 2012 23:40
Operating System: Ubuntu

Re: backup mysql:FAILED

Postby JonB » 06. December 2012 02:03

Did you upgrade incrementally?
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: backup mysql:FAILED

Postby mths » 06. December 2012 10:05

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?
mths
 
Posts: 8
Joined: 05. December 2012 23:40
Operating System: Ubuntu

Re: backup mysql:FAILED

Postby JonB » 06. December 2012 17:54

Did you use the mysqlupgrade CLI tool?

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

Good Luck
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: backup mysql:FAILED

Postby mths » 07. December 2012 15:55

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.
mths
 
Posts: 8
Joined: 05. December 2012 23:40
Operating System: Ubuntu

Re: backup mysql:FAILED

Postby JonB » 07. December 2012 16:33

OK - glad that worked out
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 4 guests