Mysqldump: dumping only one table

From lxadm | Linux administration tips, tutorials, HOWTOs and articles
Jump to: navigation, search

To dump just one table from a given database, use:

mysqldump --opt --single-transaction databasename tablename > database-table.sql


Similarly, to dump more selected tables:

mysqldump --opt --single-transaction databasename tablename1 tablename2 > database-tables.sql