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

9 votes117 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote144 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote115 views1 answer
Stored procedures example
SQL
2 votes109 views1 answer
SQL IF ELSE
SQL
1 vote103 views1 answer
Can not connect to mysql server
SQL
31 votes114 views1 answer
Postgresql add column with constraint
SQL
38 votes194 views6 answers
Ubuntu install mysql client
SQL
0 vote126 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote139 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote126 views1 answer
Delete hangfire retries list
SQL