Jiwei Wang’s Notepad

The first thing you have to consider after installing WordPress and starting writing is to backup and restore your database.  I started with WordPress Database Backup 2.1.5, which was rated highly on WordPress.org.  It turned out to cause me tremendous grief when migrating to a different server. The primary issue is that some tables are not properly dumped. For instance, Counterize II 2.10 tables could not be restored properly. The secondary problem is that it took so long to back up my database, over a minutes with almost 100% CPU (P4 3GHz).

So I started looking for a better database plugin.  And I’m very happy to find WP-DBManager 2.20 by Lester ‘GaMerZ’ Chan.  WP-DBManager  uses the standard MySQL utility mysqldump to do the job.  It took less than a second to dump my database. Most importantly, everything is restored ok on a different server. WP-DBManager  also provides other functions to manage the database dumps, optimization DB, repair DB and a dangerous Empty/Drop tables.  Lester ‘GaMerZ’ Chan knows his stuff. Well done!