Moving MySQL database to new host

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Bill H
DevNet Resident
Posts: 1136
Joined: Sat Jun 01, 2002 10:16 am
Location: San Diego CA
Contact:

Moving MySQL database to new host

Post 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?
User avatar
AVATAr
Forum Regular
Posts: 524
Joined: Tue Jul 16, 2002 4:19 pm
Location: Uruguay -- Montevideo
Contact:

Post by AVATAr »

yep... that's it!!! dump -> sql
Shendemiar
Forum Contributor
Posts: 404
Joined: Thu Jan 08, 2004 8:28 am

Post 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
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post 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.
Post Reply