RE: [PHP] Importing an entire mysql database

I usually do: mysqldump -u user databasename > filename.txt This gives you the complete inserts and table creation stuff. Then on the new server: mysql -u user once in, create database databasename quit the mysql interface. mysql -u user database < filename.txt That works every time. Dan -----Original Message----- From: JB [mailto:jbeebe@aimsmarketing.com] Sent: Friday, December 08, 2000 11:16 AM To: php-general@lists.php.net Subject: [PHP] Importing an entire mysql database I seem to be having a problem moving an entire database on to a new server. It is not large by any means. Only about 6 tables with with a relatively small amount of records. I think I may be missing a crucial step. Can anyone give me some breif instructions on how I should move it from one server to another. Is there a certain way I must prep the database before copying it onto the other server. Is there any special way I should be importing it on the new server? Thanks. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net