Duplicating a mysql database

by Martin Westin in


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/