NYCPHP Meetup

[Dan Cech]

I'm with Mark on this one, the best method is going to be to combine the 
built-in phpMyAdmin export and import functions.

This approach will be an order of magnitude slower than the mysqldump 
method, though you can probably gain a lot of speed by using the mysql 
extended insert syntax when populating the tables.

Depending on the amount of data you are dealing with it might be best 
from a memory usage point of view to break the procedure up, generate 
and execute the structure SQL, then the data sql for each table 
separately, rather than trying to read it all into memory in one hit.

Dan