Shell: mysqldump with only the table structure and no data

mysqldump -h localhost -u root -p --no-data --compact database_name > database_name.sql

Advertisements
Shell: mysqldump with only the table structure and no data

One thought on “Shell: mysqldump with only the table structure and no data

  1. Pretty nice article. I just stumbled upon your weblog and wished to say that I have really enjoyed surfing around your website articles. In any case I’ll be subscribing to your feed and I hope you write again soon! Sherwood Mynear

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s