Home >Database >Mysql Tutorial >mysql在线全备份和恢复_MySQL

mysql在线全备份和恢复_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:30:19970browse

bitsCN.com

mysql在线全备份和恢复

 

在线全备份:

 

  mysqldump -uroot -p --default-character-set=utf8 --opt --master-data=1 --single-transaction --flush-logs databasename > dabase_bak.sql

 

 

恢复:

 

  1)# mysql -uroot -p databasename < dabase_bak.sql  2)mysql>source /root/dabase_bak.sql

 

 

大数据库的备份恢复:

 

 [root@ticket_backup ~]# vim /etc/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Default to using old password format for compatibility with mysql 3.x# clients (those using the mysqlclient10 compatibility package).old_passwords=1# Disabling symbolic-links is recommended to prevent assorted security risks;# to do so, uncomment this line:# symbolic-links=0log-bin=mysql-binmax_allowed_packet = 32Mquery_cache_size = 32Mkey_buffer_size = 384Mtable_cache = 128K[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid[mysqldump]max_allowed_packet = 32M

 

 

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn