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

4 votes171 views2 answers
Truncate oracle
SQL
0 vote218 views1 answer
Basic structure of sql expression having clause
SQL
0 vote172 views1 answer
Json not contains mysql
SQL
2 votes182 views4 answers
Mysql get all tables row count
SQL
1 vote201 views1 answer
Postgres count string length
SQL
1 vote187 views2 answers
Reset mysqli fetch_arra
SQL
0 vote192 views1 answer
Spark sql grows beyond 64 kb
SQL
1 vote181 views2 answers
Datetrunc hour snowflake
SQL
0 vote164 views1 answer
Import sql mysql ubuntu
SQL
11 votes266 views1 answer
Oracle insert from select
SQL