mysql 表數據轉儲

For this exercise, we will use the mysqldump utility the same as if we were backing up the entire database.

在本練習中，我們將像備份整個數據庫一樣使用mysqldump實用程序。

Syntax:

句法：

mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql

mysqldump -d -h localhost -u root -pmypassword數據庫名> dumpfile.sql

The only option that is different than creating an entire backup is the -d switch, which tells mysqldump not to output the data.

與創建整個備份不同的唯一選項是-d開關，它告訴mysqldump不要輸出數據。

Example:

例：

mysqldump -d?-h localhost -u root -p2Uad7as9 database01 > dumpfile.sql

mysqldump -d -h localhost -u根-p2Uad7as9 database01> dumpfile.sql

翻譯自: https://www.howtogeek.com/howto/programming/mysql/dump-just-the-table-structure-to-a-file-in-mysql/

mysql 表數據轉儲