VPS侦探论坛

 找回密码
 注册
搜索
查看: 448|回复: 2

MYSQL备份问题

[复制链接]
发表于 2018-12-21 13:07:19 | 显示全部楼层 |阅读模式



当时备份采用了tar zcvf /home/mysql.tar.gz  /usr/local/mysql/var现在恢复mv usr/local/mysql/var /usr/local/mysql/var


现在数据出现错误怎么办呢?
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org/
 楼主| 发表于 2018-12-21 13:10:20 | 显示全部楼层



启动mysql 提示错误
[root@ONEVPS181221042628 var]# cat ./ONEVPS181221042628.err
181221 13:10:09 [Note] Plugin 'FEDERATED' is disabled.
181221 13:10:09 InnoDB: The InnoDB memory heap is disabled
181221 13:10:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
181221 13:10:09 InnoDB: Compressed tables use zlib 1.2.3
181221 13:10:09 InnoDB: Using Linux native AIO
181221 13:10:09 InnoDB: Initializing buffer pool, size = 128.0M
181221 13:10:09 InnoDB: Completed initialization of buffer pool
181221 13:10:09 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!
181221 13:10:09  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 5890, file name mysql-bin.000239
181221 13:10:09  InnoDB: Waiting for the background threads to start
181221 13:10:10 InnoDB: 5.5.60 started; log sequence number 5093780363
181221 13:10:10  InnoDB: Warning: table '181221 13:10:10 [Note] Recovering after a crash using mysql-bin
saleoyV空格P空格N/tblinvoices'
InnoDB: in InnoDB data dictionary has unknown flags 50.
181221 13:10:10 [Note] Starting crash recovery...
181221 13:10:10 [Note] Crash recovery finished.
181221 13:10:10  InnoDB: Warning: table 'saleoyV空格P空格N/tbladminlog'
InnoDB: in InnoDB data dictionary has unknown flags 50.
181221 13:10:10  InnoDB: Warning: table 'saleoyV空格P空格N/tbldownloads'
InnoDB: in InnoDB data dictionary has unknown flags 50.
181221 13:10:10  InnoDB: Warning: table 'saleoyV空格P空格N/tblhosting'
InnoDB: in InnoDB data dictionary has unknown flags 50.
181221 13:10:10  InnoDB: Warning: table 'mysql/innodb_table_stats'
InnoDB: in InnoDB data dictionary has unknown flags 50.
181221 13:10:10  InnoDB: Warning: table 'mysql/innodb_index_stats'
InnoDB: in InnoDB data dictionary has unknown flags 50.
181221 13:10:10 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
181221 13:10:10 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
181221 13:10:10 [Note] Server socket created on IP: '0.0.0.0'.
181221 13:10:10  InnoDB: Warning: table 'saleoyV空格P空格N/tblinvoiceitems'
InnoDB: in InnoDB data dictionary has unknown flags 50.
181221 13:10:10 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2018-12-21 20:14:01 | 显示全部楼层



mysql是不能通过直接大阪数据库目录进行备份迁移的
https://www.vpser.net 上自行搜索: mysql 备份
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org/
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2019-6-25 00:40 , Processed in 0.040691 second(s), 26 queries .

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表