my sql数据库备份与恢复(国外英语资料).doc

my sql数据库备份与恢复(国外英语资料) This is useful if you only want to get an export of the structure of a table! - opt The same thing -- quick -- add -drop -table -- add-locks -- -- -- -- -- -- -- -- -- -- -- -- -- -- - tables. You should give you the fastest possible export of a MySQL server. -pyour_pass, -password [= your_pass] The password used when connecting to the server. If you dont specify the = your_pass section, mysqldump needs the password from the terminal. -p port_num, - port = port_num TCP/IP port number used when connecting to a host. (this is used to connect to a host outside localhost because it USES a Unix socket.) -q - quick Unbuffered queries are exported directly to stdout; Do it using mysql_use_result (). - S/path/to/socket, - socket = / path/to/socket The socket file used by the localhost connection (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 the data. Note: this works only when mysqldump is running on the same machine running on mysqld daemon. The format of the.txt file is determined according to the options of fields -xxx and -- lines -- XXX. -u user_name, -- user = user_name The user name that MySQL USES when connecting to the server. The default is your Unix login name. -o var = option, the set - variable var = option sets the value of a variable. The possible variables are listed below. -v, -verbose Verbose mode. Print out more information about what the program does. -v, - version Print version information and exit. -w, where = where - condition Only the records that are selected are exported; Note that quotes are mandatory! - where = jimf, - wuserid 1 -wuserid 1 The most common mysqldump USES a backup that might make the entire database: Mysqldump - opt database backup - file.sql But it also helps to enrich another MySQL database with information from one database: Mysqldump -- opt database | mysql --