big problem with restore

[szakamafa]

I have big problem with restore accounts on other server, i copied account from /home/admin/admin_backups to new server to /home/admin/user_backups then change name of file to username.tar.gz and chown by admin.admin then in DA go to Admin -> Reseller -> System Backup and try to restore account some of domains goes without problem and some with these errors:


Domain domain.com Created

Domain Created Successfully

Domain domain.org Created

Domain Created Successfully


An error occurred listing the databases: MySQL server has gone away
Error getting list of database users: MySQL server has gone away
An error occurred querying the users table MySQL server has gone away
Cannot find the user fotosky_db which should already exist
Error Adding Main Username to database: MySQL server has gone away
Error Adding Main Username to database: MySQL server has gone away
Error Flushing Privileges: MySQL server has gone away
Unable to set fotosky's password. MySQL server has gone away
Error Flushing Privileges: MySQL server has gone away
Unable to restore database fotosky_sennik.sql to fotosky_sennik : ERROR 1044 (42000): Access denied for user 'fotosky'@'localhost' to database 'fotosky_db'

An error occurred listing the databases: MySQL server has gone away
Error getting list of database users: MySQL server has gone away
An error occurred querying the users table MySQL server has gone away
Cannot find the user fotosky_sms which should already exist
Error Adding Main Username to database: MySQL server has gone away
Error Adding Main Username to database: MySQL server has gone away
Error Flushing Privileges: MySQL server has gone away
Unable to set fotosky's password. MySQL server has gone away
Error Flushing Privileges: MySQL server has gone away
Unable to restore database fotosky_sms.sql to fotosky_sms : ERROR 1044 (42000): Access denied for user 'fotosky'@'localhost' to database 'fotosky_sms'

Why this problem is only with some domains in account? I tried other accounts and the same problem.. any ideas or solutions for it? I don't want manualy copy databases and create mysql users for each domain with errors when i have about 500 accounts to transfer..

 

[nobaloney]

An error occurred listing the databases: MySQL server has gone away

This error indicates that MySQL isn't running. More information can be found by googling the error.

Jeff

 

[Zwerver]

The bigger issue is, why does MySQL dies during a restore. I'm having the same problems right now with a restore of a big reseller and I think it has something to do with concurrent connections or something. So MySQL is not dying but just not accepting conn's anymore.

 

[scsi]

Increase the number of connects?

 

[Zwerver]

I reckon that 500 conn's is more then enough? But I tried it and let's see if it helps. The other one I'm trying is increasing the max_allowed_packet to 265M, it could be possible that 16M is to small.

 

[scsi]

There is no way you have 500 connections when its backing up.

 

[Zwerver]

I know, the change that there's really 500 conn's is so small that I don't even take it serious. What I did change was max_allowed_packet to 265M and wait_timeout to 60, that solved it.