MySQL Tricks

Copy Database Table

How to copy a large database table to another database from the command line

1
2
$ mysqldump -u username database table > table.sql
$ mysql -u root other-database < table.sql

Post a comment