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?
Looks like this is a MySQL problem. Any idea what config value might cause this?
From what I can see in backup source code a lot of queries are running to create the dumpfile instead of a simple
I increased wat_timeout with success by adding into
$this->_write->query('SET session wait_timeout = 115200;');
But I noticed I get a 500 Internal Server Error
with post data: