- 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
Delete all records from a table in MySQLGet last 30 days records in MySQLCreate table in MySQLList all tables in a MySQL databaseSort MySQL resultsList databases on MySQL serverDelete records from MySQL tableFind MySQL data directory locationBackup MySQL schema onlyBackup MySQL data onlyCreate INSERT statement for each record with mysqldumpBackup MySQL databaseBackup only certain rows from MySQL databaseBackup only selected tables in MySQLBackup MySQL database without locking tablesSkip tables in MySQL backup
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