Help moving mysql DB from one hosting company to another

Does anyone out there know how I could move a mysql database from one company to another? I basically want to do a copy and paste. Is this possible?

Thanks,

 

1. on the old server, from your MySQL Admin, do an "export" or "dump" (depends on which Admin the host has), including structure and data

2. download this file to your computer and then upload it to the new server

3. create a new MySQL database on the new server

4. import the "dump" or just cut and paste the SQL into your MySQL Admin SQL box and execute

If you have problems with this due to a big database, try searching for a utility called "BigDump" and use that.

 

minstrel - thanks! you helped me here too! have a ncie day

 

@ jawinn you can do proper mysql export via phpmyadmin if your company has one using : http://www.forums.a1whs.com/index.php?topic=13.0

Regards