Re: Can you migrate a MySql database between hosts?
If you're using phpMyAdmin just click 'Export' from the top menu, then under 'Export' on the left of the page highlight which tables you want to export and tick 'SQL'
At the bottom, tick 'Save as file' and whether you want it compressed (zipped or gzipped) or uncompressed and click go, and save it on your local drive.
You then have a .sql file which can be used to rebuild the database on another host.
If you use a text editor to open the .sql file you have saved you will see what it contains
__________________
I'm no good at judging the size of crowds Ted, but I'd say there's about seventeen million of them out there.
|