Can you migrate a MySql database between hosts?

[artistri]

I want to transfer one of my sites between hosts. How can i move the database to prevent the site from being lost?

Now i'm pretty stooopid but i'm sure this is possible.

[t4xi--]

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

[artistri]

I've never actually used phpmyadmin so will download a copy and give it a twirl...

Cheers

[t4xi--]

I thought most hosting packages came with phpmyadmin already installed?

[Barry]

Had to do it recently and had SQLyog recommened to me by someone on the forum.

You can find it at Free MySQL GUI Client Tools. Monitor and Manage MySQL

Its Free!!! And it rocks!!!!!!!!

Ta

Barry