- Instant help with your Sql coding problems

Backup MySQL schema only

by Mike
Question:
How to backup MySQL schema only?
Answer:
mysqldump -u testuser -p --no-data testdb > /tmp/testdb_schema.sql

mysqldump -u [MYSQL_USER] -p --no-data [DB_NAME] > [OUTPUT_FILE]
Description:

Using the --no-data option with mysqldump it does 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).

Reference:
mysqldump no-data reference
Share "How to backup MySQL schema only?"
Related snippets:
Tags:
backup mysql schema, db schema only, export mysql schema
Technical term:
Backup MySQL schema only
Trending snippets
List all tables in a MySQL databaseCreate table in MySQLDelete all records from a table in MySQLSort MySQL resultsFind MySQL data directory locationList databases on MySQL serverGet last 30 days records in MySQLDelete records from MySQL tableBackup MySQL schema onlyBackup MySQL databaseBackup MySQL database without locking tablesBackup only selected tables in MySQLSkip tables in MySQL backupBackup MySQL data onlyCreate INSERT statement for each record with mysqldumpBackup only certain rows from MySQL database
Network articles
Get same day in the next week in PHPConvert timestamp to DateTime in PHPRemove HTML tags from a string except p, b, i and br in PHPGet current time in PHPSet text to italic with CSSAdd a box shadow to all side of an elementCreate a link to call phone numberPHP switch case statementPHP form tutorialGenerate random string with PHPPHP heredoc syntaxCache static content using htaccessSet cursor to pointer in CSSSetup Facebook Open Graph Meta TagsGet the last Friday of a month in JavaLazy loading images in HTMLCheck if element is hidden in JavaScriptGet the number of days between two dates in JavaAdd CSS class based on condition in ThymeleafCreate multiline string in JavaScript