Latest Articles tagged with database

How to Clean Up and Optimize Your WordPress Database

How to Clean Up and Optimize Your WordPress Database

Is your WordPress blog running a little slow? Sometimes all you need to do is give it a quick cleaning and optimize the database. Just like with your computer and Web browsers, your WordPress database gets filled with unneeded files like drafts, revisions, and spam comments. Luckily, removing them is a piece of cake.

How to Schedule Regular Database Backup to Dropbox

How to Schedule Regular Database Backup to Dropbox

Previously, I have shown you how to schedule a database backup using cron job and email yourself the database file, but if you have a big database, you will find that the emailing method might not work as well as you want it to be. A good alternative to this is to upload your database […]

How to Schedule Database Backup Using Cron Job

How to Schedule Database Backup Using Cron Job

For backing up of your WordPress database, there are plenty of plugins around that can get the job done. Some of them backup only your database while others backup the whole WP directory. If you have used WordPress long enough, you will realize that these plugins are not reliable. They will work one day and […]

OpenOffice Base – A Simple And Useful Database Management Tool

OpenOffice Base – A Simple And Useful Database Management Tool

When most people think OpenOffice, they think of word processing or spreadsheets. What many people do not realize is that OpenOffice also includes Base, a database system roughly equivalent to MS Access. Many businesses and individuals use these systems to allow even non-technical people to enter, store, retrieve and organize their data. Using Base, you […]

How to Clone Your Live WordPress Blog to a Local Server

How to Clone Your Live WordPress Blog to a Local Server

Bloggers, have you ever been in the situation where you want to make changes to your site (such as changing of theme, installing new plugins etc), but afraid that it will break your site? A lot of time, we wish to implement some changes and see how it looks like on the live site, without […]

7 Important Features That Should Be Part Of WordPress Core

7 Important Features That Should Be Part Of WordPress Core

I love WordPress. I love its user-friendliness and how easy you can get it installed and running within 5 mins. I love its extensibility and the plugin system that enable us to increase its functionality without any coding needed. However, despite all the love, WordPress is not perfect. There are plenty of times where you […]

The Safe Way to Change your WordPress Database Table Prefix

The Safe Way to Change your WordPress Database Table Prefix

Unless you have make an attempt to change the table prefix before installing your WordPress blog, chances are that your WP database is still using the default ‘wp_’ as the table prefix. With this default prefix, hackers can easily perform a SQL injection attacks on your database and wreak havoc to your site. The best […]