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

-1 vote177 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote160 views1 answer
'0000-00-00' for column '
SQL
3 votes185 views2 answers
Install mysql powershell
SQL
0 vote203 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote193 views1 answer
Compare field sql server
SQL
0 vote177 views1 answer
Resulting Query
SQL
0 vote175 views1 answer
How to add session data into mysql database from button
SQL
0 vote175 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
1 vote186 views1 answer
Oracle drop job if exists
SQL
0 vote171 views1 answer
Pl sql search saurce code
SQL