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 vote175 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote169 views1 answer
Mysql to get column name in database
SQL
1 vote201 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote191 views1 answer
Get created time of database psql 8
SQL
0 vote177 views1 answer
Mysql get last 2 month data
SQL
3 votes171 views2 answers
Install mysql powershell
SQL
0 vote175 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote169 views2 answers
How do I install microsoft SQL on my Mac?
SQL
4 votes189 views2 answers
Oracle unlock account
SQL
0 vote167 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL