# Question about restore procedure
**URL:** https://forums.percona.com/t/question-about-restore-procedure/9012
**Category:** Percona XtraBackup
**Created:** [January 29, 2021, 1:00pm UTC](https://forums.percona.com/t/question-about-restore-procedure/9012 "2021-01-29T13:00:51Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Andrey\_Sm](https://forums.percona.com/u/Andrey_Sm)
#### Post date: [January 29, 2021, 1:00pm UTC](https://forums.percona.com/t/question-about-restore-procedure/9012/1 "2021-01-29T13:00:51Z")
In the documentation it says we need to use the following two commands to restore the backup
```
rsync -avrP /data/backup/ /var/lib/mysql/
chown -R mysql:mysql /var/lib/mysql
```
What I noticed is that my original DB folder has a lot of separate “idb” files related to the different tables
…
-rw-r----- 1 mysql mysql 114688 Sep 16 09:54 Table\_Pers.ibd
-rw-r----- 1 mysql mysql 24117248 Sep 16 09:54 Table\_Regs\_Flags.ibd
-rw-r----- 1 mysql mysql 147456 Jan 28 14:40 Table\_\_Regs.ibd
-rw-r----- 1 mysql mysql 9437184 Jan 28 13:44 Table\_\_Sales\_Agent.ibd
…
The folder with the backup has only one file called “mysql.ibd”
How restore is going to work in this case?
---
### Author:  [@vadimtk](https://forums.percona.com/u/vadimtk)
#### Post date: [January 29, 2021, 3:44pm UTC](https://forums.percona.com/t/question-about-restore-procedure/9012/2 "2021-01-29T15:44:42Z")
If in your backup you have only mysql.idb, most likely your backup is broken.
Backup folder should have the same files as original DB folder.
---
### Author:  [@Andrey\_Sm](https://forums.percona.com/u/Andrey_Sm)
#### Post date: [February 2, 2021, 5:47pm UTC](https://forums.percona.com/t/question-about-restore-procedure/9012/3 "2021-02-02T17:47:42Z")
This is really confusing
In my original db folder I have a lot of “ibd” files with the same names as tables in the database
In the backup folder I have only “mysql.ibd”
I do not see any errors when running backup
This is the command:
> xtrabackup --user=bkpuser --password=PASS --backup --databases=‘mysql sys performance\_schema DB-NAME’ --target-dir=/var/lib/backup/DB-NAME
I did it again, no “ibd” file in the backup folder.
What I am doing wrong?
---
### Author:  [@vadimtk](https://forums.percona.com/u/vadimtk)
#### Post date: [February 2, 2021, 6:05pm UTC](https://forums.percona.com/t/question-about-restore-procedure/9012/4 "2021-02-02T18:05:29Z")
Can you show the full output you get from xtrabackup ?
---
### Author:  [@Andrey\_Sm](https://forums.percona.com/u/Andrey_Sm)
#### Post date: [February 2, 2021, 6:36pm UTC](https://forums.percona.com/t/question-about-restore-procedure/9012/5 "2021-02-02T18:36:39Z")
#xtrabackup --user=bkpuser --password=PASS --backup --databases=‘mysql sys performance\_schema \> DBNAME’ --target-dir=/var/lib/backup/DBFOLDER
> xtrabackup: recognized server arguments: --datadir=/var/lib/mysql
> xtrabackup: recognized client arguments: --user=bkpuser --password=\* --backup=1 --databases=mysql sys performance\_schema DBNAME --target-dir=/var/lib
> /backup/DBFOLDER
> xtrabackup version 8.0.22-15 based on MySQL server 8.0.22 Linux (x86\_64) (revision id: fea8a0e)
> 210202 10:31:49 version\_check Connecting to MySQL server with DSN ‘dbi:mysql:;mysql\_read\_default\_group=xtrabackup’ as ‘bkpuser’ (using password: YES).
> 210202 10:31:49 version\_check Connected to MySQL server
> 210202 10:31:49 version\_check Executing a version check against the server…
> 210202 10:31:49 version\_check Done.
> 210202 10:31:49 Connecting to MySQL server host: localhost, user: bkpuser, password: set, port: not set, socket: not set
> Using server version 8.0.21
> xtrabackup: uses posix\_fadvise().
> xtrabackup: cd to /var/lib/mysql
> xtrabackup: open files limit requested 0, set to 1024
> xtrabackup: using the following InnoDB configuration:
> xtrabackup: innodb\_data\_home\_dir = .
> xtrabackup: innodb\_data\_file\_path = ibdata1:12M:autoextend
> xtrabackup: innodb\_log\_group\_home\_dir = ./
> xtrabackup: innodb\_log\_files\_in\_group = 2
> xtrabackup: innodb\_log\_file\_size = 50331648
> Number of pools: 1
> 210202 10:31:49 Connecting to MySQL server host: localhost, user: bkpuser, password: set, port: not set, socket: not set
> xtrabackup: Redo Log Archiving is not set up.
> 210202 10:31:49 \>\> log scanned up to (62802692466)
> xtrabackup: Generating a list of tablespaces
> xtrabackup: Generating a list of tablespaces
> Scanning ‘./’
> Completed space ID check of 2 files.
> Allocated tablespace ID 1 for sys/sys\_config, old maximum was 0
> Using undo tablespace ‘./undo\_001’.
> Using undo tablespace ‘./undo\_002’.
> Opened 2 existing undo tablespaces.
> 210202 10:31:49 [01] Copying ./ibdata1 to /var/lib/backup/DBFOLDER/ibdata1
> 210202 10:31:49 [01] …done
> 210202 10:31:49 [01] Copying ./sys/sys\_config.ibd to /var/lib/backup/DBFOLDER/sys/sys\_config.ibd
> 210202 10:31:49 [01] …done
> 210202 10:31:49 [01] Copying ./mysql.ibd to /var/lib/backup/DBFOLDER/mysql.ibd
> 210202 10:31:49 [01] …done
> 210202 10:31:49 [01] Copying ./undo\_002 to /var/lib/backup/DBFOLDER/undo\_002
> 210202 10:31:50 \>\> log scanned up to (62802692466)
> 210202 10:31:50 [01] …done
> 210202 10:31:50 [01] Copying ./undo\_001 to /var/lib/backup/DBFOLDER/undo\_001
> 210202 10:31:51 \>\> log scanned up to (62802692466)
> 210202 10:31:51 [01] …done
> 210202 10:31:51 Starting to backup non-InnoDB tables and files
> 210202 10:31:51 [01] Skipping ./#ib\_16384\_1.dblwr.
> 210202 10:31:51 [01] Skipping ./mysql\_upgrade\_info.
> 210202 10:31:51 [01] Skipping ./ib\_logfile1.
> 210202 10:31:51 [01] Skipping ./server-cert.pem.
> 210202 10:31:51 [01] Skipping ./binlog.000079.
> 210202 10:31:51 [01] Skipping ./server-key.pem.
> 210202 10:31:51 [01] Skipping ./#ib\_16384\_0.dblwr.
> 210202 10:31:51 [01] Skipping ./ca-key.pem.
> 210202 10:31:51 [01] Skipping ./binlog.000080.
> 210202 10:31:51 [01] Skipping ./ibtmp1.
> 210202 10:31:51 [01] Skipping ./binlog.000075.
> 210202 10:31:51 [01] Skipping ./ib\_buffer\_pool.
> 210202 10:31:51 [01] Skipping ./undo\_002.
> 210202 10:31:51 [01] Skipping ./client-key.pem.
> 210202 10:31:51 [01] Skipping ./mysql.ibd.
> 210202 10:31:51 [01] Skipping ./mysql.sock.lock.
> 210202 10:31:51 [01] Copying performance\_schema/events\_statement\_2944.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2944.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/global\_variables\_3001.sdi to /var/lib/backup/DBFOLDER/performance\_schema/global\_variables\_3001.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_statement\_2945.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2945.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_statement\_2948.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2948.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_waits\_sum\_2909.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_waits\_sum\_2909.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/session\_status\_2999.sdi to /var/lib/backup/DBFOLDER/performance\_schema/session\_status\_2999.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_statement\_2946.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2946.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_stages\_su\_2934.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_stages\_su\_2934.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/status\_by\_accoun\_2994.sdi to /var/lib/backup/DBFOLDER/performance\_schema/status\_by\_accoun\_2994.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/status\_by\_user\_2997.sdi to /var/lib/backup/DBFOLDER/performance\_schema/status\_by\_user\_2997.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/mutex\_instances\_2917.sdi to /var/lib/backup/DBFOLDER/performance\_schema/mutex\_instances\_2917.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_errors\_su\_2960.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_errors\_su\_2960.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_statement\_2940.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2940.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_waits\_his\_2905.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_waits\_his\_2905.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/binary\_log\_trans\_3006.sdi to /var/lib/backup/DBFOLDER/performance\_schema/binary\_log\_trans\_3006.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/replication\_appl\_2990.sdi to /var/lib/backup/DBFOLDER/performance\_schema/replication\_appl\_2990.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/session\_connect\_\_2969.sdi to /var/lib/backup/DBFOLDER/performance\_schema/session\_connect\_\_2969.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_stages\_su\_2933.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_stages\_su\_2933.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/replication\_appl\_2985.sdi to /var/lib/backup/DBFOLDER/performance\_schema/replication\_appl\_2985.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/accounts\_2964.sdi to /var/lib/backup/DBFOLDER/performance\_schema/accounts\_2964.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/threads\_2929.sdi to /var/lib/backup/DBFOLDER/performance\_schema/threads\_2929.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/setup\_actors\_2921.sdi to /var/lib/backup/DBFOLDER/performance\_schema/setup\_actors\_2921.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_waits\_sum\_2910.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_waits\_sum\_2910.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/socket\_summary\_b\_2968.sdi to /var/lib/backup/DBFOLDER/performance\_schema/socket\_summary\_b\_2968.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/table\_io\_waits\_s\_2927.sdi to /var/lib/backup/DBFOLDER/performance\_schema/table\_io\_waits\_s\_2927.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_statement\_2943.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2943.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_statement\_2949.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2949.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_transacti\_2956.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_transacti\_2956.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/data\_locks\_2979.sdi to /var/lib/backup/DBFOLDER/performance\_schema/data\_locks\_2979.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_transacti\_2954.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_transacti\_2954.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/memory\_summary\_b\_2974.sdi to /var/lib/backup/DBFOLDER/performance\_schema/memory\_summary\_b\_2974.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_statement\_2938.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2938.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/replication\_appl\_2989.sdi to /var/lib/backup/DBFOLDER/performance\_schema/replication\_appl\_2989.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/users\_2963.sdi to /var/lib/backup/DBFOLDER/performance\_schema/users\_2963.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_waits\_cur\_2904.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_waits\_cur\_2904.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/memory\_summary\_b\_2973.sdi to /var/lib/backup/DBFOLDER/performance\_schema/memory\_summary\_b\_2973.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/prepared\_stateme\_2992.sdi to /var/lib/backup/DBFOLDER/performance\_schema/prepared\_stateme\_2992.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/file\_instances\_2913.sdi to /var/lib/backup/DBFOLDER/performance\_schema/file\_instances\_2913.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/memory\_summary\_g\_2972.sdi to /var/lib/backup/DBFOLDER/performance\_schema/memory\_summary\_g\_2972.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/replication\_appl\_2987.sdi to /var/lib/backup/DBFOLDER/performance\_schema/replication\_appl\_2987.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_waits\_sum\_2911.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_waits\_sum\_2911.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/setup\_objects\_2924.sdi to /var/lib/backup/DBFOLDER/performance\_schema/setup\_objects\_2924.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_transacti\_2951.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_transacti\_2951.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/setup\_consumers\_2922.sdi to /var/lib/backup/DBFOLDER/performance\_schema/setup\_consumers\_2922.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/table\_handles\_2977.sdi to /var/lib/backup/DBFOLDER/performance\_schema/table\_handles\_2977.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/setup\_instrument\_2923.sdi to /var/lib/backup/DBFOLDER/performance\_schema/setup\_instrument\_2923.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/memory\_summary\_b\_2976.sdi to /var/lib/backup/DBFOLDER/performance\_schema/memory\_summary\_b\_2976.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/file\_summary\_by\_\_2914.sdi to /var/lib/backup/DBFOLDER/performance\_schema/file\_summary\_by\_\_2914.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/replication\_appl\_2986.sdi to /var/lib/backup/DBFOLDER/performance\_schema/replication\_appl\_2986.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/replication\_appl\_2984.sdi to /var/lib/backup/DBFOLDER/performance\_schema/replication\_appl\_2984.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/session\_variable\_3002.sdi to /var/lib/backup/DBFOLDER/performance\_schema/session\_variable\_3002.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/global\_status\_2998.sdi to /var/lib/backup/DBFOLDER/performance\_schema/global\_status\_2998.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/table\_io\_waits\_s\_2926.sdi to /var/lib/backup/DBFOLDER/performance\_schema/table\_io\_waits\_s\_2926.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/replication\_grou\_2988.sdi to /var/lib/backup/DBFOLDER/performance\_schema/replication\_grou\_2988.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/replication\_grou\_2982.sdi to /var/lib/backup/DBFOLDER/performance\_schema/replication\_grou\_2982.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/file\_summary\_by\_\_2915.sdi to /var/lib/backup/DBFOLDER/performance\_schema/file\_summary\_by\_\_2915.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/tls\_channel\_stat\_3007.sdi to /var/lib/backup/DBFOLDER/performance\_schema/tls\_channel\_stat\_3007.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_waits\_sum\_2907.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_waits\_sum\_2907.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_waits\_sum\_2912.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_waits\_sum\_2912.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/socket\_instances\_2966.sdi to /var/lib/backup/DBFOLDER/performance\_schema/socket\_instances\_2966.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/table\_lock\_waits\_2928.sdi to /var/lib/backup/DBFOLDER/performance\_schema/table\_lock\_waits\_2928.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/log\_status\_2991.sdi to /var/lib/backup/DBFOLDER/performance\_schema/log\_status\_2991.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/cond\_instances\_2903.sdi to /var/lib/backup/DBFOLDER/performance\_schema/cond\_instances\_2903.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_stages\_hi\_2931.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_stages\_hi\_2931.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_statement\_2939.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2939.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:51 [01] Copying performance\_schema/events\_errors\_su\_2961.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_errors\_su\_2961.sdi
> 210202 10:31:51 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/setup\_threads\_2925.sdi to /var/lib/backup/DBFOLDER/performance\_schema/setup\_threads\_2925.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/socket\_summary\_b\_2967.sdi to /var/lib/backup/DBFOLDER/performance\_schema/socket\_summary\_b\_2967.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_stages\_hi\_2932.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_stages\_hi\_2932.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/replication\_conn\_2983.sdi to /var/lib/backup/DBFOLDER/performance\_schema/replication\_conn\_2983.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_statement\_2947.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2947.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_stages\_su\_2936.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_stages\_su\_2936.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_transacti\_2950.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_transacti\_2950.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/user\_variables\_b\_2993.sdi to /var/lib/backup/DBFOLDER/performance\_schema/user\_variables\_b\_2993.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_waits\_sum\_2908.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_waits\_sum\_2908.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/session\_account\_\_2970.sdi to /var/lib/backup/DBFOLDER/performance\_schema/session\_account\_\_2970.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/performance\_time\_2919.sdi to /var/lib/backup/DBFOLDER/performance\_schema/performance\_time\_2919.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_errors\_su\_2958.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_errors\_su\_2958.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/status\_by\_host\_2995.sdi to /var/lib/backup/DBFOLDER/performance\_schema/status\_by\_host\_2995.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/data\_lock\_waits\_2980.sdi to /var/lib/backup/DBFOLDER/performance\_schema/data\_lock\_waits\_2980.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/variables\_info\_3003.sdi to /var/lib/backup/DBFOLDER/performance\_schema/variables\_info\_3003.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/keyring\_keys\_2971.sdi to /var/lib/backup/DBFOLDER/performance\_schema/keyring\_keys\_2971.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/host\_cache\_2916.sdi to /var/lib/backup/DBFOLDER/performance\_schema/host\_cache\_2916.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_transacti\_2957.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_transacti\_2957.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/status\_by\_thread\_2996.sdi to /var/lib/backup/DBFOLDER/performance\_schema/status\_by\_thread\_2996.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_transacti\_2955.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_transacti\_2955.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_statement\_2941.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2941.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/variables\_by\_thr\_3000.sdi to /var/lib/backup/DBFOLDER/performance\_schema/variables\_by\_thr\_3000.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_stages\_cu\_2930.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_stages\_cu\_2930.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_transacti\_2953.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_transacti\_2953.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/rwlock\_instances\_2920.sdi to /var/lib/backup/DBFOLDER/performance\_schema/rwlock\_instances\_2920.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/metadata\_locks\_2978.sdi to /var/lib/backup/DBFOLDER/performance\_schema/metadata\_locks\_2978.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_waits\_his\_2906.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_waits\_his\_2906.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/hosts\_2965.sdi to /var/lib/backup/DBFOLDER/performance\_schema/hosts\_2965.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/objects\_summary\_\_2918.sdi to /var/lib/backup/DBFOLDER/performance\_schema/objects\_summary\_\_2918.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_stages\_su\_2935.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_stages\_su\_2935.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/persisted\_variab\_3004.sdi to /var/lib/backup/DBFOLDER/performance\_schema/persisted\_variab\_3004.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/user\_defined\_fun\_3005.sdi to /var/lib/backup/DBFOLDER/performance\_schema/user\_defined\_fun\_3005.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_transacti\_2952.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_transacti\_2952.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/memory\_summary\_b\_2975.sdi to /var/lib/backup/DBFOLDER/performance\_schema/memory\_summary\_b\_2975.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_stages\_su\_2937.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_stages\_su\_2937.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_errors\_su\_2959.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_errors\_su\_2959.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 \>\> log scanned up to (62802692466)
> 210202 10:31:52 [01] Copying performance\_schema/replication\_conn\_2981.sdi to /var/lib/backup/DBFOLDER/performance\_schema/replication\_conn\_2981.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_errors\_su\_2962.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_errors\_su\_2962.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying performance\_schema/events\_statement\_2942.sdi to /var/lib/backup/DBFOLDER/performance\_schema/events\_statement\_2942.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Skipping ./ca.pem.
> 210202 10:31:52 [01] Skipping ./binlog.000078.
> 210202 10:31:52 [01] Skipping ./ibdata1.
> 210202 10:31:52 [01] Skipping ./binlog.index.
> 210202 10:31:52 [01] Skipping ./client-cert.pem.
> 210202 10:31:52 [01] Skipping ./mysqlx.sock.lock.
> 210202 10:31:52 [01] Skipping ./public\_key.pem.
> 210202 10:31:52 [01] Skipping ./private\_key.pem.
> 210202 10:31:52 [01] Skipping ./undo\_001.
> 210202 10:31:52 [01] Copying mysql/general\_log.CSM to /var/lib/backup/DBFOLDER/mysql/general\_log.CSM
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying mysql/slow\_log.CSV to /var/lib/backup/DBFOLDER/mysql/slow\_log.CSV
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying mysql/general\_log.CSV to /var/lib/backup/DBFOLDER/mysql/general\_log.CSV
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying mysql/general\_log\_3029.sdi to /var/lib/backup/DBFOLDER/mysql/general\_log\_3029.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying mysql/slow\_log.CSM to /var/lib/backup/DBFOLDER/mysql/slow\_log.CSM
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Copying mysql/slow\_log\_3031.sdi to /var/lib/backup/DBFOLDER/mysql/slow\_log\_3031.sdi
> 210202 10:31:52 [01] …done
> 210202 10:31:52 [01] Skipping ./binlog.000077.
> 210202 10:31:52 [01] Skipping ./binlog.000076.
> 210202 10:31:52 [01] Skipping ./ib\_logfile0.
> 210202 10:31:52 [01] Skipping ./auto.cnf.
> 210202 10:31:52 Finished backing up non-InnoDB tables and files
> 210202 10:31:52 Executing FLUSH NO\_WRITE\_TO\_BINLOG BINARY LOGS
> 210202 10:31:52 Selecting LSN and binary log position from p\_s.log\_status
> 210202 10:31:52 [00] Copying /var/lib/mysql/binlog.000081 to /var/lib/backup/DBFOLDER/binlog.000081 up to position 156
> 210202 10:31:52 [00] …done
> 210202 10:31:52 [00] Writing /var/lib/backup/DBFOLDER/binlog.index
> 210202 10:31:52 [00] …done
> 210202 10:31:52 [00] Writing /var/lib/backup/DBFOLDER/xtrabackup\_binlog\_info
> 210202 10:31:52 [00] …done
> 210202 10:31:52 Executing FLUSH NO\_WRITE\_TO\_BINLOG ENGINE LOGS…
> xtrabackup: The latest check point (for incremental): ‘62802692466’
> xtrabackup: Stopping log copying thread at LSN 62802692476.
> 210202 10:31:52 \>\> log scanned up to (62802692486)
> Starting to parse redo log at lsn = 62802692120
>
> 210202 10:31:53 All tables unlocked
> 210202 10:31:53 [00] Copying ib\_buffer\_pool to /var/lib/backup/DBFOLDER/ib\_buffer\_pool
> 210202 10:31:53 [00] …done
> 210202 10:31:53 Backup created in directory ‘/var/lib/backup/DBFOLDER/’
> MySQL binlog position: filename ‘binlog.000081’, position ‘156’
> 210202 10:31:53 [00] Writing /var/lib/backup/DBFOLDER/backup-my.cnf
> 210202 10:31:53 [00] …done
> 210202 10:31:53 [00] Writing /var/lib/backup/DBFOLDER/xtrabackup\_info
> 210202 10:31:53 [00] …done
> xtrabackup: Transaction log of lsn (62802692466) to (62802692496) was copied.
> 210202 10:31:54 completed OK!
---
### Author:  [@Eduardo](https://forums.percona.com/u/Eduardo)
#### Post date: [February 2, 2021, 8:21pm UTC](https://forums.percona.com/t/question-about-restore-procedure/9012/6 "2021-02-02T20:21:30Z")
Hi @Andrey_Sm ,
In the XtraBackup command, you are shown, you are filtering the databases with the --databases argument.
`xtrabackup --user=bkpuser --password=PASS --backup --databases=‘mysql sys performance_schema DB-NAME’ --target-dir=/var/lib/backup/DB-NAME`
In the log that you have attached, we do not see any reference to DB-NAME. Suppose the database name you have included in the `--databases` parameter does not exist, such as an error due to a typo error. In that case, Xtrabackup silently ignores it, but obviously, it does not make a backup of this database as it is incorrectly referenced.
Have you tried to do the whole backup without filtering databases?
`xtrabackup --user=bkpuser --password=PASS --backup --target-dir=/var/lib/backup/DB-NAME`
If you are trying to make a partial backup with XtraBackup, I suggest you look at the [documentation](https://www.percona.com/doc/percona-xtrabackup/LATEST/xtrabackup_bin/partial_backups.html) as it has some limitations.
---
### Author:  [@Andrey\_Sm](https://forums.percona.com/u/Andrey_Sm)
#### Post date: [February 2, 2021, 11:26pm UTC](https://forums.percona.com/t/question-about-restore-procedure/9012/7 "2021-02-02T23:26:50Z")
Thanks!
It was a typo in the database name