Mysqldump structure only

Mysqldump

# Syntax
mysqldump -u [username] -p [database-to-dump] > [database-to-receive]

# Pipe it! Exporting DB from external host
mysqldump -u [username] -P [port] -h [host] [database-to-dump] | mysql -u root -h 127.0.0.1 [database-to-receive]

# Export specific tables by typing the name after the targeted DB
mysqldump -u [username] -P [port] -h [host] [database-to-dump] [tabl1] [table2] [table3] | mysql -u root -h 127.0.0.1 [database-to-receive]

Mysqldump structure only

mysqldump --no-data -u someuser -p mydatabase

Source: electrictoolbox.com

Mysqldump

mysqldump -u [username] -p [database-to-dump] > [database-to-receive].sql

-1

Similar codes

0 vote129 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
2 votes135 views3 answers
Application.properties spring boot mysql
SQL
-1 vote108 views1 answer
How to format tables in sqlplus
SQL
1 vote123 views2 answers
How to drop a unique constraint in sql
SQL
1 vote122 views1 answer
Increase existing date in sql
SQL
0 vote112 views1 answer
Oracle locked objects
SQL
2 votes121 views4 answers
Mysql get all tables row count
SQL
2 votes121 views1 answer
Oracle table size
SQL
4 votes114 views2 answers
Oracle default date format
SQL
0 vote119 views1 answer
Turn on foreign keys check mysql
SQL