Two useful MySQL Import and Export commands

Today I have compiled two practical commands to easily solve the import and export problems.

First, export the command
1. Export the database
Mysqldump db_name-uroot-P>/path/db_name. SQL
2. Export a table in the database
Mysqldump db_name tb_name-uroot-P>/path/db_tb_name. SQL

Import command again
1. Import the SQL file of the database just backed up
MySQL db_name-uroot-P </path/db_tb_name. SQL

if you operate on a server, reproduce the preceding two commands
package the database backup file, compress the file, and transfer the file
tar zcvf db_name. SQL .tar.gz db_name. SQL
after it is transferred to the specified machine, unpackage again
tar zxvf db_name. SQL .tar.gz