25 September 2012 ~ 0 Comments

How to move very large WordPress MySQL Databases

I’ve been shifting some things around and came across several very large WordPress databases for a few projects I was hosting. The largest was 1.3GB or 317MB compressed (!) which obviously poses a problem. Most sites – even those of frequent bloggers – amount to well under…

Continue Reading

24 April 2012 ~ 0 Comments

How to Find and Replace Text on Every Post at your WordPress Website

There have been multiple instances where I’ve needed to go over a site with a sweeping “find and replace” statement, to replace instances of one phrase and replace it with another. For example, you can use it to replace the URLs…

Continue Reading

03 October 2011 ~ 0 Comments

Most Important SQL queries for WordPress Beginners

Before taking any step make a backup of your current WordPress database. How to make a backup of your WP database? You can use different WordPress Plugins like Smart Backup and WP-DB_Backup, Alternatively you can use phpMyAdmin…

Continue Reading

01 October 2011 ~ 0 Comments

5 Useful MySQL Queries for WordPress

MySQL is what runs behind 99.9% of all WordPress installs so with a little bit of SQL knowledge and some creativity, you could do some great stuff to grab all sorts of data directly from your WordPress database…

Continue Reading

08 June 2011 ~ 0 Comments

How to Add an Admin User to the WordPress Database via MySQL phpMyAdmin

Few days ago, we ran into an issue where a user’s site got hacked and their admin account was deleted from the database. This locked them out of their site without any other entry. We went in to the phpMyAdmin and created a new admin user to grant them access. In this article, we will show you a step by step guide on how to create an admin user in WordPress Database via MySQL…

Continue Reading

26 April 2011 ~ 0 Comments

How to Reset Your WordPress Password From the Database

From time to time you may encounter an unusual situation wherein you need to reset your WordPress password but you no longer (or never did) have access to the email address associated with your account. Perhaps you…

Continue Reading