I had a wordpress blog with backupwordpress plugin which used to email me daily the sql file. The server is dead currently and i need to restore sql file in my new hosting. I installed wordpress in new hosting and then tried to restore the sql file through phpmyadmin. Success ! But no change in the site ! There were no posts displaying. Do the domain has to be same as in previous account ? I don't have whole site backup with plugin and theme. This should not cause the problem because i had restored wp sites before with only sql files. The difference is they were backed up from cpanel and this one is by plugin. Would be thankful if anyone could help
You need to check the config file for mysql info. Make sure it's connecting to the old databse instead of new empty db.
login to admin of your wp. go to tool > and export. xml file. then import it to your new wp in another hosting. have you try this way ?