Backup with mysql problems?

[TimmiT.nl]

Hi there,

I got with the backup scripts (the admin backup/transfer option in DA) the following error:

User xxxx1 has been backed up.

Error while backing up database xxxx2_forum
mysqldump error output: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `phpbb_posts_text` at row: 1111353




User xxxx3 has been backed up.

So if you can see the user xxxx2 isn't backuped because the mysql error.

Is see this process running:

 sh -c /usr/bin/mysqldump --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --host=localhost --add-drop-table --all --extended-insert --quick --quote-names --no-create-db xxxx2_forum.sql > /backup/aaaa/daily/xxxx2/backup/xxxx2_forum.sql 2> /backup/aaaa/daily/xxxx2/backup/xxxx2_forum.dump.log

I see that there isn't a -q flag given with the mysqldump that maybe could be the problem. Can I give that flag somewhere?

/etc/my.cnf:

wait_timeout = 28800
interactive_timeout = 28800
max_allowed_packet = 64M

And the database is 1.6GB

What are the other options to fix this problem?

 

[scsi]

Are you sure your database is using those values?

Login to mysql shell and try:

show variables like '%timeout%';