Duplicating a WordPress database makes you WordPress blog more flexible. Either you duplicate because you need a backup or you want to set up a development site for your themes or features, duplicating makes it hassle free.
A common duplicating method is to export a copy then re-import it into a new database on the same server. This is probably the easiest way before but things have changed.
Now we have an even better way to duplicate our WordPress database as quickly as possible.
This tip is based on phpMyAdmin operations so if your host is using a different way to manage databases, this is not for you.
Read the rest of the post here: http://wpmu.org/copy-wordpress-database/