Ok, I wanted to do a clean install of a commerce plugin, from a wordpress website I was working. Something happened with the database and messed up the website pretty bad. I had backed it up before, and was wondering how to restore my backup file. I uninstalled wordpress from the original database, deleted all the files, and removed the domain name from the server. I then, re-added the domain name to the server, added a new database, and went to phpmyadmin. I chose the database I created, and clicked on the import tab on the top and imported my backup file (.sql file). Now I see everything in my database again, but how do I get the website to show up?? There is nothing in my ftp for my website except the cgi-bin file.
Did you re-upload the script? The order I do it is.. backup the database... delete everything (files & database)... install the script normally on the new server... logon to phpmyadmin... connect to the new script's database... delete everything... restore your backup database. That way, you don't have to worry about editing any config files in the script.
I'm sorry, I'm not following you when you say re-upload the script. Do you mean addon my domain, and re-install wordpress? and then restore the database in phpmyadmin?
Right... install wordpress on the fresh server, then logon to phpmyadmin, delete everything, and restore. Since you're using wordpress, you could also do it the other way... create a fresh database with the backup, then install the script and edit the wp-config.php file to point to the new database.
Alright, that worked just fine, thanks for the help. Although non of my images saved .. bummer, I guess I have to get back to work.
The following actions were really not needed, and they created more problems than they "solved": "I uninstalled wordpress from the original database, deleted all the files, and removed the domain name from the server." If you mess up your database, all you need to do is restore it from your backup, no need to uninstall wordpress, delete all files, remove domain from server...
That's because the images aren't stored in the database, they're stored in the actual folders. If you have a backup of the files, you can pull them out from there and upload them to the new site.
alright thanks everyone for the responses. I have restored it successfully and re-up'd all the images etc.. Is there a way where I can easily just backup the whole database without having to ever re-up all the images again?
No.I think images are not stored in the database.So you will have to backup the images folder separately