MySQL Common errors

1. [ERROR] Innodb:data File/usr/local/mysql-5.6.30/data3306/ibdata1 is of a different size

[Email protected] mysql]# less/etc/my.cnf |grep innodb_data_file_pathinnodb_data_file_path = ibdata1:200m:autoextend [[email protected] mysql]# LS-LH/VAR/LIB/MYSQL/IBDATA1-RW-RW----1 mysql mysql 18M Nov 22:00/var/lib/mysql/ibdata1 due The parameter setting and the actual file size are inconsistent, the start of MySQL has the above-mentioned failure at this time we can choose to modify the configuration of the my.cnf file or directly comment out the parameter settings, let MySQL start with the default parameters to verify or my.cnf file to specify that the parameter is equal to the actual file size [[ Email protected] mysql]# less/etc/my.cnf |grep innodb_data_file_pathinnodb_data_file_path = ibdata1:18m:autoextend

This article from "Do not abandon!" Do not give up "blog, be sure to keep this source http://thedream.blog.51cto.com/6427769/1835748

Common MySQL errors