MySQL DATA Integration

MySQL DATA Integration. MySQLDump: export the table structure and data: the command line usage is as follows :? Mysqldump-u uses the primary name-p password-d database name Script Name; 1. Export the table structure of the database as dbname (the primary name is root, the password is dbpasswd and the generated Script Name Is db. SQL) mysqldump-uroot-pdbpasswd-d

MySQL Data Set 1. MySQL Dump export table structure and data: the command line usage is as follows :? Mysqldump-u use the primary name-p password-d Data Warehouse name table name Script Name; 1. Export the table structure of the data warehouse as dbname (the primary name is root, the password is dbpasswd and the generated Script Name Is db. SQL) mysqldump-uroot-pdbpasswd-d

MySQL Data Set

I. MySQL Dump export table structure and data:

The command line is used as follows :? Mysqldump-u use the primary name-p password-d Data Warehouse name table name Script Name;

1. Export the table structure of the database named dbname (the database name is root, the password is dbpasswd, And the generated Script Name Is db. SQL)

Mysqldump-uroot-pdbpasswd-d dbname> db. SQL;

2. Export the data library as a dbname table (test) Structure

Mysqldump-uroot-pdbpasswd-d dbname test> db. SQL;

3. Export all table structures and table data records (without-d) in the database dbname)

Mysqldump-uroot-pdbpasswd? Dbname> db. SQL;

4. Export the data warehouse to dbname a table (test) structure and table data volume (without-d)

Mysqldump-uroot-pdbpasswd dbname test> db. SQL;