Tugger the SLUGger!SLUG Mailing List Archives

[SLUG] MySQL server to server data transfer


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



-- 
Voytek