- 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
Backup only certain rows from MySQL databaseGet last 30 days records in MySQLCreate INSERT statement for each record with mysqldumpBackup MySQL data onlySkip tables in MySQL backupBackup MySQL database without locking tablesDelete all records from a table in MySQLBackup MySQL schema onlySort MySQL resultsCreate table in MySQLDelete records from MySQL tableBackup only selected tables in MySQLList all tables in a MySQL databaseBackup MySQL databaseFind MySQL data directory locationList databases on MySQL serverImport an SQL file using the command line in MySQLGroup by year of Unix timestamp in MySQLConvert INT to DATETIME in MySQLGet current year in MySQL
Network articles
Wrap selection with tag in VS CodeDisable tooltip in VS CodeToggle word wrap in VS CodeReplace spaces with dashes in PHPChange bullet size in HTMLCheck if a string ends with number in JavaScriptCapitalize words in a string using JavaScriptGenerate random color with JavaScriptToggle fullscreen and normal mode with JavaScriptExecute code after the page is loadedSet cursor to crosshair in CSSOpen files always in a new tab in VS CodePHP form data into arrayConvert PHP string to int valueLink to a section on the same pageRedirect all requests to index.php using htaccessSetup Twitter Meta TagsGet the last Friday of a month in JavaCheck if element is hidden in JavaScriptGet actual date in Java