Migration of Big Account

[sbenammour]

I'm having a problem when I migrates one domain, it has a big MySQL database (2 GB). The migration starts correctly but after a while the connection is lost

How can I fix that?

Thank you

 

[Monica@]

Hi

Probably the connection is lost by the timeout, you should check whether the ssh on the both servers is configured without timeout (ConnectTimeout value in /etc/ssh/ssh_config).
Examine /var/log/messages on the source server, migration logs (search in /usr/local/psa/PMM/ directory).
It is always possible to migrate manually, see here how to do it:
http://kb.swsoft.com/en/1152

 

[Blackbit@]

Use Mysqldump

Use the mysqldump utility, to dump the database to file. Then tar/gz and transfer it with scp as described above.

A nice trick to prevent timeouts importing big database use mysql on shell again, like this:

"newdb" is your new, empty database wich will be the big one.
"big_db.sql" is the old, transferred from the other server:

/usr/bin/mysql -u admin -p`cat /etc/psa/.psa.shadow` newdb

Then execute your dump:

mysql> \. big_db.sql

Should take some time, but this worked with the biggest database i have, as every command is executed one by one.