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 vote202 views1 answer
C# add a textbox in mysql select
SQL
0 vote200 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
-1 vote202 views1 answer
Mac mysql workbench console
SQL
0 vote166 views1 answer
Login phpmyadmin without password
SQL
2 votes214 views1 answer
Use cases condition in sql query laravel
SQL
8 votes197 views2 answers
Mysql query dates between two dates
SQL
5 votes211 views2 answers
To date oracle
SQL
0 vote249 views1 answer
Mysql c commands
SQL
0 vote244 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
1 vote203 views1 answer
Sometimes i cant edit sql developer
SQL