MySQL Forums
Forum List  »  InnoDB

Re: Caonot change innodb_data_file_path
Posted by: Rick James
Date: November 25, 2012 02:28PM

> innodb_data_file_path = ibdata1:10M:autoextend
> If I change the size to say 100M,

Once you have started MySQL, there is no need to change (and nothing to be gained by changing) the 10M to anything else. It will continue to grow as needed because it says autoextend.

When it started up, it got confused because there was not at least 100M in the file ibdata1.

Change it back, and restart.

> I tried to delete all ib_log_file and ibdata files
That will lose any table you have already built.

> but it did not help - the only working setting is the default one.
That's surprising, since it creates iblog and ibdata files when they are missing.

Options: ReplyQuote


Subject
Views
Written By
Posted
6064
November 24, 2012 08:35AM
Re: Caonot change innodb_data_file_path
2066
November 25, 2012 02:28PM
1709
November 27, 2012 05:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.