Stack Overflow
Stack Overflow

Questions tagged [innobackupex]

A Perl script that acts as a wrapper for the xtrabackup C program. It enables more functionality by integrating xtrabackup and other functions such as file copying and streaming.

19 questions
9
votes
2 answers

Taking backup remotely using innobackupex

I am trying to take backup from a remote machine using innobackupex. ./innobackupex --host= --user= . Its failing as it is unable to locate a directory in the server. (Errcode: 2 - No such file or directory) I…
user3351750
  • 927
  • 13
  • 24
5
votes
3 answers

innobackupex - after restoring a mysql backup the server can not start up

After restoring a backup the mysql server can not start up.. quit without updating PID file backup command line innobackupex --user=root --password=pass --databases="the_database" --stream=tar ./ 2> /var/log/innobackupex.log | gzip -c -1 >…
clarkk
  • 27,151
  • 72
  • 200
  • 340
2
votes
1 answer

MariaDB backup tool Mariabackup failing with error

We've recently upgraded from MariaDB 5.5 to 10.2, and swapped from innobackupex to Mariadbackup (a fork of xtrabackup). Attempting to do a full backup always fails. I'm running the backup with: sudo mariabackup --backup --target-dir…
Luke Cousins
  • 2,068
  • 1
  • 20
  • 38
2
votes
1 answer

Innobackupex call from bash script

I'm experiencing a really weird behaviour of my innobackupex backup system. I set it all properly, ran a few backups from terminal and it works good. My idea is to run incremental backups once per day, so I created a small sh script for it to put…
Relja
  • 678
  • 5
  • 13
  • 25
2
votes
0 answers

mysql logs showing status information after data restore with innobackupex

After database restore with innobackupex, we are seeing MySQL coming up clean but the logs are showing status info on buffers and locks. Is this a OK sign or is there any inconsistency/error?. db in use is MySQL server version 5.5.33. mysqld.log…
Tommy
  • 277
  • 1
  • 4
  • 17
1
vote
1 answer

installed percona-xtrabackup package still getting innobackupex: command not found

I have to configure the incremental backup of MySQL, for that, I am using innobackupex. Installed percona-xtrabackup-2.3.6-1.el7.x86_64.rpm on centos7, still getting innobackupex: command not found
Nitin Suradkar
  • 11
  • 5
1
vote
0 answers

Determining progress of a transfer

We are having a restoration system which uses innobackupex. I want to see the number of bytes transferred at any point of time. How can I do that?
dknight
  • 1,243
  • 10
  • 23
1
vote
1 answer

Percona Xtrabackup fails during backup

When i try to perform a backup using Percona innobackupex, i get the following error: george@db-pxc-1 [~] [17:50] sudo innobackupex --user=root --password=secret --host=127.0.0.1 ~/Data 160830 17:50:34 innobackupex: Starting the backup…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
1
vote
1 answer

What does innobackupex put into its standard out?

So I was executing the following line of code: innobackupex --defaults-file=${CONFIG_FILE} --no-timestamp --user=${DB_USER} --password=${DB_PASSWORD} --socket=${DB_SOCKET} ${SLAVE_INFO} --stream=tar ./ &> ${DB_LOG} | gzip - >…
user3299633
  • 2,971
  • 3
  • 24
  • 38
0
votes
0 answers

innobackupex skipp table when backuping

I'm trying to backup a single table and restore to another clean server. I do it like this: innobackupex --tables(or include)='db.table1' --compress --stream=xbstream ./ | ssh user@ip \ "xbstream -x -C /var/lib/mysql/partial-backup/" In the output I…
Валерий Сиволапенко
  • 87
  • 4
  • 10
0
votes
1 answer

xtrabackup does not write gtid information in xtrabackup_binlog_info

Software versions: xtrabackup 8.0.12 percona-xtradb-cluster-server 8.0.18-9 I am running xtrabackup with this options: --defaults-file=/etc/mysql/my.cnf --backup --user=backup --password=**** --parallel=4 --no-timestamp…
Selivanov Pavel
  • 338
  • 2
  • 11
  • 25
0
votes
0 answers

Xtrabackup fails for full backup after a restore

After a restore in Percona 5.7 from another Percona 5.7 server full backups are failing with the following error: xtrabackup: cd to /data/mysql xtrabackup: open files limit requested 0, set to 819200 xtrabackup: using the following…
Catalina Cenan
  • 319
  • 6
  • 14
0
votes
0 answers

Innobackup script throws file not found error

I'm trying to run innobackup script to perform full backup on a MySQL docker instance using the following script: innobackupex --datadir=/usr/local/mysql/ -s --host=node1 --port=31057 --user=root --password=abc --compress --compress-threads=8…
Anju
  • 631
  • 2
  • 9
  • 25
0
votes
1 answer

how can I create incremental backups with xtrabackup automatically

It says on the manual that if you want to create an incremental backup you can do it with the following command: xtrabackup --backup --target-dir=/data/backups/inc1 \ --incremental-basedir=/data/backups/base --datadir=/var/lib/mysql/ where…
VaTo
  • 2,936
  • 7
  • 38
  • 77
0
votes
1 answer

How to set up rotational full and incremental innobackupex?

Innobackupex provides both full and incremental backup of mysql servers. But i am looking for a script that automate the process of daily full backup and incremental in certain hours. The script will remove old backup files and mail the status…
Aman Aggarwal
  • 17,619
  • 9
  • 53
  • 81
1
2