OK so I’ve been experiencing difficulties with this blog going down. By a process of deduction i worked out that the SQL DB was messing things up, in particular the table wp_postmeta. This is a fix I worked out after failing other online how to’s. The db is restored here table by table as trying to do a buik upload fail time after time.
1. Search your hard drive for the SQL backup that you hope you did recently.
2. Breath a sigh of relief when you find it.
3. Delete your WP install off the server after having backed up images etc etc
4. Resinstall WP.
5. Open the SQL file you backed up into a nice test editor i.e. one that will wrap and colour etc so you can read it clearly. All the tables will be nicely commented to its easy to work out what’s what.
6. Log into phpMyAdmin
7. Select the first table to update ie that one that comes first in the SQL file (the order will match).
8. Copy n paste the contents of the SQL file for the relevant table into the querry box in phpMyAdmin. Hit run or ok… If all go’s well it will tell you. I’f it doesn’t go well this how to will be of now use to you so quit here and start again.
9. Repeat for each table except the table called wp_(optionalprfixforyourblog)postmeta as this is the one that is fucking things up. You may also not want to update the table called wp_(optionalprfixforyourblog)options for obviouis reasons as you have just done a fresh install.
NOTE: If you update the table wp_(optionalprfixforyourblog)users this will change the password to the old one. If you have forgotten it don’t worry, go to log in and follow the mail me my password option and you can get it back.
That is all.
0 Responses to “How to: Restore a corrupted (by Ultimate Tag Warrior) mySQL Wordpress databse hosted on 1and1 using phpMyAdmin”
Leave a Reply