Uploading A Msql datbase to a different webserver?

As above, anyone got a tutorial on how to do this, ive downloaded the msql database to my desktop, but have no idea what to do now?

help would be appriciated

 

If you have cpanel, just use the SQL tab in phpmyadmin to run your sql file. If your sql file doesn't include the table definitions then you will have to create the tables first.

 

Thanks for info, i tried to upload it and got:

MySQL said: Documentation
#1044 - Access denied for user 'cloverde'@'localhost' to database 'killerdi_dir'

anyway of gaining access??

 

You should be able to create a dump file of your original database, in the dump file will have code to set up everything you need, just create the DB and upload the dump and you should be good.

Make sure your username / pw is all correct, and that you even have access in the first place, talk to your hosting company.

 

Ok ,but how to I create a dump file?

 

bacanze, do u have SSH access ?

 

I can create and populate your backup database to your new host for a mere $10 payable via paypal.

Please let me know if you are interested in this service. I am also willing to walk you through the steps that you can document for yourself while we complete the process

Rick

 

I would jump on everypcneed's offer if ya cant do it yourself.

 

I can give feedback for him. I have had great experiences with him in past. He is very legit work in timely manner and is very much affordable. Just a professional guy i would say

 

bacanze..I can complete this for you quite quickly with access to the sql dump file and MyPHPAdmin. Please contact me via PM if you still require assistance.

Rick

 

bacanze, if you have SSH in your new server then after you upload the mysql db to it and created a mysql db and user then do this..

I can help you out if you want as well, this should be really easy as long as you have SSH

Zac Louie

 

Most probably you did not give permission for the user to the database. merely creating the user/database is not enough. If you are not a tech. person, everypcneed's offer might be better.

 

If you have CPanel, go to the back up menu, and click in your database to download a back up of it, then go to your "new/other" host cpanel, and create a database, with the same name if you want" then go to phpmyadmin and select the database you just created :
1.- click the SQL button so that you can enter a sql text, extract the backup you downloaded to your hard drive, then open the extracted file with wordpad, copy and paste all that text to that SQL window and run the command.

OR

2.- Click the IMPORT link, and then import the file you extracted.