Backing Up a Set of Tables
-t schema.tablename
– specify a table to include in the backup. You can use the-t
option multiple times.--table-file=filename
– specify a file containing a list of tables to include in the backup.--exclude-table-file=filename
– specify a file containing a list of tables to exclude from the backup.-s schema\_name
– include all tables qualified by a specified schema name in the backup. You can use the-s
option multiple times.- – exclude tables qualified by a specified schema name from the backup. You can use the
-S
option multiple times. --exclude-schema-file=filename
– specify a file containing schema names to exclude from the backup.