How to dump only specific tables from MySQL?

If my database has 10 tables and I want to dump only 3 tables. Is it possible with mysqldump command?

mysql

176963 次浏览

小开

最佳答案

Usage: mysqldump [OPTIONS] database [tables]

也就是说。

mysqldump -u username -p db_name table1_name table2_name table3_name > dump.sql

小开

如果您在本地机器中，那么使用这个命令

/usr/local/mysql/bin/mysqldump -h127.0.0.1 --port = 3306 -u [username] -p [password] --databases [db_name] --tables [tablename] > /to/path/tablename.sql;

对于远程机器，使用以下一个

/usr/local/mysql/bin/mysqldump -h [remoteip] --port = 3306 -u [username] -p [password] --databases [db_name] --tables [tablename] > /to/path/tablename.sql;