How to dump mysql database with out data?

Question

Hi need to dump my mysql database with views and sp's. But I don't need any data. How can I write mysqldump command for that?

Brian Webster · Accepted Answer · 2013-02-15 23:16:15Z

2

 -R, --routines Dump stored routines (functions and procedures).

edited Feb 15, 2013 at 23:16

Brian Webster

31k51 gold badges158 silver badges227 bronze badges

answered Aug 19, 2011 at 10:34

triclosan

5,7846 gold badges30 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Brian Webster · Accepted Answer · 2013-02-15 23:16:19Z

--no-data, -d Do not write any table row information (that is, do not dump table contents). This is useful if you want to dump only the CREATE TABLE statement for the table (for example, to create an empty copy of the table by loading the dump file).

Source: man mysqldump and mysqldump --help

Collectives™ on Stack Overflow

How to dump mysql database with out data?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related