Editing Backing Up and Transferring MySQL Tables

==Copy entire database==
Back up an entire database:
<syntaxhighlight lang="bash">
$ mysqldump -u user -p db-name > db-name-backup-YYMMDD.sql
</syntaxhighlight>

Copy the back up to a new database
<syntaxhighlight lang="bash">
$ mysql -u user -p db-name < db-name.outdb-name-backup-YYMMDD.sql
</syntaxhighlight>

==Copy a table from one database to another==
Create a table maintaining the engine, primary keys and indexes
<syntaxhighlight lang="mysql">
CREATE TABLE `dst_database`.`table_name` LIKE `src_database`.`table_name`;
</syntaxhighlight>

Populate table with data from a table in another database:
<syntaxhighlight lang="mysql">
INSERT INTO `dst_database`.`table_name` SELECT * FROM `src_database`.`table_name`;
</syntaxhighlight>

Note that these two statements are not supported by all MySQL Engine types though. InnoDB being one of them in MySQL ver 5.x

[[Category:MySQL]]
[[Category:MariaDB]]
[[Category:Web Development]]