If I click on System > Tools > Backups
create a database backup and restore it the shop breaks. Looks like the backup is canceled in the middle.
Could this be a PHP timeout problem or is this done by a cronjob? Is this know not to work probably?
Update
Looks like this is a MySQL problem. Any idea what config value might cause this?
MySQL config
connect_timeout=120
delayed_insert_timeout=3000
innodb_lock_wait_timeout=600
interactive_timeout=28800
net_read_timeout=600
net_write_timeout=600
slave_net_timeout=3600
table_lock_wait_timeout=600
wait_timeout=18000
From what I can see in backup source code a lot of queries are running to create the dumpfile instead of a simple mysqldump
...
Update 2
I increased wat_timeout with success by adding into app/code/core/Mage/Backup/Model/Resource/Db.php
$this->_write->query('SET session wait_timeout = 115200;');
But I noticed I get a 500 Internal Server Error
/index.php/admin/system_backup/create/key/a74b4...7978/?isAjax=true
with post data: type=db&maintenance_mode=0&backup_name=test&exclude_media=0&form_key=uPK54mu...