Managing wordpress through SQL

April 17, 2007 | By The Best In Site Info, Technical Info |

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

Managing wordpress through SQL I have found is quite easy once you understand tables. Say you have one wordpress install configured the way you like categories links etc. You can copy the relevant tables to the new install.

I recently had the fortune of damaging an install and had to do this 1 table at a time as the BACKUP failed. Well that learnt me a great lesson. Now I am combining all my data this way so I can unilaterally copy my installs.

How I did this was I installed a new version of wordpress, I got the full backup and found that all I had to do was match up the sections in the tables to the sections in the database. I then exported each section of the database saved as a notepad file which is a backup now, copied over the user data and the rest of the stuff I wanted and imported it to the relevant table.

After doing this some of the features were a bit disassociated but that fixed easily each time I accessed a category or the like it re activated. The comments I just went back to the database after all the posts and pages were up and then I associated each with the right post, by changing the number as needed.

Difficulty-Level: Medium to Hard. I would not recomend the faint hearted do this full install like I had to this way without the aid of a net or a good backup TEST IT FIRST!!!

Difficulty-Level: Easy. However you can try it now one table at a time easily just make sure you can access phpmyadmin and can read and compare things such as wp_links with the same. So I did not get confused I saved the backups each as the name on the table in each domains backup folder locally. This is due to the fact I was working on 8 domains at the time.

If your stuck drop a line here I will try to help asap. JUST DO NOT delete anything we have the power to help. MAYBE… ;-)