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
WP CSV to Database Plugin – Import Excel File Content into WordPress database (MySQL)
WP CSV to Database plugin allows you to insert CSV file content into WordPress database. Useful when you want to bulk upload data from your CSV file (e.g. product details) to the WordPress database (MySQL) in one go. If you didn't know what a CSV file is then you can learn more from … [Read more...] about WP CSV to Database Plugin – Import Excel File Content into WordPress database (MySQL)
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