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

3 votes300 views1 answer
Postgres select max value
SQL
8 votes304 views3 answers
SQL column name
SQL
3 votes283 views1 answer
Fk in insert mysql
SQL
3 votes248 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote243 views2 answers
Influxdb delete measurement based on date
SQL
3 votes378 views1 answer
Oracle cannot access v$session
SQL
-1 vote264 views3 answers
Mysql get age from date
SQL
0 vote297 views1 answer
Will graphql replace sql
SQL
0 vote246 views1 answer
Select all domains of database firbird
SQL
1 vote271 views1 answer
Sql server get users
SQL