Need some advice/help with transferring a MySQL Db

Hey

I am transferring a site to a new server and cannot seem to figure out how to transfer the MySQL Db

Can someone here give me a hand?

Thanks!

 

Are you using CPanel?

 

Yes I am using cPanel - thanks for the quick reply here

 

OK, you need to click on MySQL databases, and then right at the bottom you should find a link for phpmyadmin - once logged in select your database, and select export.

Another option is to go to backups and download from there

 

For some reason the cpanel where the site is originally located doesnt have the backup icon.

I tried the export and was able to DL the file to my hard drive in .gz format (from phpmyadmin) but whenever I try to import it into the new server/hosting acct I keep getting errors.

 

What errors are you getting?

 

When you click on export, don't click save to file it will open up a window with all your tables and other info you could CTRL & A and then copy and paste it into a notepad file and save it with an 'sql' extension on your desktop. Try uploading it that way.

 

Here is the error message: (I replaced actual DB info with *****)

 

I just tried it that way and got the same error message - I went to phpmyadmin and clicked on 'import'

 

That error message is usually a result of attempting to access your server/sql without specifying a valid username and password.

Is this a dedicated/vps server or are you in reseller account?

 

It is a reseller account - my own - and I am logged in using this particular accounts credentials - else it wont let me access phpmyadmin

Perhaps I should create the user and password in the MY SQL first?

 

Sorry i meant your mysql u/name and p/word.

 

OK so I went to the My SQL page and created the user and password for the DB. Tried the import again and got the same error message. I am at a loss as to what needs to be done.

 

yes you need to create the DB first and then import

 

OK I did that this time. I got a different error:

 

I've just PM'd you

 

Hi, all done for you

 

kent

Delete the database
Create it again
Creat a user with pass
Associate it with the database
Import!

*For others who may be in similar situation.