I have new serve create in different machine i have only have access using IP address in another hand i have service url of k8s it pxc.pxc.svc.cluster.local
can i restore database
currently i am trying this seems not working
xtrabackup --copy-back --no-defaults -uuser -p -P 5306 -h pxc.pxc.svc.cluster.local --force-non-empty-directories --target-dir=xtrabackup/ --innodb_undo_directory=/home/backup
Error
some time it says completed ok but no database restored ,
and some time
pxc.pxc.svc.cluster.local/ibdata1’ (OS errno 17 - File exists)
@fward1208 @Mauricio_Cacho
Hello @chethan4046,
Percona Xtrabackup (PXB) is not a logical backup tool. PXB is a physical backup tool. Thus, you must have direct access to the disk were MySQL is running for restore. You must first copy the backup taken by PXB to the new server in question, using rsync or scp, and then on that machine, you can prepare the backup and start MySQL.
@matthewb Thanks for your replay,
But in my case i am running mysql server as k8s pod, How to restore inside pod by copying backup inside pod it self ?
I’m not a K8S expert, but I think you’d have to do something like create a persistent volume, copy the backup into that volume, then launch a new K8S pod and attach that volume to that pod.
If you database is small, < 200GB, then you can do a logical backup/restore using something like mydumper/myloader which can be done remotely