mysql⽆法启动Couldnotopenlogfile
由于服务器空间不够，mysql ⽆法启动
ERROR! The server quit without updating PID file (/usr/local/mysql/var/xxx.pid).
就把mysql-bin.000070的⽂件删了，结果重启后出现错误
17120314:26:11 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 3914 ...
免费下ppt模板的网站
17120314:26:12 [Note] Plugin 'FEDERATED'is disabled.
17120314:26:12 InnoDB: The InnoDB memory heap is disabled
17120314:26:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
17120314:26:12 InnoDB: Compressed tables use zlib 1.2.3
17120314:26:12 InnoDB: Initializing buffer pool, size = 4.0G
17120314:26:12 InnoDB: Completed initialization of buffer pool
17120314:26:12 InnoDB: highest supported file format is Barracuda.
17120314:26:12  InnoDB: Waiting for the background threads to start数据库not exists用法
17120314:26:13 InnoDB: 5.5.48 started; log sequence number 191234988217
lpl全球总决赛冠军/usr/local/mysql/bin/mysqld: File './mysql-bin.000070' not found (Errcode: 2)
java导出pdf17120314:26:13 [ERROR] Failed to open log (file './mysql-bin.000070', errno 2)
17120314:26:13 [ERROR] Could not open log file
17120314:26:13 [ERROR] Can't init tc log
17120314:26:13 [ERROR] Aborting
17120314:26:13  InnoDB:
17120314:26:14  InnoDB: Shutdown completed; log sequence number 191234988217
17120314:26:14 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
mysql无法连接到服务器
于是尝试先注释掉myf  log-bin
log-bin=mysql-bin配置与主从配置有关，并且它记录了所有数据库的操作，⽤于灾难恢复，所以注释掉它也是有⼀定风险的，需要定时备份数据库！
>短期java培训班

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。