Difference between revisions of "Mysqldump selecting tables only"

From MyWiki
Jump to: navigation, search
(Created page with "<source lang="text"> With mysqldump command you can specify certain tables of your database you want to backup. For example, to back up only php_tutorials and asp_tutorials ta...")
(No difference)

Revision as of 11:19, 2 November 2015

With mysqldump command you can specify certain tables of your database you want to backup. For example, to back up only php_tutorials and asp_tutorials tables from the 'Tutorials' database accomplish the command below. Each table name has to be separated by space.
$ mysqldump -u root -p Tutorials php_tutorials asp_tutorials > tut_backup.sql