Mysql database import and export _ MySQL

Mysql database import and export databases:

1. Export the entire database structure and data
   • Mysqldump-h [ip]-u [user]-p [password] [database_name]> [table_name]. SQL;
2. Export the structure and data of a single data table
   • Mysqldump-h [ip]-u [user]-p [password] [database_name] [table_name]> [table_name]. SQL;
3. Export the entire database structure (excluding data)
   • Mysqldump-h [ip]-u [user]-p [password]-d [database_name]> [table_name]. SQL;
4. Export a single data table structure (excluding data)
   • Mysqldump-h [ip]-u [user]-p [password]-d [database_name] [table_name]> [table_name]. SQL;
5. Export data without exporting structure [if a lock table appears, add -- skip-lock-tables]
   • Mysqldump-h [ip]-u [user]-p [password]-t [database_name] [-w "pay_time> = '2017-08-14 00:00:00 '"]> xxx. SQL

Import data: if the database does not exist, create a database first. If yes, run source.../xxx. SQL