you could use replication temporarily
just set it up, then run LOAD DATA FROM MASTER boom, off it goes.
Dean
Phil Scarratt wrote:
Voytek wrote:
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
if using mysam table format or another protable format or the host OS is the same just tarball them and ssh/scp them across and untarball
Fil
-- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
