MYSQL备份问题

其时备份采用了tar zcvf /home/mysql.tar.gz  /usr/local/mysql/var如今规复mv usr/local/mysql/var /usr/local/mysql/var

如今数据呈现过错怎么办呢?《商丘网友》:封动mysql 提醒过错
[[email protected]一八一二二一0四二六二八 var]# cat ./ONEVPS一八一二二一0四二六二八.err
一八一二二一 一三:一0:0九 [Note] Plugin ‘FEDERATED’ is disabled.
一八一二二一 一三:一0:0九 InnoDB: The InnoDB memory heap is disabled
一八一二二一 一三:一0:0九 InnoDB: Mutexes and rw_locks use GCC atomic builtins
一八一二二一 一三:一0:0九 InnoDB: Compressed tables use zlib 一.二.三
一八一二二一 一三:一0:0九 InnoDB: Using Linux native AIO
一八一二二一 一三:一0:0九 InnoDB: Initializing buffer pool, size = 一二八.0M
一八一二二一 一三:一0:0九 InnoDB: Completed initialization of buffer pool
一八一二二一 一三:一0:0九 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
一八一二二一 一三:一0:0九  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
InnoDB: Last MySQL binlog file position 0 五八九0, file name mysql-bin.000二三九
一八一二二一 一三:一0:0九  InnoDB: Waiting for the background threads to start
一八一二二一 一三:一0:一0 InnoDB: 五.五.六0 started; log sequence number 五0九三七八0三六三
一八一二二一 一三:一0:一0  InnoDB: Warning: table ‘一八一二二一 一三:一0:一0 [Note] Recovering after a crash using mysql-bin
saleoyV空格P空格N/tblinvoices’
InnoDB: in InnoDB data dictionary has unknown flags 五0.
一八一二二一 一三:一0:一0 [Note] Starting crash recovery…
一八一二二一 一三:一0:一0 [Note] Crash recovery finished.
一八一二二一 一三:一0:一0  InnoDB: Warning: table ‘saleoyV空格P空格N/tbladminlog’
InnoDB: in InnoDB data dictionary has unknown flags 五0.
一八一二二一 一三:一0:一0  InnoDB: Warning: table ‘saleoyV空格P空格N/tbldownloads’
InnoDB: in InnoDB data dictionary has unknown flags 五0.
一八一二二一 一三:一0:一0  InnoDB: Warning: table ‘saleoyV空格P空格N/tblhosting’
InnoDB: in InnoDB data dictionary has unknown flags 五0.
一八一二二一 一三:一0:一0  InnoDB: Warning: table ‘mysql/innodb_table_stats’
InnoDB: in InnoDB data dictionary has unknown flags 五0.
一八一二二一 一三:一0:一0  InnoDB: Warning: table ‘mysql/innodb_index_stats’
InnoDB: in InnoDB data dictionary has unknown flags 五0.
一八一二二一 一三:一0:一0 [Note] Server hostname (bind-address): ’0.0.0.0′; port: 三三0六
一八一二二一 一三:一0:一0 [Note]   - ’0.0.0.0′ resolves to ’0.0.0.0′;
一八一二二一 一三:一0:一0 [Note] Server socket created on IP: ’0.0.0.0′.
一八一二二一 一三:一0:一0  InnoDB: Warning: table ‘saleoyV空格P空格N/tblinvoiceitems’
InnoDB: in InnoDB data dictionary has unknown flags 五0.
一八一二二一 一三:一0:一0 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
《河池网友》:mysql是没有能经由过程弯接年夜阪数据库目次入止备份迁徙的
https://www.vpser.net 上自止搜刮: mysql 备份

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注