Back Up fail, Can't dump database admin_default

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

[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

[rabtpk99]

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?

[skurudo]

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.