gaodaima.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 source /root/dabase_bak.sql
大数据库的备份恢复：
[root@ticket_backup ~]# vim /etc/my.cnf[mysqld]data<p style="color:transparent">本文来源gao!%daima.com搞$代*!码网1</p>dir=/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
gaodaima.com
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：mysql在线全备份和恢复_MySQL
转载请注明原文链接：mysql在线全备份和恢复_MySQL
