Mysqldump selecting tables only

From MyWiki
Revision as of 11:20, 2 November 2015 by George2 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
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