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

57 votes464 views5 answers
How to create a new user in postgresql
SQL
36 votes340 views6 answers
Change column data type sql
SQL
0 vote282 views1 answer
Delete first row in sql
SQL
0 vote289 views1 answer
Psotgres multiple values
SQL
0 vote318 views2 answers
Pl sql auto increment
SQL
0 vote259 views1 answer
How to remove default in mysql
SQL
1 vote296 views2 answers
Sql split string by space
SQL
24 votes293 views5 answers
Import dump mysql
SQL
0 vote269 views1 answer
Sql not exists
SQL
0 vote264 views1 answer
Change schema of all tables postgres
SQL