1. Stop mysql service [LAB] root@jptkytcdh01vl ~ # service mysqld stop Stopping mysqld: [ OK ]
2. Remove innodb related files [LAB] root@jptkytcdh01vl /var/lib/mysql # mkdir bak [LAB] root@jptkytcdh01vl /var/lib/mysql # mv ib_logfile1 bak [LAB] root@jptkytcdh01vl /var/lib/mysql # mv ib_buffer_pool bak [LAB] root@jptkytcdh01vl /var/lib/mysql # mv ib_logfile0 bak [LAB] root@jptkytcdh01vl /var/lib/mysql # mv ibdata1 bak
3. Add below lines. [LAB] root@jptkytcdh01vl /var/lib/mysql # diff /etc/my.cnf /etc/my.cnf.20180803 9,10d8 < innodb_data_home_dir=/var/lib/mysql < innodb_data_file_path=ibdata1:500m;ibdata2:500m
4. Start mysql service [LAB] root@jptkytcdh01vl /var/lib/mysql # service mysqld start Starting mysqld:
