Comments (5)
ShahriyarR
commented on August 23, 2024
The first of all changed backup_tool=/usr/bin/xtrabackup in /etc/bck.conf
Failed with:
sudo autoxtrabackup --backup -v -l DEBUG
<pid.PidFile object at 0x7f78f5791ea8> entering setup
<pid.PidFile object at 0x7f78f5791ea8> create pidfile: /tmp/autoxtrabackup.pid
<pid.PidFile object at 0x7f78f5791ea8> check pidfile: /tmp/autoxtrabackup.pid
Warning: Using a password on the command line interface can be insecure.
Server is Up and running+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+OK
/usr/bin/mysql exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-+-++-OK
/usr/bin/mysqladmin exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-OK
MySQL configuration file exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+OK
Xtrabackup/Innobackupex exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-OK
Main backup directory exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-OK
Full Backup directory exists.+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+OK
Increment directory exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-OK
Check status: STATUS+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-+-+-+-OK
###############################################################
#You have no backups : Taking very first Full Backup! - - - - #
###############################################################
Flushing Binary Logs
Starting /usr/bin/xtrabackup
FULL BACKUP FAILED!
xtrabackup: Error: unknown argument: '/home/backup_dir/full'
<pid.PidFile object at 0x7f78f5791ea8> closing pidfile: /tmp/autoxtrabackup.pid
<pid.PidFile object at 0x7f78f5791ea8> closing pidfile: /tmp/autoxtrabackup.pid
from mysql-autoxtrabackup.
ShahriyarR
commented on August 23, 2024
The result after very first fix:
sudo autoxtrabackup --backup -v -l DEBUG
<pid.PidFile object at 0x7f73f6148f48> entering setup
<pid.PidFile object at 0x7f73f6148f48> create pidfile: /tmp/autoxtrabackup.pid
<pid.PidFile object at 0x7f73f6148f48> check pidfile: /tmp/autoxtrabackup.pid
Warning: Using a password on the command line interface can be insecure.
Server is Up and running+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+OK
/usr/bin/mysql exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-+-++-OK
/usr/bin/mysqladmin exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-OK
MySQL configuration file exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+OK
Xtrabackup/Innobackupex exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-OK
Main backup directory exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-OK
Full Backup directory exists.+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+OK
Increment directory exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-OK
Check status: STATUS+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-+-+-+-OK
###############################################################
#You have no backups : Taking very first Full Backup! - - - - #
###############################################################
Flushing Binary Logs
Starting /usr/bin/xtrabackup
<pid.PidFile object at 0x7f73f6148f48> closing pidfile: /tmp/autoxtrabackup.pid
<pid.PidFile object at 0x7f73f6148f48> closing pidfile: /tmp/autoxtrabackup.pid
Seems to be worked but, backup was created not in timestamped folder but directly. This should be fixed as well.
from mysql-autoxtrabackup.
ShahriyarR
commented on August 23, 2024
Failed incremental backup as well with:
sudo autoxtrabackup --backup -v -l DEBUG
<pid.PidFile object at 0x7f48797c6f48> entering setup
<pid.PidFile object at 0x7f48797c6f48> create pidfile: /tmp/autoxtrabackup.pid
<pid.PidFile object at 0x7f48797c6f48> check pidfile: /tmp/autoxtrabackup.pid
Warning: Using a password on the command line interface can be insecure.
Server is Up and running+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+OK
/usr/bin/mysql exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-+-++-OK
/usr/bin/mysqladmin exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-OK
MySQL configuration file exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+OK
Xtrabackup/Innobackupex exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-OK
Main backup directory exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-OK
Full Backup directory exists.+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+OK
Increment directory exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-OK
Check status: STATUS+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-+-+-+-OK
################################################################
You have a full backup that is less than 86400 seconds old. - -#
We will take an incremental one based on recent Full Backup - -#
################################################################
Installed Server is MySQL, will continue as usual.
INCREMENT BACKUP FAILED!
xtrabackup: Error: unknown argument: '/home/backup_dir/inc'
<pid.PidFile object at 0x7f48797c6f48> closing pidfile: /tmp/autoxtrabackup.pid
<pid.PidFile object at 0x7f48797c6f48> closing pidfile: /tmp/autoxtrabackup.pid
from mysql-autoxtrabackup.
ShahriyarR
commented on August 23, 2024
Backup prepare stage failed as:
sudo autoxtrabackup --prepare -v -l DEBUG
<pid.PidFile object at 0x7fdc21296ea8> entering setup
<pid.PidFile object at 0x7fdc21296ea8> create pidfile: /tmp/autoxtrabackup.pid
<pid.PidFile object at 0x7fdc21296ea8> check pidfile: /tmp/autoxtrabackup.pid
Installed Server is MySQL, will continue as usual.
There is no /usr/lib/systemd/system folder, Continue
There is no /usr/lib/systemd/system folder, Continue
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Preparing full/inc backups!
What do you want to do?
1. Prepare Backups and keep for future usage. NOTE('Once Prepared Backups Can not be prepared Again')
2. Prepare Backups and restore/recover/copy-back immediately
3. Just copy-back previously prepared backups
Please Choose one of options and type 1 or 2 or 3: 1
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
####################################################################################################
You have Incremental backups. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -#
Preparing Full backup 1 time. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -#
Final prepare,will occur after preparing all inc backups - - - - - - - - - - - - - - - - - - - - -#
####################################################################################################
One time FULL BACKUP PREPARE FAILED!
xtrabackup: Error: unknown argument: '/home/backup_dir/full/2017-01-18_16-59-17'
####################################################################################################
The end of Prepare Process. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -#
Preparing FULL backup Again: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - #
####################################################################################################
Full BACKUP PREPARE FAILED!
xtrabackup: Error: unknown argument: '/home/backup_dir/full/2017-01-18_16-59-17'
<pid.PidFile object at 0x7fdc21296ea8> closing pidfile: /tmp/autoxtrabackup.pid
<pid.PidFile object at 0x7fdc21296ea8> closing pidfile: /tmp/autoxtrabackup.pid
from mysql-autoxtrabackup.
ShahriyarR
commented on August 23, 2024
Implemented. Closing.
from mysql-autoxtrabackup.
Related Issues (20)
- Rethinking core backup process - adopting to Docker HOT 1
- Refactor Prepare class HOT 1
- Docker test image build failure HOT 2
- Testing fails - report them here HOT 6
- Implement API for backup functionality HOT 2
- Actually what does do #archive_max_size = 100GiB #archive_max_duration = 4 Days parameter HOT 1
- Mount backup_dir to the host and container in order to get the backup files locally HOT 1
- Return status for inc_backup() is IGNORED !? HOT 5
- DryRun causes UnboundLocalError: local variable 'status' referenced before assignment HOT 1
- There is no error if the backup failed from API call HOT 1
- Pass MySQL related configs to docker as env variables
- Replace FastAPI with Flask :( HOT 3
- Implement new command for starting and serving the API locally
- We need to add proper versioning to get the version only from one place
- Prepare changelog for the first time
- Increase the test coverage HOT 1
- Config not generated on setup HOT 5
- archive_max_duration - ValueError: could not convert string to float: 'None' HOT 7
- ERROR [copy_back:159] FileNotFoundError: [Errno 2] No such file or directory: 'None' HOT 2
- Completely rewrite, restructure this project or abandone HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysql-autoxtrabackup.