Comments on MySQL Incremental Backup - Point In Time Backup and Recovery of InnoDB and MyIsam Databases

Hi 

I am getting error on this command , due to that select @@log_bin_basename  - Unknown system variable 'log_bin_basename'  , kindly provide the some idea.  This script will work only in enterprise version ??

Salut srinivasan

J'ai rencontré la même erreur. Résolue comme suit:

1-Dans le script "mysql-incremental" tu modifie la ligne: 

BinlogPATH=$(dirname `$MySQLCommand -sN -e "select @@log_bin_basename"`) => supprimer (_basename) 

BinlogPATH=$(dirname `$MySQLCommand -sN -e "select @@log_bin"`)

Hi

How to Solve the problem ( how to configure) ,  I have two database , i am running insert script  like  "insert into db1.table ..." and "insert into db2.table ... " after that I am passing commit statement. When I run the incremental backup ,  both the insert statements are inserted in db1 Backup.  In db2 backup is no insert statement.  How to solve the issue. 

HI srinivasan

try this syntax: select @@log_bin

You have to correct in mysql-incremental script

BinlogPATH=$(dirname `$MySQLCommand -sN -e "select @@log_bin"`)

Hi,

I have to take a weekly full backup and daily Incremental backup.How can I do this using above tool.

I am not able to understand the process of log-bin in /etc/my.cnf . while am adding the binlog_format = ROW i am not able to restart the mysql. tell me log-bin = ? what is the path.

Dear Team when i am running the mysql incremental backup i am getting the below error. as 

/usr/bin/mysqlbinlog: File './testingbinlog.000014' not found (Errcode: 2)

my db name is testing.

my /etc/my.cnf file as follows 

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

binlog_format = ROW

binlog_do_db = testing

binlog_do_db = recipes_database

expire_logs_days = 60

log_bin = /var/lib/mysql/testingbinlog

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

[root@localhost mysql-inc]# ./mysql-incremental

CheckAutomysqlbacupScript

FindMySQLCommand

MySQLPing

CheckBinLogEnabled

CheckDatabaseMode

DatabaseInBinlogDo

LoadCurrentBinLogInfo

LoadLastBinLogInfo

CheckLastBinLogFile

CheckLastDailyBackup

FindBinLogNames

BackupIncremental

MakeBackupPATH

/usr/bin/mysqlbinlog: File './testingbinlog.000014' not found (Errcode: 2)

/usr/bin/mysqlbinlog: File './testingbinlog.000015' not found (Errcode: 2)

/usr/bin/mysqlbinlog: File './testingbinlog.000014' not found (Errcode: 2)

/usr/bin/mysqlbinlog: File './testingbinlog.000015' not found (Errcode: 2)

RotateIncrementalBackup

I trying to fix but not able to fixed this error like below mention,

Please help me as soon as posible,

2016-11-22 18:29:13 -- ERROR : The database is not running or the provided credentials are not correct.

Hi

@Umesh Kumar, sorry for this delay. I fixed the issue. you can download the latest code.

Thanks for your attention

Getting this error file executing mysql-incemental script 

CheckAutomysqlbacupScriptFindMySQLCommandMySQLPingCheckBinLogEnabledCheckDatabaseModeDatabaseInBinlogDoLoadCurrentBinLogInfoLoadLastBinLogInfoCheckLastBinLogFileCheckLastDailyBackupFindBinLogNamesBackupIncrementalMakeBackupPATHRotateIncrementalBackup./mysql-incremental: line 159: [: 0: unary operator expected./mysql-incremental: line 159: [: 1: unary operator expected./mysql-incremental: line 159: [: 2: unary operator expected

I am also facing same issue and when the incremental backup script is executed , the backups are not stored in current date-incremental folder.