N
N
Northern Lights2021-07-03 16:26:15
ISPmanager
Northern Lights, 2021-07-03 16:26:15

How to initialize mysql in ISPManager?

Hello.
On the ISPmanager Lite 6.8.2 server,
I would like to make mysql settings regarding the storage of temporary table space and ibdata files:

innodb_data_home_dir=/var/lib/mysql_idata

# хранить индексы и другую служебную информацию по нескольким файлам
innodb_data_file_path=ibdata/ibdata1:500M;ibdata/ibdata2:500M;ibdata/ibdata3:500M;ibdata/ibdata4:500M;ibdata/ibdata5:10M:autoextend:max:1G

# Управление временным табличным пространством
innodb_temp_data_file_path=ibtmp/ibtmp1:500M;ibtmp/ibtmp2:500M;ibtmp/ibtmp3:500M;ibtmp/ibtmp4:500M;ibtmp/ibtmp5:12M:autoextend:max:1G


To do this, you need to stop the server, delete all the contents of /var/lib/mysql and start the initialization again:
mysql --initialize

ISPmanager, as far as I understand, does not allow this out of the box - edits of this kind through the database settings panel lead to crash, and the option to delete /var /lib/mysql and subsequent initialization leads to an error
mysql: [ERROR] unknown option '--initialize'.

Is this somehow solved within ISPmanager?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question