[help] I got MySQL backup error!

[oceanwavecn]

Dear all,

Today,I run the mysql backup in DA control panel(Create/Restore Backups), and got the error. and what can I do to fix the problem? thanks!

Remark: the backup function is workable in may.2007.

Subject: An error occurred during the backup. Today at 18:38

Error getting list of database users: MySQL server has gone away
Error getting list of database hosts: MySQL server has gone away
User admin wasn't assigned to database admin_abc, adding it in the backup.

 

[dirko]

dBase gone

Maybe you should go by phpmyadmin : http: //domain.com/phpmyadmin/ with log and pass; import dB user_basename import .
First creating new dBase in DA.
good luck

 

[DirectAdmin Support]

Try a full manual restart of mysqld.

killall -9 mysqld
killall -9 mysqld_safe

then start it up through DA or via ssh, eg:
/etc/init.d/mysqld start

If there are still problems, check the mysql log:

tail -n 20 /var/lib/mysql/`hostname`.err

or

tail -n 20 /home/mysql/`hostname`.err

John

 

[sullise]

Check to see if the database has any users assigned to it. Got clients with same problem and each database that has this error shows -1 for users.