Mysql Common Errors: telnet

Mysql Common Errors: telnet

1. [ERROR] InnoDB: Data file/usr/local/mysql-5.6.30/data3306/ibdata1 is of a different size

[Root @ localhost mysql] # less/etc/my. cnf | grep innodb_data_file_pathinnodb_data_file_path = ibdata1: 200 M: autoextend [root @ localhost mysql] # ls-lh/var/lib/mysql/ibdata1-rw-rw ---- 1 mysql 18 M Nov 12/var/lib/mysql/ibdata1 due to parameter setting and the actual file size is inconsistent, when the above fault occurs when mysql is started, we can choose to modify my. cnf file configuration or directly comment out this parameter setting, so that mysql can use the default parameter to check or My. specify this parameter in the cnf file to be equal to the actual file size [root @ localhost mysql] # less/etc/my. cnf | grep innodb_data_file_pathinnodb_data_file_path = ibdata1: 18 M: autoextend