Run the following query on the database in PHPMyAdmin:
Deleting BuddyPress from a WordPress install
See this article: http://codex.buddypress.org/buddypress-site-administration/deleting-buddypress/ Refer to the article but the bottom line is delete any table with the WP_BP prefix.
Import and export WordPress post content with phpmyadmin
Taken from this support thread on the WordPress website: http://wordpress.org/support/topic/import-export-posts-with-phpmyadmin Obviously remember to download and upload the latest files onto the server…….. When exporting from the database make sure you include the following tables: wp_comments wp_links wp_posts wp_posts_meta
Remove Post Revisions through phpMyAdmin
Make sure you keep a good backup copy before proceeding with the amendments to your database. Also you can consider using a plugin to allow access to modify your db. Like this: WP-DBManager by Lester Chan. Be aware – you may need to change the name of the db tables for these commands to work Full Article…
Remove WordPress Multisite data
Lots of articles are written across the web about how one can use WordPress Multisite capabilities to power several blogs from one installation. This feature comes from WPMU being merged into WP. Recently I was working with a client, which was stucked in between of the process of setting up and wanted me to complete Full Article…
Move NextGen Galleries to a new server/domain
How to re-import database tables for the NextGen Gallery Plugin when moving your WordPress website to a new domain – so your photo galleries work again! Sometimes a website’s content needs to be moved to a new domain. If there are pictures and plugins involved, the process gets a little more complicated. I wanted to Full Article…
Mass Delete Pending Comments from WordPress
Run the Following SQL command on your database DELETE FROM wp_comments WHERE comment_approved = ‘0’
Delete Posts Revisions from Your Database
WordPress has a lot of good features and one of them is Post Revisions. This was included in WordPress 2.6, even though this is a good feature, it can cause some problems. One of them is increase the size of your database. Depending on how long it takes you to write a post, you might Full Article…