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

12 votes381 views1 answer
Run mysql instance in docker
SQL
0 vote373 views1 answer
Get only one row in mysql
SQL
0 vote351 views1 answer
Oracle archivelog usage
SQL
0 vote382 views1 answer
How to change mysql root password in windows 10
SQL
0 vote339 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
4 votes364 views2 answers
Oracle default date format
SQL
0 vote320 views1 answer
Dump only schema
SQL
0 vote337 views1 answer
Sql server order by nulls last
SQL
0 vote361 views1 answer
Check if a column is a primary key in sql server
SQL
5 votes344 views1 answer
Find table from column name in sql
SQL