Page 1 of 1

Moving MySQL database to new host

Posted: Fri Jan 16, 2004 12:45 pm
by Bill H
Am I correct that the process using phpmyadmin is as simple as:

a) "dump" each table to my disk

b) load each resulting file into the box below the "Run SQL query/queries on database..." box.

That seems awfully simple. Can it be that simple?

Posted: Fri Jan 16, 2004 1:01 pm
by AVATAr
yep... that's it!!! dump -> sql

Posted: Fri Jan 16, 2004 1:15 pm
by Shendemiar
One whole database could be in one file. No need to do it for each table.

That is at least in phpMyAdmin-2.5.4

Posted: Fri Jan 16, 2004 1:22 pm
by patrikG
"Export" in phpmyadmin 2.5.4 - do make sure that the files you are creating are relatively small, otherwise you may get a script timeout error from PHP when you try uploading them again. If need be, just parcel them.