June 2020
M T W T F S S
« Mar    
1234567
891011121314
15161718192021
22232425262728
2930  

Categories

WordPress Quotes

A person who has a cat by the tail knows a whole lot more about cats than someone who has just read about them.
Mark Twain
June 2020
M T W T F S S
« Mar    
1234567
891011121314
15161718192021
22232425262728
2930  

Short Cuts

2012 SERVER (64)
2016 windows (9)
AIX (13)
Amazon (40)
Ansibile (19)
Apache (135)
Asterisk (2)
cassandra (2)
Centos (211)
Centos RHEL 7 (270)
centos8 (3)
chef (3)
cloud (2)
cluster (3)
Coherence (1)
DB2 (5)
DISK (25)
DNS (9)
Docker (30)
Eassy (11)
ELKS (1)
EXCHANGE (3)
Fedora (6)
ftp (5)
GIT (3)
GOD (2)
Grub (1)
Hacking (10)
Hadoop (6)
health (2)
horoscope (23)
Hyper-V (10)
IIS (15)
IPTABLES (15)
JAVA (7)
JBOSS (32)
jenkins (1)
Kubernetes (7)
Ldap (5)
Linux (188)
Linux Commands (166)
Load balancer (5)
mariadb (14)
Mongodb (4)
MQ Server (24)
MYSQL (84)
Nagios (5)
NaturalOil (13)
Nginx (35)
Ngix (1)
openldap (1)
Openstack (6)
Oracle (35)
Perl (3)
Postfix (19)
Postgresql (1)
PowerShell (2)
Python (3)
qmail (36)
Redis (12)
RHCE (28)
SCALEIO (1)
Security on Centos (29)
SFTP (1)
Shell (64)
Solaris (58)
Sql Server 2012 (4)
squid (3)
SSH (10)
SSL (14)
Storage (1)
swap (3)
TIPS on Linux (28)
tomcat (62)
Ubuntu (1)
Uncategorized (30)
Veritas (2)
vfabric (1)
VMware (28)
Weblogic (38)
Websphere (71)
Windows (19)
Windows Software (2)
wordpress (1)
ZIMBRA (17)

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

Who's Online

0 visitors online now
0 guests, 0 bots, 0 members

Hit Counter provided by dental implants orange county

MySQL Enterprise Backup (MEB)

MySQL Enterprise Backup (MEB) has the capability to make real incremental (differential and cumulative?) backups. The actual releases are quite cool and you should really look at it…

Unfortunately the original MySQL documentation is much too complicated for my simple mind. So I did some testing and simplified it a bit for our customers…

If you want to dive into the original documentation please look here: Making an Incremental Backup .

If you want to use MySQL Enterprise Backup please let us know and we send you a quote

First you have to do a full backup. We did it as follows:
mysqlbackup –defaults-file=/etc/my.cnf –user=root –backup-dir=/backup/full backup
mysqlbackup –defaults-file=/etc/my.cnf –user=root –backup-dir=/backup/full apply-log
Then you can do the incremental backup:
mysqlbackup –defaults-file=/etc/my.cnf –user=root –incremental –incremental-base=dir:/backup/full –incremental-backup-dir=/backup/incremental1 backup
mysqlbackup –defaults-file=/etc/my.cnf –user=root –backup-dir=/backup/full –incremental-backup-dir=/backup/incremental1 apply-incremental-backup
this incremental backup you can repeat several times…
FULL MYSQL BACKUP
mysqlbackup –defaults-file=/etc/my.cnf –user=root –backup-dir=/backup/full backup
mysqlbackup –defaults-file=/etc/my.cnf –user=root –backup-dir=/backup/full apply-log
FIRST MYSQL INCREMENTAL BACKUP
mysqlbackup –defaults-file=/etc/my.cnf –user=root –incremental –incremental-base=dir:/backup/full –incremental-backup-dir=/backup/incremental1 backup
mysqlbackup –defaults-file=/etc/my.cnf –user=root –backup-dir=/backup/full –incremental-backup-dir=/backup/incremental1 apply-incremental-backup
SECOND MYSQL INCREMENTAL BACKUP
mysqlbackup –defaults-file=/etc/my.cnf –user=root –incremental –incremental-base=dir:/backup/full –incremental-backup-dir=/backup/incremental2 backup
mysqlbackup –defaults-file=/etc/my.cnf –user=root –backup-dir=/backup/full –incremental-backup-dir=/backup/incremental2 apply-incremental-backup

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

  

  

  

Blue Captcha Image
Refresh

*

Protected by WP Anti Spam