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?
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.
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?
Can you show the full output you get from xtrabackup ?
#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!
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.
Thanks!
It was a typo in the database name