On Mon, Apr 09, 2001 at 01:47:28PM +1000, Simon Bryan said:
--> Hi,
--> Can anyone point me at some resources that describe how to move an MySql
--> database from one server to another?
I find that something like the following works well..
newserver:/var/lib/mysql# scp -r user@oldserver:/var/lib/mysql/dbname ./
..
..
..
newserver:/var/lib/mysql# chown -R mysql.mysql dbname
- then you just have to add user/db access records to go with if needed, and do a
'mysqladmin reload'..
Regards,
Damien Gardner Jnr - Dip.EE StudIEAust
[EMAIL PROTECTED] - http://www.rendrag.net/
Ph: 0417 055 052 - Fax: 02 6255 8663
-- It's sick the way you people keep having sex without me
--
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://slug.org.au/lists/listinfo/slug
