Hi team, I am newly mysql and xtrabackup
I follow the docs to backup mysql version 5.6.46
I use command ssh to mysql server and stream backup to localhost. My command
ssh aht-admin@172.16.0.11 sudo xtracbackup --backup --user=account --port=3306 --password=password --target-dir=~ --open-files-limit=8192000 --no-server-version-check > root/backup-pt/full/sql.xbs
the output message “completed OK!”
when I run command " xbstream -x < /mnt/M_Backup_01/M_Database/72/72.sql" It’s extract almost database but is output message
xbstream: Can't create/write to file './BCCEWH/db.opt' (Errcode: 17 - File exists)
xbstream: failed to create file.
Please support me
1 Like
Hi @Trung_Dam
The error says it cannot extract because the file already exists. Please either remove the file from the folder where you are executing xbstream from or create a new folder and pass it as parameter xbstream -x -C new_folder < file.xbs
1 Like
It’s not working, the error is still the same
xbstream: Can't create/write to file './BCCEWH/db.opt' (Errcode: 17 - File exists)
xbstream: failed to create file.
My command I run
xbstream -vx -C /mnt/M_Backup_01/M_Database/72/unpack_full/10-12-2022 < /mnt/M_Backup_01/M_Database/72/72.sql
Error
xbstream: Can't create/write to file './BCCEWH/db.opt' (Errcode: 17 - File exists)
xbstream: failed to create file.
1 Like
On my server, I have 2 databases with the same name, but one with a lowercase letter, and one with an uppercase letter
db name: BCCEWH and bccewh
1 Like
I found the problem, nfs storage mount my localhost and it can’t create folder with same name, even with uppercase and lowercase letters. So I try extracting to ext4 file system and it worked
Thank you for your help
1 Like