This one time, at band camp, Simon Bryan said:
>Hi,
>Can anyone point me at some resources that describe how to move an MySql 
>database from one server to another?

mysqladmin -h server2 create dbname
mysqldump -h server1 dbname | mysql -h server2 dbname

you might want to make sure the dump gets the whole database structure
before you rely on its integrity

-- 
jamesw

Always two there are; a Bastard, and a PFY.

-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://slug.org.au/lists/listinfo/slug

Reply via email to