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 to Dropbox. Here is a simple script that you can use to backup your database to Dropbox.
[Read more...]
How to Schedule Regular Database Backup to Dropbox
By | February 1, 2012 | 2 Comments
How to Schedule Database Backup Using Cron Job
By | July 25, 2011 | 9 Comments
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 fail another day, for thousand and one reasons. It could be that they are not compatible with the new WordPress version that you have upgraded to, or that they are conflicting with a newly activated plugin. As in my case, it could also because your database is getting too big for them to handle.
Whatever the reasons, rather than relying on plugins, a better alternative is to use a cron job in your server and schedule it to backup your database everyday.
[Read more...]
OpenOffice Base – A Simple And Useful Database Management Tool
By | August 17, 2010 |
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 can follow simple steps to create an easy, user-friendly way for people to store and retrieve information using custom-designed forms and reports.
[Read more...]
How to Clone Your Live WordPress Blog to a Local Server
By | June 4, 2010 |
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 actually making it live. In such cases, the best solution is to create a local server (aka test server) and clone your live site to the local server. In this way, you can first test out the changes on your local server and make it live only when you have confirmed everything is working well.
[Read more...]
7 Important Features That Should Be Part Of WordPress Core
By | February 18, 2010 |
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 will wonder why a simple and basic feature is not included in the WordPress core and you have to go hunting for plugins/hacks/solutions just to solve a simple problem.
Take this as my letter to WordPress (and Matt Mullenweg) and I seriously hope they can add the following features to the core in the future.
Let’s begin!
[Read more...]
The Safe Way to Change your WordPress Database Table Prefix
By | November 7, 2009 |
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 way to prevent this from happening is to change the table prefix to another term that is difficult for hackers to guess.
If you are new to blogging and are looking to install your first WordPress blog, then it is easy. Simply change the $table_prefix entry in wp-config.php file, upload the file to the server, then proceed on with the famous 5-mins installation.
For those who have already been blogging for sometime, follow the method below to change your table prefix.
[Read more...]
8 Useful Tricks To Clean Up & Streamline Your WordPress Database
By | February 17, 2009 |
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 how to do or you are just plain lazy, here are 8 useful tricks that you can use to clean up your WordPress database easily and quickly.
