How to Fix: WordPress Site not Working on Localhost After Port Change

If you have installed WordPress on localhost (example: using XAMPP) and then later you need to change the Apache’s HTTP port number, you will find that the existing WordPress installs will stop loading. It will auto redirect to the URL with the old port number and fail to load. Trying to load the WordPress install […]

How to Change the URL of a WordPress Site

Sometimes the URL or domain for a WordPress site is no longer appropriate. This could be for several reasons. Perhaps everything was setup using a different domain (like localhost) for testing purposes. Maybe, it was installed in a folder and now needs to shine at the root of the site. Maybe the domain has been […]

How to Take a DataBase Backup Using the All in One WP Security Plugin

Short of a config file or two, and a couple data folders, the WordPress database contains pretty much all of the settings and content for a WordPress web site. Everything from user data, categories, taxonomies, comments, settings, posts and more are stored in the database. It is being read from and written to regularly during […]

How to Easily Import or Export any of Your WordPress Database Table Content

I get asked a lot of questions on how to import or export data to or from a particular WordPress database table on a regular basis. For example: How can I export all my products details from a particular WordPress plugin to a CSV file? How can I bulk change data in some table? How […]

Database Recovery Techniques

Preventing data loss is one of the most critical issues involved in managing database systems. Data can be lost as a result of many different problems: Hardware failures Viruses Incorrect use of UPDATE and DELETE statements Software bugs Disasters, such as fire or flood To prevent data loss, you can implement a recovery strategy for […]

How to import WordPress SQL database backup file without having ‘create new database’ privileges in phpMyAdmin

In this article I have explained how you can import your WordPress SQL database backup file even when you do not have the ‘create new database’ privilege in phpMyAdmin. This is particularly useful when you are trying to import the SQL database as part of transferring your site from one host (old-host.com) to another host […]

How to Uninstall and Reinstall WordPress

In this post I have explained how you can uninstall and reinstall WordPress. You will rarely think about uninstalling/reinstalling WordPress on your site unless you start having ‘Apache security mod rewrite and htaccess’ issue like myself.  I decided to Reinstall WordPress on one of my sites after trying numerous fixes to solve the issue and […]