Today, I looked at the manual and tried it. I found that importing and exporting big data is so easy (not very large, with more than 200 MB of text) Note: If a prompt such as MySQL Unknown command '/' is found, set the server character set, for example: Mysql-uroot-ppasspass -- default-character-set = utf8 databasename <D: bakcup. SQL In this way, no error will be reported, ^ _ ^ Export: (mysqldump) CMD> RUN MySQL installation directory to enter the bin directory! Mysqldump-u root-P database_name> D: backup/bak_ SQL _name. SQL Then press enter (where-u MySQL user-P is the password (blank) database_name is the data name to be backed up,> the address is later !) For detailed parameters, see the official manual! Import: (MySQL) In the bin directory of MySQL, type mysql-u root-P database_name <D: backup/bak_ SQL _name. SQL If you are prompted to enter the correct password, it will be OK! You can also type mysql-u root-P (log on to the MySQL console and use the source or/. Command to import it !) Mysql> source D: backup/bak_ SQL _name. SQL Mysql>/. D: bakcup/bak_ SQL _name. SQL Examples of mysqldump usage P.m.
======================================
Several common use cases: 1. Export the entire database
Mysqldump-u username-P Database Name> exported file name
Mysqldump-u wcnc-P smgp_rj_wcnc> wcnc. SQL
2. Export a table
Mysqldump-u user name-P database name Table Name> exported file name
Mysqldump-u wcnc-P smgp_rj_wcnc users> wcnc_users. SQL
3. Export a database structure
Mysqldump-u wcnc-p-d -- add-drop-Table smgp_apps_wcnc> D: /The wcnc_db.sql-d has no data -- add-drop-table add a drop table4. language parameter before each create statement export mysqldump-uroot-p -- default-character-set = Latin1 -- Set-charset = GBK -- skip-opt Databse> d4.sql5. import Database
Common source commands
Go to the MySQL Database Console,
For example, MySQL-u root-P
Mysql> Use Database and then use the source command. The following parameter is a script file (for example,. SQL used here)
Mysql> source D:/wcnc_db. SQL |
Mysqldump supports the following options:
-Add-locks
Add lock tables and unlock table before each table is exported. (To make it faster to insert data to MySQL ). -Add-drop-table
Add a drop table before each create statement. -Allow-keywords
Names of columns allowed to be created as keywords. This is done by the table name prefix on each column name. -C,-complete-insert
Use the complete insert Statement (with the column name ). -C,-compress
If both the client and server support compression, all information is compressed between the two. -Delayed
Use the insert delayed command to insert rows. -E,-extended-insert
Use the new multiline insert syntax. (A more compact and faster insert statement is provided) -#,-Debug [= option_string]
Tracking Program usage (for debugging ). -Help
Displays a help message and exits. -Fields-terminated-by =... -Fields-enclosed-by =... -Fields-optionally-enclosed-by =... -Fields-escaped-by =... -Fields-terminated-by =... These options are used with-T options and have the same meaning as the load data infile clause.
Load data infile syntax. -F,-flush-logs
Wash Out the log files on the MySQL server before starting the export. -F,-force,
Even if we get an SQL error while exporting a table, continue. -H,-host = ..
Export data from the MySQL server on the named host. The default host is localhost. -L,-lock-tables.
Lock all tables for start export. -T,-no-create-Info
Create table statement) -D,-no-Data
No row information is written to the table. If you only want to export the structure of a table, this is very useful! -OPT
Same as-quick-add-drop-table-add-locks-extended-insert-lock-tables.
You should be given the fastest export possible for reading a MySQL server. -Pyour_pass,-Password [= your_pass]
The password used to connect to the server. If you do not specify "= your_pass", mysqldump requires a password from the terminal. -P port_num,-Port = port_num
The TCP/IP Port used to connect to a host. (This is used to connect to a host other than localhost because it uses UNIX sockets .) -Q,-quick
Directly export the data to stdout without buffering the query; Use mysql_use_result () to do it. -S/path/to/socket,-socket =/path/to/socket
The socket file used when connecting to localhost (which is the default host. -T,-tab = path-to-some-directory
For each given table, create a table_name. SQL file that contains the SQL CREATE command and a table_name.txt file that contains data. Note: This only works when mysqldump runs on the same machine where the mysqld daemon is running .. The format of the TXT file is determined by the-fields-xxx and-lines-xxx options. -U user_name,-user = user_name
The username used by MySQL to connect to the server. The default value is your UNIX login name. -O Var = option,-set-variable VAR = Option
Set the value of a variable. Possible variables are listed below. -V,-verbose
Lengthy mode. Print out more information about the program. -V,-version
Print the version information and exit. -W,-where = 'where-condition'
Only selected records are exported. Note that the quotation marks are mandatory!
"-Where = user = 'jimf '" "-wuserid> 1"-wuserid <1 ″ The most common use of mysqldump may make a backup of the entire database:
Mysqldump-opt database> backup-file. SQL However, it is also useful for enriching another MySQL database with information from one database:
Mysqldump-opt database | mysql-host = remote-host-C Database
Mysqldump exports complete SQL statements, so it is easy to import data into MYSQL client programs: Shell> mysqladmin create target_db_name
Shell> MySQL target_db_name <backup-file. SQL
Yes
Shell> MySQL database name <file name |
