时间:2021-07-01 10:21:17 帮助过:3人阅读
欢迎进入Linux社区论坛,与200万技术人员互动交流 >>进入 在线全备份: mysqldump -uroot -p --default-character-set=utf8 --opt --master-data=1 --single-transaction --flush-logs databasename dabase_bak.sql 恢复: 1)# mysql -uroot -p databasename
欢迎进入Linux社区论坛,与200万技术人员互动交流 >>进入
在线全备份:
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/mysql
socket=/var/lib/mysql/mysql.sock
user=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=0
log-bin=mysql-bin
max_allowed_packet = 32M
query_cache_size = 32M
key_buffer_size = 384M
table_cache = 128K
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqldump]
max_allowed_packet = 32M