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…
Read more »
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…
Read more »
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…
Read more »
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…
Read more »
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…
Read more »
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…
Read more »
Being a database-driven software, the performance of your WordPress blog is closely related to how efficient your database is. The bigger and messier your database is, the slower is the performance of your blog. If you have not been doing regular housekeeping and database maintenance, either because you don’t know…
Read more »
