You’ll have to make sure the file wp-config.php has the correct database name as well as database username and password.
Yeah, already done that but no effect
Install a clean version of WordPress. Then upload your database backup to your new webhost. Make sure the credentials match.
http://codex.wordpress.org/Moving_WordPress
Um, what did you upload to PHPmyadmin ?
All that will do is restore your database,
You’ll still need the actual files (wp-config.php / wp-content folder) to be installed into a WordPress installation to get all your old stuff back.
That WP DB Backup Plugin only backs up your Database, not your theme files / plugins / uploaded content.
Ah, that explains it then, the only file I have is the backup…pretty pointless plugin if you need other files for it to be any use if you lose your site completely. I had been religiously using it to back up every week thinking I would be covered if my site went down !!
Thanks for the info
It is a pretty good plugin for creating backups of your database, you only need to go the extra step to backing up the wp-content folder using a FTP client such as FileZilla.
Ok, but seems it would be easier to back up the whole site from CPanel if that’s the case.
Using cPanel is fine if that’s easier for you. Just note that you need to make a backup of your wp-content folder and the wp-config.php file.
Is that in addition to the CPanel site backup then?
I am just saying that cPanel may make a backup of your whole site when in actuality, you just need the wp-content folder and wp-config file backed up.
Has your problem been resolved?
It sounds like your original tables are present and not being overwritten by phpMyAdmin when you restored your database backup, which is why you’re still seeing the (I assume) Hello World post.
You’ll have to select all your tables starting with wp_ and “drop” them in phpMyAdmin. After that, try importing your backup again.
Just in case: If there’s any other applications using the database, be sure to back the database up again, in case you delete the wrong ones!
