Switched hosting. Database error.

My site is Here.(If that helps) I backed up all the content and found the database I need.

That is the file I am trying to upload.

Thats all the steps I am taking then pushing upload.

That is the error message.
What went wrong???
Any help would be awesome,
Noc

 

Hiya Noc

You need to first make a new database, then upload the sql file (I assume you have done this from your post.

Next after you have downloaded all of your wordpress files open up wp-config.php and change the old database details to your new database details)

Then upload all files.

If you have already uploaded the wordpress files just open up the wp-config.php file from within your hosting and edit it.

Hope this helps

p.s. Just reread you post and the easiest way to upload a sql file is in phpmyadmin, I am not sure this is where you are trying to upload it already.

Clare

 

Thank you so much for a quick response. I will try that! Plus Rep+!

 

Wait I don't want to loose all my posts and everything!

 

Hiya Noc Make sure you have everything backed up, most importantly the sql file and your wordpress files before you delete or touch any databases.

As long as you have your back-ups you will be fine.

I assume that your first problem is actualy uploading the sql file??

If so then try uploading it in phpmyadmin..

If you are still having problems then give me a pm and I will see if I can help you, I move Wordpress sites around at least a couple of times a week.

Clare

 

What is PHPMyAdmin. I am using direct admin.

 

Hiya Noc do you have cpanel in your hosting?

If so look for the phpmyadmin.

I am also assuming that you have made a new database in your new hosting. If not this is the first thing you must do. Then make a new database user and password and take note of these details.

Then go to phpmyadmin in your cpanel, look for your new database that you made and upload your sql file to there.

clare

 

No. I have a VPS, and am using direct admin.

 

Think I kind of figured it out thanks so much!!!

 

Is this what your direct admin looks like



Not sure if that pic works lol but I am pretty sure you have got phpmyadmin. Just have a little look around your direct admin.

If the picture does work then I have put a red circle around where you will find it lol.

Clare

EDIT: wow pic did work didn't realize it would be that big lol

 

You are uploading a .sql file when it is a .gz file for the backup. Login to phpmyadmin and upload and import it from there.

 

Ya haha i figured it out thanks guys!