Transfering Database from host to host. how?

Hi,

I want to switch my host and I'm not too sure how to do that. I have one mysql database and I wish to transfer that. I don't have the command line, so I'm guessing there is a way to do it with CPanel?

 

in backup, you should be able to download a backup ofthe db, that you can upload on your new host or you can do it via phpmyadmin as shown here:

http://www.siteground.com/tutorials/php-mysql/mysql_export.htm

 

If its under 50MB, you should be able to use phpMyAdmin in cPanel without a problem. Otherwise, it'll take a longtime and instead, can be easily done through command line.

 

if you using cpanel i'm sure there is a menu where you can backup all of your site into a zip file

 

1. Log in your phpMyAdmin in your old web host
2. Click the Export link
3. In the next step select dababase(s) which you want to export. Press CTRL to select more databases.
4. Tick the Save in file field
5. Click the Go button
6. Log in your phpMyAdmin in your new web host
7. Click the SQL icon (in the left frame)
8. Click Import files link
9. Select the path to the file which you downloaded in steps 1 - 5
10. Click the Go button

Your database should be successfully transfered now.