- 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
Get last 30 days records in MySQLDelete all records from a table in MySQLCreate table in MySQLSort MySQL resultsCreate INSERT statement for each record with mysqldumpBackup MySQL data onlyBackup MySQL database without locking tablesBackup only certain rows from MySQL databaseList all tables in a MySQL databaseDelete records from MySQL tableBackup MySQL schema onlyList databases on MySQL serverBackup only selected tables in MySQLSkip tables in MySQL backupBackup MySQL databaseFind MySQL data directory location
Network articles
Add key prop to React fragmentWrite vertical text in HTMLTest with multiple data using PHPUnitRemove HTML tags from a string in PHPWrite comments in CSSPHP form data into arrayPHP Array tutorialPHP heredoc syntaxConvert binary to decimal in PHPCreate mailto link with pre-populated contentSet cursor to pointer in CSSSet media query in CSSAutomatically redirect HTTP to HTTPS on Apache webserversSet selected element in a drop down listGet the last day of a month in JavaGet the number of days between two dates in JavaAdd CSS class based on condition in ThymeleafUse foreach in JavaScriptReplace spaces with dashes in JavaScriptGet month name from Date in JavaScript