![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL Backup and Recovery
文章平均质量分 81
ZhongWeicheng
这个作者很懒,什么都没留下…
展开
-
恢复使用MEB备份的MySQL数据库
执行一个普通备份[root@test bin]# ./mysqlbackup --defaults-file=/service/mysql5.5/my.cnf --socket=/data/mysql5.5/mysql.sock --user=root --backup-dir=/backup/5.5/normal --password backupMySQL Enterprise Back原创 2013-11-23 00:04:23 · 2779 阅读 · 0 评论 -
MySQL Compressed Backup
[root@test zwc]# ls -lhtotal 953M-rw-rw---- 1 mysql mysql 61 Nov 3 22:03 db.opt-rw-rw---- 1 mysql mysql 8.5K Nov 3 22:10 t1.frm-rw-rw---- 1 mysql mysql 191M Nov 3 22:25 t1.MYD-rw-rw----原创 2013-11-04 00:29:33 · 1565 阅读 · 1 评论 -
Shell Script For MySQL Enterprise Backup Crontab Schedule
#!/bin/ksh#prints usageusage(){ echo "$VERSION" echo "Usage: `basename $0` [command] [MEB options]Commands: full make full backup incremental原创 2013-08-29 13:11:49 · 2498 阅读 · 0 评论 -
从MySQL全备中恢复Innodb单表
First, you must meet certain prerequisites to be able to restore a ibd tablespace:1.The ibd file must be from a consistent backup with all insert buffer entries merged and have no uncommitted trans原创 2013-11-25 19:58:16 · 1659 阅读 · 0 评论 -
使用mysqldump ftp将备份集上传到远端服务器
以下是我以前的一个mysqldump备份脚本,将备份集打包ftp传到异地服务器上,脚本修改路径即可。将其放在crontab下。#!/bin/sh logfile=/backup/backup.logLOCALHOST_IP=$(/sbin/ifconfig |grep 'inet addr' |cut -d':' -f2 |cu原创 2013-11-24 23:26:24 · 1115 阅读 · 0 评论 -
Oracle Logminer使用
--创建测试数据C:\>set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBKC:\>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on 星期三 3月 12 22:10:38 2014Copyright (c) 1982, 2007, Oracl原创 2014-03-12 23:10:59 · 1182 阅读 · 0 评论