mysqld keeps dieing

[Invader Zim]

Every morning after we do a full database dump, mysql dies. But not completely.

mysqld_safe keeps running but the mysqld just disappears. So database connections are not accepted but because mysqld_safe still runs, dataskq doesn't notice mysql died.

all the backup script does is

/usr/local/mysql/bin/mysqldump -u $DBUSER --password=$DBPASSWORD $q > $TARGET/$q.sql

which i use on many mysql servers and i've never had them die on me. any help would be appreciated.

 

[snaaps]

same preblem here.

any one a soulition?

 

[andyreed]

Every morning after we do a full database dump, mysql dies. But not completely.

Sometimes, it is really difficult to troubleshoot a problem without an error message. The first thing you need to do is to check the log files for any errors.