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]

Source: grepper.com

Mysqldump

mysqldump -u [username] -p [database-to-dump] > filename(e.g. dump.sql)

# or 
sudo mysql database_name > filename

Source: grepper.com

Mysqldump

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

Source: grepper.com

Similar codes

0 vote196 views1 answer
Android sqlite get rows count
SQL
-1 vote202 views1 answer
Round up and down sql
SQL
0 vote241 views4 answers
Sql server date format yyyy-mm-dd
SQL
1 vote216 views1 answer
Mysql dump specific tables
SQL
4 votes245 views1 answer
Mysql delete last row
SQL
0 vote209 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
17 votes233 views1 answer
Selecting name that contain certain word in sql
SQL
10 votes266 views2 answers
Reset mysql root password mac
SQL
4 votes193 views1 answer
Create db table
SQL
0 vote217 views2 answers
Reseed sql identity
SQL