This is another MySQL trick I keep coming back to.
mysqldump -u root --password=pass db1 | mysql -u root --password=pass db2
found @ http://mywheel.net/blog/index.php/2006/01/05/mysql-duplicate-database-quick-tip/
Duplicating a mysql database
Oct 8, ’08 6:55 PM
