Welcome To Ask or Share your Answers For Others

mysql - mysqldump data only

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

I am looking for the syntax for dumping all data in my mysql database. I don't want any table information.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

790 views

Welcome To Ask or Share your Answers For Others

1 Answer

answered Oct 17, 2021 by 深蓝 (71.8m points)

mysqldump --no-create-info ...

Also you may use:

--skip-triggers: if you are using triggers
--no-create-db: if you are using --databases ... option
--compact: if you want to get rid of extra comments

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

...