Dear Andrew,
>Can someone please recommend the easiest way to transfer a database
(with data) from >one server to another?
Best way is to dump all databases and then generate them new on the new
server. This will make MyISAM files by default, so old ISAM files (which
are slower and more likely to cause trouble) won't bother you:
mysqldump database_1 > dump_db_1.sql
mysqldump database_2 > dump_db_2.sql
etc.
(Maybe you will have to enter username / password as database admin,
let's call this one superuser:
mysqldump -u superuser -p database_1 > ... etc.)
This will dump databases and tables with data into dump_db_*.sql files.
After dumping, create new databases and tables with data like this:
mysql < dump_db_1.sql
(Maybe, here again with database admin login:
mysql -u superuser -p < dump_db_1.sql)
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Andrew Pasetti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 23, 2001 1:47 PM
Subject: how to move a database to a new server?
Can someone please recommend the easiest way to transfer a database
(with data) from one server to another? Here's the server info:
Existing server:
Linux 2.2.14-5.0 running mysql 3.23.10-alpha
New server:
Linux 2.2.14-5.0 running mysql 3.23.32
Thank you. Your feedback will be greatly appreciated.
--Andrew
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
