Dumping a large mysql database to another server.

Problem: Mysql has gone away.

[mack]

Hi there,

I am tryng to deliver an entire mysql database from one server to another, both servers are local. I am issuing the following command.

mysqldump -uUSERNAME -pPASSWORD1 dATABASENAME ¦ gzip ¦ ssh root@192.168.1.2 "gunzip ¦ mysql -uUSERNAME -pPASSWORD2 DATABASENAME"

The database is about 1.5 gig, it runs for about 10 mins before giving the error message
"mysql has gone away"

If I access the db through phpmyadmin I can see that is has moved some of the tables, data etc over.

Any ideas,

Mack.

[bcolflesh]

Have you tried a host name instead of an IP?

<edit>
also check:

[dev.mysql.com...]

</edit>

[mcavic]

If you have root access, you can just move the physical files from /var/lib/mysql or wherever they are located. Do a flush tables command or a mysql shutdown first.