SLUG Mailing List Archives
[SLUG] MySQL server to server data transfer
- To: slug@xxxxxxxxxxx
- Subject: [SLUG] MySQL server to server data transfer
- From: "Voytek" <lists@xxxxxxxxxx>
- Date: Fri, 20 May 2005 00:25:57 +1000 (EST)
- User-agent: SquirrelMail/1.5.0
I need to transfer several databases from one MySQL server to another,
data szie about 350MB HD space;
is it practical to do like 'mysqldump > mysql.sql | mysql < mysql.sql '
(whatever the correct synatx is), that is, dump mysql and pipe into the
second host in one step ?
or am I better just dumping, copying data over, importing ?
and, how do I construct the dump to pipe as input
mysqldump > mysql.sql
mysql < mysql.sql