Page 1 of 1

Back Up fail, Can't dump database admin_default

Posted: Mon Feb 20, 2017 8:24 pm
by rabtpk99
I'm trying to backup my websites before I move one domain to another host but I receive an email with the subject message:
Email Subject: Back Up fail
Email Message: Can't dump database admin_default

Also received this email message
Can't dump database admin_xyz4
mysqldump: Error: 'Got error 28 from storage engine' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `ew28b_acymailing_config`': Got error 28 from storage engine (1030)

How can I fix this?

Re: Back Up fail, Can't dump database admin_default

Posted: Tue Feb 21, 2017 6:49 am
by skurudo
You can try this:

Code: Select all

mysqlcheck --no-defaults -u root -pyourmysqlrootpass --all-databases
mysqlcheck --no-defaults -u root -pyourmysqlrootpass --all-databases -o
mysqlcheck --no-defaults -u root -pyourmysqlrootpass --all-databases --auto-repair
mysqlcheck --no-defaults -u root -pyourmysqlrootpass --all-databases --analyze

Re: Back Up fail, Can't dump database admin_default

Posted: Tue Feb 21, 2017 10:40 am
by rabtpk99
skurudo wrote:You can try this:

Code: Select all

mysqlcheck --no-defaults -u root -pyourmysqlrootpass --all-databases
mysqlcheck --no-defaults -u root -pyourmysqlrootpass --all-databases -o
mysqlcheck --no-defaults -u root -pyourmysqlrootpass --all-databases --auto-repair
mysqlcheck --no-defaults -u root -pyourmysqlrootpass --all-databases --analyze
Thank you so much, but I am a little new to this. If I am not wrong I supposed to log in to root and do this?

Re: Back Up fail, Can't dump database admin_default

Posted: Tue Mar 07, 2017 12:42 pm
by skurudo
rabtpk99 wrote: Thank you so much, but I am a little new to this. If I am not wrong I supposed to log in to root and do this?
Yep, you're right.