Question about restore procedure

Andrey_Sm · January 29, 2021, 1:00pm

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?

vadimtk · January 29, 2021, 3:44pm

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.

Andrey_Sm · February 2, 2021, 5:47pm

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?

vadimtk · February 2, 2021, 6:05pm

Can you show the full output you get from xtrabackup ?

Andrey_Sm · February 2, 2021, 6:36pm

#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!

Eduardo · February 2, 2021, 8:21pm

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 as it has some limitations.

Andrey_Sm · February 2, 2021, 11:26pm

Thanks!

It was a typo in the database name

Topic		Replies	Views
Single table restore from Xtrabackup Percona XtraBackup	8	740	August 12, 2022
New and hoping for a direction on restoration Percona XtraBackup	1	176	January 20, 2024
[Newbie] Question about restore Percona XtraBackup	0	286	January 11, 2011
Restoring Particular database using Xtrabackup Percona XtraBackup mysql , percona	1	103	March 20, 2024
Procedure to restore a single database from a full innobackupex backup Percona XtraBackup	0	1176	November 16, 2015

Question about restore procedure

Related Topics