Wednesday, March 11, 2009

copy mysql tables

mysql> create database db2; \! /usr/local/mysql/bin/mysqldump -u root –password=pass db1 | /usr/local/mysql/bin/mysql -u root –password=pass db2

originally seen on: http://mywheel.net/blog/index.php/2006/01/05/mysql-duplicate-database-quick-tip/
Post a Comment