xtrabackup 8备份Mysql 8.0.18的过程是怎么样的
这篇文章给大家介绍xtrabackup 8备份Mysql 8.0.18的过程是怎么样的,内容非常详细,感兴趣的小伙伴们可以参考借鉴,希望对大家能有所帮助。
1、首先 在mysql8里先建了一个稍微大一点的测试表,脚本:
CREATETABLEuser100w(idINTNOTNULLAUTO_INCREMENT,first_nameVARCHAR(10)NOTNULL,last_nameVARCHAR(10)NOTNULL,sexVARCHAR(5)NOTNULL,scoreINTNOTNULL,copy_idINTNOTNULL,PRIMARYKEY(`id`));DROPPROCEDUREIFEXISTSadd_user;DELIMITER//createPROCEDUREadd_user(innumINT)BEGINDECLARErowidINTDEFAULT0;DECLAREfirstnameCHAR(1);DECLAREname1CHAR(1);DECLAREname2CHAR(1);DECLARElastnameVARCHAR(3)DEFAULT'';DECLAREsexCHAR(1);DECLAREscoreCHAR(2);WHILErowid<numDOSETfirstname=SUBSTRING('赵钱孙李周吴郑王林杨柳刘孙陈江阮侯邹高彭徐',FLOOR(1+21*RAND()),1);SETname1=SUBSTRING('一二三四五六七八九十甲乙丙丁静景京晶名明铭敏闵民军君俊骏天田甜兲恬益依成城诚立莉力黎励',ROUND(1+43*RAND()),1);SETname2=SUBSTRING('一二三四五六七八九十甲乙丙丁静景京晶名明铭敏闵民军君俊骏天田甜兲恬益依成城诚立莉力黎励',ROUND(1+43*RAND()),1);SETsex=FLOOR(0+(RAND()*2));SETscore=FLOOR(40+(RAND()*60));SETrowid=rowid+1;IFROUND(RAND())=0THENSETlastname=name1;ENDIF;IFROUND(RAND())=1THENSETlastname=CONCAT(name1,name2);ENDIF;insertINTOuser100w(first_name,last_name,sex,score,copy_id)VALUES(firstname,lastname,sex,score,rowid);ENDWHILE;END//DELIMITER;calladd_user(10000);
2、yum安装依赖
[root@centos1~]#yuminstalllibev
3、下载xtrabackup后,直接用yum安装
[root@centos1opt]#wgethttps://www.percona.com/downloads/Percona-XtraBackup-LATEST/Percona-XtraBackup-8.0-7/binary/redhat/7/x86_64/percona-xtrabackup-80-8.0.7-1.el7.x86_64.rpm
Savingto:‘percona-xtrabackup-80-8.0.7-1.el7.x86_64.rpm’100%[+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++=======================>]12,177,71222.2KB/sin2m20s2019-11-0817:39:37(21.5KB/s)-‘percona-xtrabackup-80-8.0.7-1.el7.x86_64.rpm’saved[12177712/12177712][root@centos1opt]#yumlocalinstallpercona-xtrabackup-80-8.0.7-1.el7.x86_64.rpmInstalled:percona-xtrabackup-80.x86_640:8.0.7-1.el7DependencyInstalled:perl-Compress-Raw-Bzip2.x86_640:2.061-3.el7perl-Compress-Raw-Zlib.x86_641:2.061-4.el7perl-DBD-MySQL.x86_640:4.023-6.el7perl-DBI.x86_640:1.627-4.el7perl-Digest.noarch0:1.17-245.el7perl-Digest-MD5.x86_640:2.52-3.el7perl-IO-Compress.noarch0:2.061-2.el7perl-Net-Daemon.noarch0:0.48-5.el7perl-PlRPC.noarch0:0.2020-14.el7Complete![root@centos1opt]#xtrabackup-vxtrabackup:recognizedserverarguments:--datadir=/var/lib/mysqlxtrabackupversion8.0.7basedonMySQLserver8.0.16Linux(x86_64)(revisionid:069e0e6)
问题来了 我的mysql是8.0.18的(装好之后发现并没有什么问题)
4、开始备份
一些参数:
According to your system, you may need to specify one or more of the following options to connect to the server:
备份(如果不是localhost的远程备份的话,mysql需要更新User表可以远程登录):
[mysql@centos1~]$xtrabackup--defaults-file=/data/mysql/my.cnf--host=localhost--user=root--password=mysqlWAI--port=3306--socket=/data/mysql/run/mysql.sock--backup--target-dir=/home/mysql/xbackup/
备份时插入一条数据做测试
mysql>select*fromtest1;+------+------+|id|code|+------+------+|1|3009||2|3010||3|3011|+------+------+3rowsinset(0.00sec)mysql>insertintotest1values(4,3099);
备份完成会提示:
19111118:09:24Alltablesunlocked19111118:09:24Backupcreatedindirectory'/home/mysql/xbackup/'MySQLbinlogposition:filename'mysql-bin.000004',position'155'19111118:09:24[00]Writing/home/mysql/xbackup/backup-my.cnf19111118:09:24[00]...done19111118:09:24[00]Writing/home/mysql/xbackup/xtrabackup_info19111118:09:24[00]...donextrabackup:Transactionlogoflsn(23556373)to(23556739)wascopied.19111118:09:24completedOK!
查看一下备份的情况
[mysql@centos1xbackup]$lltotal2142252-rw-r-----1mysqlmysql499Nov1118:09backup-my.cnf-rw-r-----1mysqlmysql2147483648Nov1118:09ibdata1drwxr-x---2mysqlmysql157Nov1118:09mysql-rw-r-----1mysqlmysql155Nov1118:09mysql-bin.000004-rw-r-----1mysqlmysql36Nov1118:09mysql-bin.index-rw-r-----1mysqlmysql25165824Nov1118:09mysql.ibddrwxr-x---2mysqlmysql8192Nov1118:09performance_schemadrwxr-x---2mysqlmysql43Nov1118:09srlgdrwxr-x---2mysqlmysql28Nov1118:09sys-rw-r-----1mysqlmysql10485760Nov1118:09undo_001-rw-r-----1mysqlmysql10485760Nov1118:09undo_002-rw-r-----1mysqlmysql21Nov1118:09xtrabackup_binlog_info-rw-r-----1mysqlmysql95Nov1118:09xtrabackup_checkpoints-rw-r-----1mysqlmysql581Nov1118:09xtrabackup_info-rw-r-----1mysqlmysql3072Nov1118:09xtrabackup_logfile-rw-r-----1mysqlmysql264Nov1118:09xtrabackup_tablespaces
[mysql@centos1xbackup]$catxtrabackup_checkpointsbackup_type=full-backupedfrom_lsn=0to_lsn=23556719last_lsn=23556729flushed_lsn=0
[mysql@centos1xbackup]$catxtrabackup_infouuid=562944f7-046b-11ea-984b-10e7c62c3e49name=tool_name=xtrabackuptool_command=--defaults-file=/data/mysql/my.cnf--host=localhost--user=root--password=...--port=3306--socket=/data/mysql/run/mysql.sock--backup--target-dir=/home/mysql/xbackup/tool_version=8.0.7ibbackup_version=8.0.7server_version=8.0.18start_time=2019-11-1118:08:43end_time=2019-11-1118:09:24lock_time=0binlog_pos=filename'mysql-bin.000004',position'155'innodb_from_lsn=0innodb_to_lsn=23556719partial=Nincremental=Nformat=filecompressed=Nencrypted=N
此时删掉mysql一个表作测试
mysql>showtables->;+----------------+|Tables_in_srlg|+----------------+|test1||user100w|+----------------+2rowsinset(0.00sec)mysql>droptableuser100w;QueryOK,0rowsaffected(0.10sec)
创建备份用户根据官方:
An SQL example of creating a database user with the minimum privileges required to full backups would be:
mysql>CREATEUSER'bkpuser'@'localhost'IDENTIFIEDBY's3cr%T';mysql>GRANTBACKUP_ADMIN,PROCESS,RELOAD,LOCKTABLES,REPLICATIONCLIENTON*.*TO'bkpuser'@'localhost';mysql>GRANTSELECTONperformance_schema.log_statusTO'bkpuser'@'localhost';mysql>FLUSHPRIVILEGES;
准备恢复
[mysql@centos1~]$xtrabackup--defaults-file=/data/mysql/my.cnf--user=root--prepare--target-dir=/home/mysql/xbackup/Created128andtracked128newrollbacksegment(s)inthetemporarytablespace.128arenowactive.Pagecleanertook23005mstoflush0andevict0pages8.0.16started;logsequencenumber23557132xtrabackup:startingshutdownwithinnodb_fast_shutdown=1FTSoptimizethreadexiting.Startingshutdown...Logbackgroundthreadsarebeingclosed...Shutdowncompleted;logsequencenumber2355713219111118:32:11completedOK![mysql@centos1~]$[mysql@centos1~]$xtrabackup--defaults-file=/data/mysql/my.cnf--user=root--copy-back--target-dir=/home/mysql/xbackup/
报错
[mysql@centos1~]$xtrabackup--defaults-file=/data/mysql/my.cnf--user=root--copy-back--target-dir=/home/mysql/xbackup/xtrabackup:[ERROR]Failedtoopenrequireddefaultsfile:/data/mysql/my.cnf--user=rootxtrabackup:[ERROR]Fatalerrorindefaultshandling.Programaborted!
修改权限
[root@centos1mysql]#chmod755/data/mysql/my.cnf
[mysql@centos1~]$xtrabackup--defaults-file=/data/mysql/my.cnf--user=mysql--copy-back--target-dir=/home/mysql/xbackup/xtrabackup:recognizedserverarguments:--datadir=/data/mysql/data--tmpdir=/data/mysql/tmp--open_files_limit=65535--server-id=1--log_bin=/data/mysql/binlog/mysql-bin--innodb_buffer_pool_size=4096M--innodb_file_per_table=1--innodb_data_home_dir=/data/mysql/innodb_ts--innodb_data_file_path=ibdata1:2048M:autoextend--innodb_log_buffer_size=67108864--innodb_log_file_size=1048576000--innodb_log_files_in_group=4--innodb_undo_directory=/data/mysql/undo_space--innodb_log_group_home_dir=/data/mysql/innodb_log--innodb_flush_log_at_trx_commit=2--innodb_max_dirty_pages_pct=60--innodb_open_files=60000--innodb_read_io_threads=4--innodb_flush_method=O_DIRECTxtrabackup:recognizedclientarguments:--port=3306--socket=/data/mysql/run/mysql.sock--user=mysql--copy-back=1--target-dir=/home/mysql/xbackup/xtrabackupversion8.0.7basedonMySQLserver8.0.16Linux(x86_64)(revisionid:069e0e6)Originaldatadirectory/data/mysql/dataisnotempty!
oh 对了恢复的话 相关文件目录/data/mysql/data要删掉。。。 重来吧
看看备份目录内容 多了一些日志:
[mysql@centos1data]$cd/home/mysql/xbackup[mysql@centos1xbackup]$lltotal6258732-rw-r-----1mysqlmysql499Nov1118:09backup-my.cnf-rw-r-----1mysqlmysql2147483648Nov1118:32ibdata1-rw-r-----1mysqlmysql1048576000Nov1118:32ib_logfile0-rw-r-----1mysqlmysql1048576000Nov1118:31ib_logfile1-rw-r-----1mysqlmysql1048576000Nov1118:31ib_logfile2-rw-r-----1mysqlmysql1048576000Nov1118:32ib_logfile3-rw-r-----1mysqlmysql12582912Nov1118:32ibtmp1drwxrwx---2mysqlmysql6Nov1118:32#innodb_tempdrwxr-x---2mysqlmysql157Nov1118:09mysql-rw-r-----1mysqlmysql155Nov1118:09mysql-bin.000004-rw-r-----1mysqlmysql36Nov1118:09mysql-bin.index-rw-r-----1mysqlmysql25165824Nov1118:09mysql.ibddrwxr-x---2mysqlmysql8192Nov1118:09performance_schemadrwxr-x---2mysqlmysql43Nov1118:09srlgdrwxr-x---2mysqlmysql28Nov1118:09sys-rw-r-----1mysqlmysql10485760Nov1118:09undo_001-rw-r-----1mysqlmysql10485760Nov1118:09undo_002-rw-r-----1mysqlmysql21Nov1118:09xtrabackup_binlog_info-rw-r-----1mysqlmysql95Nov1118:31xtrabackup_checkpoints-rw-r-----1mysqlmysql581Nov1118:09xtrabackup_info-rw-r-----1mysqlmysql8388608Nov1118:31xtrabackup_logfile-rw-rw-r--1mysqlmysql1Nov1118:31xtrabackup_master_key_id-rw-r-----1mysqlmysql264Nov1118:32xtrabackup_tablespaces
[mysql@centos1xbackup]$cd/data/mysql[mysql@centos1mysql]$lltotal36drwxrwxr-x2mysqlmysql6Oct3015:31backupdrwxrwxr-x2mysqlmysql125Nov1118:09binlogdrwxr-xr-x7mysqlmysql288Nov811:25datadrwxrwxr-x2mysqlmysql82Oct3111:29innodb_logdrwxrwxr-x2mysqlmysql57Nov811:25innodb_tsdrwxr-xr-x2mysqlmysql6Oct2516:29log-rwxr-xr-x1mysqlmysql2690Oct3112:02my.cnf-rw-r-----1mysqlmysql6Nov811:25mysqld.pid-rw-r-----1mysqlmysql24410Nov1118:08mysql-error.logdrwxr-xr-x2mysqlmysql90Nov811:25rundrwxrwxr-x2mysqlmysql6Oct3015:31scripts-rw-r-----1mysqlmysql744Nov813:23slow_statement.logdrwxr-xr-x3mysqlmysql53Oct2917:26tmpdrwxr-x---2mysqlmysql38Oct3111:29undo_space[mysql@centos1mysql]$mvdatadata_bk[mysql@centos1mysql]$mvbinlogbinlog_bk[mysql@centos1mysql]$mvinnodb_loginnodb_log_bk[mysql@centos1mysql]$cdinnodb_ts/[mysql@centos1innodb_ts]$lltotal2109448-rw-r-----1mysqlmysql4509Oct3117:34ib_buffer_pool-rw-r-----1mysqlmysql2147483648Nov1118:34ibdata1-rw-r-----1mysqlmysql12582912Nov811:26ibtmp1[mysql@centos1innodb_ts]$cd..[mysql@centos1mysql]$mvinnodb_tsinnodb_ts_bk[mysql@centos1mysql]$cdlog[mysql@centos1log]$lltotal0[mysql@centos1log]$cd..[mysql@centos1mysql]$cdtmp[mysql@centos1tmp]$lltotal113284drwxr-xr-x8rootroot319Apr102019boost_1_70_0-rw-r--r--1rootroot116000903Oct2917:26boost_1_70_0.tar.gz[mysql@centos1tmp]$cd..[mysql@centos1mysql]$cdundo_space/[mysql@centos1undo_space]$lltotal20480-rw-r-----1mysqlmysql10485760Nov1118:34undo_001-rw-r-----1mysqlmysql10485760Nov1118:33undo_002[mysql@centos1undo_space]$cd..[mysql@centos1mysql]$mvundo_spaceundo_space_bk[mysql@centos1mysql]$lltotal36drwxrwxr-x2mysqlmysql6Oct3015:31backupdrwxrwxr-x2mysqlmysql125Nov1118:09binlog_bkdrwxr-xr-x7mysqlmysql288Nov811:25data_bkdrwxrwxr-x2mysqlmysql82Oct3111:29innodb_log_bkdrwxrwxr-x2mysqlmysql57Nov811:25innodb_ts_bkdrwxr-xr-x2mysqlmysql6Oct2516:29log-rwxr-xr-x1mysqlmysql2690Oct3112:02my.cnf-rw-r-----1mysqlmysql6Nov811:25mysqld.pid-rw-r-----1mysqlmysql24410Nov1118:08mysql-error.logdrwxr-xr-x2mysqlmysql90Nov811:25rundrwxrwxr-x2mysqlmysql6Oct3015:31scripts-rw-r-----1mysqlmysql744Nov813:23slow_statement.logdrwxr-xr-x3mysqlmysql53Oct2917:26tmpdrwxr-x---2mysqlmysql38Oct3111:29undo_space_bk
这样很多很麻烦啊。。对了我直接删掉整个目录就好了吧。。。
[mysql@centos1mysql]$cd..[mysql@centos1data]$lltotal0drwxr-xr-x12mysqlmysql243Nov1211:00mysql[mysql@centos1data]$mvmysqlmysql_bkmv:cannotmove‘mysql’to‘mysql_bk’:Permissiondenied[mysql@centos1data]$lltotal0drwxr-xr-x12mysqlmysql243Nov1211:00mysql[mysql@centos1data]$su-rootPassword:su:Authenticationfailure[mysql@centos1data]$su-rootPassword:Lastlogin:TueNov1210:40:42CST2019fromdesktop-v9u5026onpts/1Lastfailedlogin:TueNov1211:04:08CST2019onpts/1Therewas1failedloginattemptsincethelastsuccessfullogin.[root@centos1~]#chmod755/data/mysql[root@centos1~]#cd/data[root@centos1data]#lltotal0drwxr-xr-x12mysqlmysql243Nov1211:00mysql
[root@centos1data]#chmod777/data/mysql[root@centos1data]#lltotal0drwxrwxrwx12mysqlmysql243Nov1211:00mysql[root@centos1data]#su-mysqlLastlogin:TueNov1210:45:32CST2019onpts/1[mysql@centos1~]$cd/data[mysql@centos1data]$lltotal0drwxrwxrwx12mysqlmysql243Nov1211:00mysql[mysql@centos1data]$mvmysqlmysql_bkmv:cannotmove‘mysql’to‘mysql_bk’:Permissiondenied[mysql@centos1data]$lltotal0drwxrwxrwx12mysqlmysql243Nov1211:00mysql[mysql@centos1data]$cd[mysql@centos1~]$pwd/home/mysql
好吧 不行mv不了 还是按刚刚那样吧
重新做恢复的过程,先看看进程吧
[mysql@centos1mysql]$ps-ef|grepmysqlroot88678496010:45pts/100:00:00su-mysqlmysql88688867010:45pts/100:00:00-bashmysql985010Nov08?00:00:00/bin/sh/usr/local/mysql/bin/mysqld_safe--defaults-file=/data/mysql/my.cnf--user=mysqlroot1046810216011:07pts/100:00:00su-mysqlmysql1046910468011:07pts/100:00:00-bashmysql1073898500Nov08?00:48:01/usr/local/mysql/bin/mysqld--defaults-file=/data/mysql/my.cnf--basedir=/usr/localmysql--datadir=/data/mysql/data--plugin-dir=/usr/local/mysql/lib/plugin--log-error=/data/mysql/mysql-error.log--open-files-limit=65535--pid-file=/data/mysql/mysqld.pid--socket=/data/mysql/run/mysql.sock--port=3306mysql1100910469011:14pts/100:00:00ps-efmysql1101010469011:14pts/100:00:00grep--color=automysql
什么鬼?我记得我停掉mysql了啊 竟然忘了? 那当然不能mv mysql了啊 晕。。。
停掉mysql
[mysql@centos1bin]$/usr/local/mysql/bin/mysqladmin-h127.0.0.1-uroot-pmysqlWAI-P3306-S/data/mysql/run/mysql.sockshutdownmysqladmin:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.[mysql@centos1bin]$ps-ef|grepmysqlroot88678496010:45pts/100:00:00su-mysqlmysql88688867010:45pts/100:00:00-bashroot1046810216011:07pts/100:00:00su-mysqlmysql1046910468011:07pts/100:00:00-bashmysql1134110469011:19pts/100:00:00ps-efmysql1134210469011:19pts/100:00:00grep--color=automysql
重新创建空目录
[mysql@centos1mysql]$mkdirdata[mysql@centos1mysql]$mkdirbinlog[mysql@centos1mysql]$mkdirinnodb_log[mysql@centos1mysql]$mkdirinnodb_ts[mysql@centos1mysql]$mkdirundo_space[mysql@centos1mysql]$mvtmptmp_bk[mysql@centos1mysql]$mkdirtmp
准备恢复 --prepare (这个好像是将备份集备份后MySQL运行产生的日志合并之类的)
[mysql@centos1mysql]$xtrabackup--defaults-file=/data/mysql/my.cnf--user=root--prepare--target-dir=/home/mysql/xbackup/CreatingsharedtablespacefortemporarytablesSettingfile'./ibtmp1'sizeto12MB.Physicallywritingthefilefull;Pleasewait...File'./ibtmp1'sizeisnow12MB.Scanningtemptablespacedir:'./#innodb_temp/'Created128andtracked128newrollbacksegment(s)inthetemporarytablespace.128arenowactive.8.0.16started;logsequencenumber23557132xtrabackup:startingshutdownwithinnodb_fast_shutdown=1FTSoptimizethreadexiting.Startingshutdown...Logbackgroundthreadsarebeingclosed...Shutdowncompleted;logsequencenumber2355713219111211:30:58completedOK!
跟上次的序列号是一样的 大概是因为没有产生过数据变更
--copy-back:
[mysql@centos1~]$xtrabackup--defaults-file=/data/mysql/my.cnf--user=mysql--copy-back--target-dir=/home/mysql/xbackup/19111211:38:32[01]Copying./xtrabackup_infoto/data/mysql/data/xtrabackup_info19111211:38:32[01]...done19111211:38:32[01]Copying./xtrabackup_master_key_idto/data/mysql/data/xtrabackup_master_key_id19111211:38:32[01]...done19111211:38:32[01]Copying./ibtmp1to/data/mysql/data/ibtmp119111211:38:32[01]...done19111211:38:32[01]Creatingdirectory./#innodb_temp19111211:38:32[01]...done.19111211:38:32completedOK!
查看恢复后的文件,新建的文件夹有数据了:
[mysql@centos1~]$cd/data/mysql[mysql@centos1mysql]$lltotal36drwxrwxr-x2mysqlmysql6Oct3015:31backupdrwxrwxr-x2mysqlmysql53Nov1211:38binlogdrwxrwxr-x2mysqlmysql125Nov1118:09binlog_bkdrwxrwxr-x6mysqlmysql154Nov1211:38datadrwxr-xr-x7mysqlmysql288Nov811:25data_bkdrwxrwxr-x2mysqlmysql82Nov1211:37innodb_logdrwxrwxr-x2mysqlmysql82Oct3111:29innodb_log_bkdrwxrwxr-x2mysqlmysql21Nov1211:37innodb_tsdrwxrwxr-x2mysqlmysql57Nov811:25innodb_ts_bkdrwxr-xr-x2mysqlmysql6Oct2516:29log-rwxr-xr-x1mysqlmysql2690Oct3112:02my.cnf-rw-r-----1mysqlmysql25145Nov1211:18mysql-error.logdrwxr-xr-x2mysqlmysql6Nov1211:18rundrwxrwxr-x2mysqlmysql6Oct3015:31scripts-rw-r-----1mysqlmysql744Nov813:23slow_statement.logdrwxrwxr-x2mysqlmysql6Nov1211:25tmpdrwxr-xr-x3mysqlmysql53Oct2917:26tmp_bkdrwxrwxr-x2mysqlmysql38Nov1211:37undo_spacedrwxr-x---2mysqlmysql38Oct3111:29undo_space_bk[mysql@centos1mysql]$cddata[mysql@centos1data]$lltotal36884-rw-r-----1mysqlmysql12582912Nov1211:38ibtmp1drwxr-x---2mysqlmysql157Nov1211:38mysql-rw-r-----1mysqlmysql25165824Nov1211:38mysql.ibddrwxr-x---2mysqlmysql8192Nov1211:38performance_schemadrwxr-x---2mysqlmysql43Nov1211:38srlgdrwxr-x---2mysqlmysql28Nov1211:38sys-rw-r-----1mysqlmysql581Nov1211:38xtrabackup_info-rw-r-----1mysqlmysql1Nov1211:38xtrabackup_master_key_id[mysql@centos1data]$cd..[mysql@centos1mysql]$cdbinlog[mysql@centos1binlog]$lltotal8-rw-r-----1mysqlmysql155Nov1211:38mysql-bin.000004-rw-r-----1mysqlmysql36Nov1211:38mysql-bin.index
启动mysql:
[mysql@centos1~]$/usr/local/mysql/bin/mysqld_safe--defaults-file=/data/mysql/my.cnf--user=mysql&[1]13666[mysql@centos1~]$2019-11-12T03:51:22.072187Zmysqld_safeLoggingto'/data/mysql/mysql-error.log'.2019-11-12T03:51:22.147329Zmysqld_safeStartingmysqlddaemonwithdatabasesfrom/data/mysql/data
[mysql@centos1~]$ps-ef|grepmysqlroot88678496010:45pts/100:00:00su-mysqlmysql88688867010:45pts/100:00:00-bashroot1046810216011:07pts/100:00:00su-mysqlmysql1046910468011:07pts/100:00:00-bashroot1267012624011:37pts/000:00:00su-mysqlmysql1267112670011:37pts/000:00:00-bashmysql1366612671011:51pts/000:00:00/bin/sh/usr/local/mysql/bin/mysqld_safe--defaults-file=/data/mysql/my.cnf--user=mysqlmysql1455513666511:51pts/000:00:01/usr/local/mysql/bin/mysqld--defaults-file=/data/mysql/my.cnf--basedir=/usr/localmysql--datadir=/data/mysql/data--plugin-dir=/usr/local/mysql/lib/plugin--log-error=/data/mysql/mysql-error.log--open-files-limit=65535--pid-file=/data/mysql/mysqld.pid--socket=/data/mysql/run/mysql.sock--port=3306root1466614621011:51pts/200:00:00su-mysqlmysql1466714666011:51pts/200:00:00-bashmysql1471314667011:51pts/200:00:00ps-efmysql1471414667011:51pts/200:00:00grep--color=automysql
登录
[mysql@centos1~]$mysql-uroot-pEnterpassword:WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis8Serverversion:8.0.18nancyeditionCopyright(c)2000,2019,Oracleand/oritsaffiliates.Allrightsreserved.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.
mysql>usesrlgDatabasechangedmysql>showtables;+----------------+|Tables_in_srlg|+----------------+|test1||user100w|+----------------+2rowsinset(0.02sec)mysql>select*fromtest1;+------+------+|id|code|+------+------+|1|3009||2|3010||3|3011||4|3099|+------+------+4rowsinset(0.02sec)mysql>selectcount(*)fromuser100w;+----------+|count(*)|+----------+|10000|+----------+1rowinset(0.02sec)
查看备份时候插入的数据,以及备份之后删除的表都存在。
关于xtrabackup 8备份Mysql 8.0.18的过程是怎么样的就分享到这里了,希望以上内容可以对大家有一定的帮助,可以学到更多知识。如果觉得文章不错,可以把它分享出去让更多的人看到。
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。