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 vote70 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
1 vote94 views2 answers
Mysql type conversion
SQL
0 vote113 views1 answer
How to export only procedures mysql
SQL
1 vote65 views1 answer
Athena query timestamp greater than
SQL
0 vote111 views2 answers
Mysql decimal remove trailing zeros
SQL
1 vote126 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
3 votes115 views4 answers
Show databases in sql server
SQL
1 vote104 views1 answer
Drop df constraint sql server
SQL
-1 vote112 views1 answer
How to create foreign key in sql server management studio
SQL
-1 vote116 views3 answers
Psql get last rows
SQL