Install mysqldump

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]

Install mysqldump

# Mysql
sudo apt-get install mysql-client
# MariaDB
sudo apt-get install mariadb-clients

Similar codes

0 vote296 views1 answer
Download sql file of countries names
SQL
5 votes280 views2 answers
Add days in oracle sql
SQL
0 vote244 views1 answer
Oracle get running queries
SQL
3 votes251 views1 answer
Export postgres database linux
SQL
1 vote253 views1 answer
How to use a trigger to validate input data
SQL
0 vote245 views1 answer
Mysql workbench not showing schemas
SQL
1 vote306 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote265 views1 answer
Mysql value ends with
SQL
0 vote250 views1 answer
Call procedure in wordpress
SQL
3 votes254 views3 answers
C# sql select
SQL