- 浏览: 329130 次
- 性别:
- 来自: 深圳
文章分类
最新评论
-
zhengqiweiyi:
请问这里的客户端和服务器是指同一台电脑上的吗?
JSP动态显示服务器时间和客户端时间 -
18101095336:
一语道破天机[color=blue][/c ...
restlet使用中遇到的一些问题 -
jjjssh:
废话一大堆,就是没说到少了那个jar包
The hierarchy of the type is inconsistent -
junjielee:
重点还没说啊~~~~~~~~
The hierarchy of the type is inconsistent -
幽绿琵琶:
太棒了
loadrunner 9.5 9.0 8.1下载地址 和license
备份脚本:mysql-dump.sh
#!/bin/bash export MYSQL_HOME=/usr/local/Percona-Server-5.5.21-rel25.0-227.Linux.x86_64/ export PATH=$MYSQL_HOME/bin:$PATH mysql_dump_dir=/data/backup/mysqldump mysql_username="YOURS" mysql_password="YOURS" mysql_databases="DBNAME1 DBNAME2 DBNAME3" timeStart=$(date '+%Y%m%d%H%M%S') sqlfile=$mysql_dump_dir/dump-$timeStart.sql mysqldump --opt --user=$mysql_username --password=$mysql_password -B $mysql_databases --max_allowed_packet=1048576 --net_buffer_length=16384 > $sqlfile
恢复时:使用root账号登陆到mysql命令行,执行:
source /data/backup/mysqldump/dump-20120629181412.sql
或者直接在linux的终端输入以下命令也可以
mysql -uYOURS -pYOURS -e"source /data/backup/mysqldump/dump-20120629181412.sql"
mysqldump参数:
--add-drop-database | add-drop-database | Add a DROP DATABASE statement before each CREATE DATABASE statement | ||
--add-drop-table | add-drop-table | Add a DROP TABLE statement before each CREATE TABLE statement | ||
--add-locks | add-locks | Surround each table dump with LOCK TABLES and UNLOCK TABLES statements | ||
--all-databases | all-databases | Dump all tables in all databases | ||
--allow-keywords | allow-keywords | Allow creation of column names that are keywords | ||
--apply-slave-statements | apply-slave-statements | Include STOP SLAVE prior to CHANGE MASTER statement and START SLAVE at end of output | 5.5.3 | |
--bind-address=ip_address | bind-address | Use the specified network interface to connect to the MySQL Server | 5.5.8 | |
--comments | comments | Add comments to the dump file | ||
--compact | compact | Produce more compact output | ||
--compatible=name[,name,...] | compatible | Produce output that is more compatible with other database systems or with older MySQL servers | ||
--complete-insert | complete-insert | Use complete INSERT statements that include column names | ||
--create-options | create-options | Include all MySQL-specific table options in CREATE TABLE statements | ||
--databases | databases | Dump several databases | ||
--debug[=debug_options] | debug | Write a debugging log | ||
--debug-check | debug-check | Print debugging information when the program exits | ||
--debug-info | debug-info | Print debugging information, memory and CPU statistics when the program exits | ||
--default-auth=plugin | default-auth=plugin | The authentication plugin to use | 5.5.9 | |
--default-character-set=charset_name | default-character-set | Use charset_name as the default character set | ||
--delayed-insert | delayed-insert | Write INSERT DELAYED statements rather than INSERT statements | ||
--delete-master-logs | delete-master-logs | On a master replication server, delete the binary logs after performing the dump operation | ||
--disable-keys | disable-keys | For each table, surround the INSERT statements with statements to disable and enable keys | ||
--dump-date | dump-date | Include dump date as "Dump completed on" comment if --comments is given | ||
--dump-slave[=value] | dump-slave | Include CHANGE MASTER statement that lists binary log coordinates of slave's master | 5.5.3 | |
--events | events | Dump events from the dumped databases | ||
--extended-insert | extended-insert | Use multiple-row INSERT syntax that include several VALUES lists | ||
--fields-enclosed-by=string | fields-enclosed-by | This option is used with the --tab option and has the same meaning as the corresponding clause for LOAD DATA INFILE | ||
--fields-escaped-by | fields-escaped-by | This option is used with the --tab option and has the same meaning as the corresponding clause for LOAD DATA INFILE | ||
--fields-optionally-enclosed-by=string | fields-optionally-enclosed-by | This option is used with the --tab option and has the same meaning as the corresponding clause for LOAD DATA INFILE | ||
--fields-terminated-by=string | fields-terminated-by | This option is used with the --tab option and has the same meaning as the corresponding clause for LOAD DATA INFILE | ||
--first-slave | first-slave | Deprecated; use --lock-all-tables instead | 5.5.3 | |
--flush-logs | flush-logs | Flush the MySQL server log files before starting the dump | ||
--flush-privileges | flush-privileges | Emit a FLUSH PRIVILEGES statement after dumping the mysql database | ||
--help | Display help message and exit | |||
--hex-blob | hex-blob | Dump binary columns using hexadecimal notation (for example, 'abc' becomes 0x616263) | ||
--host | host | Host to connect to (IP address or hostname) | ||
--ignore-table=db_name.tbl_name | ignore-table | Do not dump the given table | ||
--include-master-host-port | include-master-host-port | Include MASTER_HOST/MASTER_PORT options in CHANGE MASTER statement produced with --dump-slave | 5.5.3 | |
--insert-ignore | insert-ignore | Write INSERT IGNORE statements rather than INSERT statements | ||
--lines-terminated-by=string | lines-terminated-by | This option is used with the --tab option and has the same meaning as the corresponding clause for LOAD DATA INFILE | ||
--lock-all-tables | lock-all-tables | Lock all tables across all databases | ||
--lock-tables | lock-tables | Lock all tables before dumping them | ||
--log-error=file_name | log-error | Append warnings and errors to the named file | ||
--master-data[=value] | master-data | Write the binary log file name and position to the output | ||
--max_allowed_packet=value | max_allowed_packet | The maximum packet length to send to or receive from the server | ||
--net_buffer_length=value | net_buffer_length | The buffer size for TCP/IP and socket communication | ||
--no-autocommit | no-autocommit | Enclose the INSERT statements for each dumped table within SET autocommit = 0 and COMMIT statements | ||
--no-create-db | no-create-db | This option suppresses the CREATE DATABASE statements | ||
--no-create-info | no-create-info | Do not write CREATE TABLE statements that re-create each dumped table | ||
--no-data | no-data | Do not dump table contents | ||
--no-set-names | no-set-names | Same as --skip-set-charset | ||
--no-tablespaces | no-tablespaces | Do not write any CREATE LOGFILE GROUP or CREATE TABLESPACE statements in output | ||
--opt | opt | Shorthand for --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset. | ||
--order-by-primary | order-by-primary | Dump each table's rows sorted by its primary key, or by its first unique index | ||
--password[=password] | password | The password to use when connecting to the server | ||
--pipe | On Windows, connect to server using a named pipe | |||
--plugin-dir=path | plugin-dir=path | The directory where plugins are located | 5.5.9 | |
--port=port_num | port | The TCP/IP port number to use for the connection | ||
--quick | quick | Retrieve rows for a table from the server a row at a time | ||
--quote-names | quote-names | Quote identifiers within backtick characters | ||
--replace | replace | Write REPLACE statements rather than INSERT statements | ||
--result-file=file | result-file | Direct output to a given file | ||
--routines | routines | Dump stored routines (procedures and functions) from the dumped databases | ||
--set-charset | set-charset | Add SET NAMES default_character_set to the output | ||
--single-transaction | single-transaction | This option issues a BEGIN SQL statement before dumping data from the server | ||
--skip-add-drop-table | skip-add-drop-table | Do not add a DROP TABLE statement before each CREATE TABLE statement | ||
--skip-add-locks | skip-add-locks | Do not add locks | ||
--skip-comments | skip-comments | Do not add comments to the dump file | ||
--skip-compact | skip-compact | Do not produce more compact output | ||
--skip-disable-keys | skip-disable-keys | Do not disable keys | ||
--skip-extended-insert | skip-extended-insert | Turn off extended-insert | ||
--skip-opt | skip-opt | Turn off the options set by --opt | ||
--skip-quick | skip-quick | Do not retrieve rows for a table from the server a row at a time | ||
--skip-quote-names | skip-quote-names | Do not quote identifiers | ||
--skip-set-charset | skip-set-charset | Suppress the SET NAMES statement | ||
--skip-triggers | skip-triggers | Do not dump triggers | ||
--skip-tz-utc | skip-tz-utc | Turn off tz-utc | ||
--ssl-ca=file_name | ssl-ca | The path to a file that contains a list of trusted SSL CAs | ||
--ssl-capath=dir_name | ssl-capath | The path to a directory that contains trusted SSL CA certificates in PEM format | ||
--ssl-cert=file_name | ssl-cert | The name of the SSL certificate file to use for establishing a secure connection | ||
--ssl-cipher=cipher_list | ssl-cipher | A list of allowable ciphers to use for SSL encryption | ||
--ssl-key=file_name | ssl-key | The name of the SSL key file to use for establishing a secure connection | ||
--ssl-verify-server-cert | ssl-verify-server-cert | The server's Common Name value in its certificate is verified against the host name used when connecting to the server | ||
--tab=path | tab | Produce tab-separated data files | ||
--tables | tables | Override the --databases or -B option | ||
--triggers | triggers | Dump triggers for each dumped table | ||
--tz-utc | tz-utc | Add SET TIME_ZONE='+00:00' to the dump file | ||
--user=user_name | user | The MySQL user name to use when connecting to the server | ||
--verbose | Verbose mode | |||
--version | Display version information and exit | |||
--where='where_condition' | where | Dump only rows selected by the given WHERE condition | ||
--xml | xml | Produce XML output |
发表评论
-
MySQL管理员常用命令记录
2012-06-30 16:34 2174------------------------------- ... -
ib_logfile和binary log file的区别
2012-06-28 10:16 24691.两者的区别: The ib_logfile's h ... -
使用Percona XtraBackup热备和恢复MySQL(二)
2012-06-15 16:45 5718在 使用Percona XtraBackup热备和恢复MySQ ... -
XtraBackup结合crontab定时备份innodB
2012-06-11 14:19 2703mysql-full-backup.sh #!/bin ... -
使用Percona XtraBackup热备和恢复MySQL(一)
2012-05-29 16:13 152231.在http://www.percona.com/do ... -
Percona Server with XtraDB 5.5.21和handlersocket插件安装
2012-03-21 14:40 30151.新建MySQL用户和用户组 groupadd mysql ... -
MySQL一些不常用的语法
2010-01-08 16:16 11111.insert ignore into terms_in ... -
insert into select和regexp
2009-12-29 22:21 1690最近有这么一个需求,对mysql一张很大的表的一个text类型 ...
相关推荐
备份数据库的另一个技术是使用mysqldump程序或mysqlhotcopy脚本。 1. 完全备份数据库: 2. shell> mysqldump --tab=/path/to/some/dir --opt db_name 或: shell> mysqlhotcopy db_name /path/to/some/dir 只要...
#MS SQL Dump 这是一个简单的 PowerShell 脚本,可让您为 MS SQL 创建数据库导出,类似于使用mysqldump和pg_dump ##Usage 将$database更改$database您的数据库名称并从 PowerShell 运行脚本。 它将在当前目录中创建...
11.5.1 用mysqldump备份和拷贝数 据库 307 11.5.2 使用直接拷贝数据库备份和 拷贝方法 308 11.5.3 复制数据库 309 11.6 为数据恢复使用备份 309 11.6.1 恢复整个数据库 310 11.6.2 恢复单个的表 310 11.7 优化...
11.5.1 用mysqldump备份和拷贝数 据库 307 11.5.2 使用直接拷贝数据库备份和 拷贝方法 308 11.5.3 复制数据库 309 11.6 为数据恢复使用备份 309 11.6.1 恢复整个数据库 310 11.6.2 恢复单个的表 310 11.7 ...
然后使用source命令,后面参数为脚本文件(如这里用到的.sql) mysql>source wcnc_db.sql B:使用mysqldump命令 mysqldump -u username -p dbname < filename.sql C:使用mysql命令 mysql -u username -p -D dbname ...
8.8. mysqldump:数据库备份程序 8.9. mysqlhotcopy:数据库备份程序 8.10. mysqlimport:数据导入程序 8.11. mysqlshow-显示数据库、表和列信息 8.12. myisamlog:显示MyISAM日志文件内容 8.13. perror:解释错误...
Mysqldump 将在生成 .sql 文件时锁定所有表。 因此不推荐用于大型数据库。 快照非常适合大型数据库。设置要求aws cli 应该已经配置好了mongo shell 如果需要 mongodb 备份mysql-client 如果需要 mysql 备份配置文件...
13.1 关系型数据库与关系型数据库系统的 13.1 介绍 204 13.2 关系型数据库系统的结构与运行过程 205 13.2.1 关系型数据库系统的层次结构 205 13.2.2 关系型数据库系统的运行过程 206 13.3 常用的关系型数据库的介绍 ...
然后使用source命令,后面参数为脚本文件(如这里用到的.sql) mysql>source wcnc_db.sql B:使用mysqldump命令 mysqldump -u username -p dbname < filename.sql C:使用mysql命令 mysql -u username -p -D dbname...
8.8. mysqldump:数据库备份程序 8.9. mysqlhotcopy:数据库备份程序 8.10. mysqlimport:数据导入程序 8.11. mysqlshow-显示数据库、表和列信息 8.12. myisamlog:显示MyISAM日志文件内容 8.13. perror:解释错误...
8.8. mysqldump:数据库备份程序 8.9. mysqlhotcopy:数据库备份程序 8.10. mysqlimport:数据导入程序 8.11. mysqlshow-显示数据库、表和列信息 8.12. myisamlog:显示MyISAM日志文件内容 8.13. perror:解释...
8.8. mysqldump:数据库备份程序 8.9. mysqlhotcopy:数据库备份程序 8.10. mysqlimport:数据导入程序 8.11. mysqlshow-显示数据库、表和列信息 8.12. myisamlog:显示MyISAM日志文件内容 8.13. perror:解释错误...
8.8. mysqldump:数据库备份程序 8.9. mysqlhotcopy:数据库备份程序 8.10. mysqlimport:数据导入程序 8.11. mysqlshow-显示数据库、表和列信息 8.12. myisamlog:显示MyISAM日志文件内容 8.13. perror:解释...
8.8. mysqldump:数据库备份程序 8.9. mysqlhotcopy:数据库备份程序 8.10. mysqlimport:数据导入程序 8.11. mysqlshow-显示数据库、表和列信息 8.12. myisamlog:显示MyISAM日志文件内容 8.13. perror:解释...
8.8. mysqldump:数据库备份程序 8.9. mysqlhotcopy:数据库备份程序 8.10. mysqlimport:数据导入程序 8.11. mysqlshow-显示数据库、表和列信息 8.12. myisamlog:显示MyISAM日志文件内容 8.13. perror:解释错误...
8.8. mysqldump:数据库备份程序 8.9. mysqlhotcopy:数据库备份程序 8.10. mysqlimport:数据导入程序 8.11. mysqlshow-显示数据库、表和列信息 8.12. myisamlog:显示MyISAM日志文件内容 8.13. perror:解释错误...
8.8. mysqldump:数据库备份程序 8.9. mysqlhotcopy:数据库备份程序 8.10. mysqlimport:数据导入程序 8.11. mysqlshow-显示数据库、表和列信息 8.12. myisamlog:显示MyISAM日志文件内容 8.13. perror:解释错误...