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 vote244 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote240 views1 answer
Sql server port 1434
SQL
0 vote249 views4 answers
Mysql desactivar trigger
SQL
0 vote244 views1 answer
Mariadb disable foreign key checks
SQL
-1 vote254 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote234 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
-1 vote322 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
1 vote246 views1 answer
Oracle insert multiple rows into same table
SQL
2 votes256 views1 answer
Mysql shell insert into
SQL
0 vote243 views1 answer
T sql cursor tr
SQL