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 … [Read more...] about How to Fix: WordPress Site not Working on Localhost After Port Change
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 … [Read more...] about How to Change the URL of a WordPress Site
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 … [Read more...] about How to Take a DataBase Backup Using the All in One WP Security Plugin
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 can I … [Read more...] about How to Easily Import or Export any of Your WordPress Database Table Content
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 … [Read more...] about Database Recovery Techniques
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 … [Read more...] about How to import WordPress SQL database backup file without having ‘create new database’ privileges in phpMyAdmin
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 … [Read more...] about How to Uninstall and Reinstall WordPress