RE: [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? I believe this should work: on the old server: mysqldump databasename table1 > table1_data.txt mysqldump databasename table2 > table2_data.txt mysqldump databasename tablex > tablex_data.txt copy the above files to the new server on the new server: cat tablex_data.txt |mysql databasename The above is assuming all permissions are set correctly. Chris