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 vote146 views1 answer
Mysql min value row
SQL
0 vote143 views1 answer
Drop unique
SQL
0 vote193 views1 answer
Postgres rename database
SQL
2 votes142 views1 answer
Mysql change data type of column
SQL
0 vote138 views1 answer
Oracle session statistics
SQL
2 votes145 views1 answer
Use cases condition in sql query laravel
SQL
5 votes197 views1 answer
Oracle source query
SQL
3 votes135 views2 answers
Tsql join multiple record in one string
SQL
13 votes131 views2 answers
Oracle select into and inner join
SQL
10 votes162 views6 answers
Mysql set root password
SQL