Hello MySQL Community,

Last Friday I changed /etc/mysql/my.cnf file (at server) accidentally. 
I set the variable innodb_data_file_path to  ibdata1:100M

Then I realized that I changed the server copy. Then to get the original value 
I issued the query :
SHOW VARIABLES LIKE  'innodb_data_file_path'

I get the following:
innodb_data_file_path = 
ibdata1:4000M;ibdata2:4000M;ibdata3:4000M;ibdata4:4000M:autoextend

I wrote this value to my.cnf again. 

MySQL isn't restarted in these whole process. Whole thing took 5-10 minutes.

Here is my questions:

if i change something in my.cnf, they are not activated until i restart mysql 
right?

is above scenario safe? Do you think i messed up something?

Thank you for your help.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to