Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Programming Tutorials : Move a MySQL Database from one host to another using phpMyAdmin

[BF-Gary]

The following are the steps to Export and then Import a MySQL database usnig phpMyAdmin

Export from phpMyAdmin
[list=1][*]Open cPanel and open your phpMyAdmin [*]On the welcome screen you will see an Export option click on this link [*]This will bring up the view dump (schema) of databases screen [*]Select the tables you wish to be exported from the list [*]Ensure you choose SQL as the option (this will alow you to just paste the SQL for your next host) [*]It will create text file on the screen, highlight the information and paste it into a text document. Save this for when you get hosting.[/list=1]

Import to phpMyAdmin[list=1][*]Open cPanel and open your phpMyAdmin [*]On the welcome screen you will see an Query window option (lower left corner) click on this link [*]Paste the contents of the text file that you exported and done. Your database and it's contents are moved.[/list=1]

[DT-Spirit]

Thanks...
Finally know how to do this..

[AFMichael]

Thank you, monster123 for this how-to. I think this will be the easiest way for me to explain it to my clients when they move over to us.

[kikonoro]

thank you very mich for this. I have had trouble with this for a while now and you make it osund so easy. Thnx.

[Akash]

Thanks monster123, your How-To has been approved!

It will go in the Programming How-To Forum when I create it.

[Aea]

I have found this to be very ineffective and time consuming for databases over 10 MB.

[Akash]

Perhaps you could write a how-to to do this via SSH

[XYPHEN]

Thank you for sharing this with us, are we allowed to use these How-To's ? If I provide a link saying How-To thanks to Name(URL).

[aqi32]

when you backup a database through cpanel does it backup the whole database like through phpmyadmin (table structure and data) or is it just the data?

cheers

[Tom|420]

Even better is to save the the data to a file, and transfer the file directly to the new host (using the file input form just below the query form). That way the client has a backup, and he has no more excuse not to have a backup when something gets screwed up.

[cpbb]

phpMyAdmin has a size limit of 2 megs I think, it caught us out when moving a DB, in which case you need to do it via shell.

[twhiting9275]

yeah, and there's a howto on that one as well already

[cpbb]

Yeah I looked at that, if you have a DB with large data in a field then you can come across problems with the import, sometimes you have to split the import or adjust MySQL accordingly with a command line switch..

BTW you can export any size data from phpMyadmin as far as I can tell, its just the import size thats restricted.

[Tom|420]

Of course there are two limits at importing data into phpMyAdmin:

1) PHP file upload size limit, when uploading the file (default is 2 MB I think)
2) Post size limit, as set into both the browser and the server (this one is probably a few mega-bytes, not much more -- there are colored discussions everwhere about what exactly is the limit here)

[cbhq]

Any ideas how one could move larger dbs when you dont have external access to the database?