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 vote88 views1 answer
Plsql trigger insert update
SQL
1 vote121 views1 answer
How to between in sql
SQL
1 vote86 views1 answer
Mysql collation
SQL
0 vote151 views1 answer
Sqlite trim
SQL
0 vote123 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote141 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
23 votes152 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote124 views1 answer
Sql developer export connections
SQL
1 vote132 views3 answers
Epoch to datetime
SQL
1 vote184 views1 answer
Column with prefix in sql
SQL