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

2 votes294 views2 answers
Run mysql command from bash
SQL
12 votes291 views4 answers
Mysql get date difference in hours
SQL
1 vote289 views1 answer
Postgresql delete cascade
SQL
0 vote282 views1 answer
Mod in sql
SQL
0 vote328 views1 answer
SQL joins in python
SQL
2 votes343 views1 answer
Find column in all stored procedures sql server
SQL
22 votes360 views1 answer
Mysql workbench
SQL
0 vote278 views1 answer
Implizite joins sql
SQL
0 vote293 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote273 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL