* Todd Cary > Is there a quick and simple way to move a MySQL DB from one > server to another MySQL server?
There are many ways to do that. How simple it is depends on a lot of things... many people prefer to use some kind of tool, like phpMyAdmin or MysqlFront. <URL: http://www.phpmyadmin.net/ > <URL: http://www.anse.de/mysqlfront/ > I find it easier to use the command line... one way is to do the export and import in one go. This should be done from the old server: $ mysqldump -u user -ppassword olddb | mysql -h newserver -u user -ppassword newdb <URL: http://www.mysql.com/doc/m/y/mysqldump.html > Another way is to do the export first (using mysqldump), copy the files to the new server (using ftp, scp or whatever), and import on the new server, using the standard mysql client. > Can I just copy the tables? Yes, if the servers are not running, and server versions are compatible. This is probably the fastest way to do it. Just copy the content of the mysql/data/olddb directory (*.frm, *.MYD and *.MYI files). Beware that InnoDB tables are stored in a separate file (or 'tablespace'), which may be more difficult to move to another server, espescially if you have other InnoDB tables on the new server which you wish to keep. Use mysqldump to avoid this problem. -- Roger --------------------------------------------------------------------- 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
