mysql常見錯誤

標籤：

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 12 22:00 /var/lib/mysql/ibdata1由於參數設定和實際的檔案大小不一致，啟動mysql出現了上述的故障此時我們可以選擇修改my.cnf檔案的配置或者直接注釋掉這個參數設定，讓mysql啟動時用預設參數去檢驗或者My.cnf檔案中指定該參數等於實際檔案的大小[[email protected] mysql]# less /etc/my.cnf |grep innodb_data_file_pathinnodb_data_file_path = ibdata1:18M:autoextend

　　

mysql常見錯誤