MySQL Tricks

Contents

[ hide ]

  1. 1 Copy Database Table


Copy Database Table

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

?View Code BASH
1
2

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

This page is wiki editable click here to edit this page.