Page 1 of 1

Avoid creation of "ibdata1"

Posted: Thu 10 Jan 2019 09:22
by rahucha
Hi,

Is it possible to avoid the creation of the "ibdata1" file?

With the "--skip-innodb" parameter I can avoid the creation of the LOG files (ib_logfile0, ib_logfile1). But what about "ibdata1"?

Thanks!

Re: Avoid creation of "ibdata1"

Posted: Thu 10 Jan 2019 12:18
by ViktorV
The skip-innodb option works only for the versions MySQL 5.6 and lower: https://dev.mysql.com/doc/refman/5.7/en ... g-off.html

Re: Avoid creation of "ibdata1"

Posted: Thu 10 Jan 2019 12:49
by rahucha
Thanks VictorV.

But is there any way to skip the creation of "ibdata1"?

Re: Avoid creation of "ibdata1"

Posted: Thu 10 Jan 2019 13:08
by ViktorV
rahucha wrote:
Thu 10 Jan 2019 12:49
Thanks VictorV.

But is there any way to skip the creation of "ibdata1"?
Use MySQL 5.6 and lower. This is the specific behavior of MySQL, not MyDAC, and we cannot influence it in any way.

Re: Avoid creation of "ibdata1"

Posted: Fri 11 Jan 2019 09:47
by rahucha
Thanks VictorV!

Sorry for being so annoying, but is there any way to set a different location for the log files? While having the Database in another location.

Thanks!

Re: Avoid creation of "ibdata1"

Posted: Mon 14 Jan 2019 16:09
by ViktorV
To solve the issue, please try to use the --innodb_log_group_home_dir parameter. For example:

Code: Select all

procedure TfmMain.MyConnectionBeforeConnect(Sender: TObject);
begin
  MyConnection.Params.Text := MyConnection.Params.Text + '--innodb_log_group_home_dir=log';
end;

Re: Avoid creation of "ibdata1"

Posted: Tue 15 Jan 2019 10:19
by rahucha
Thanks a lot! Really appreciated!

Re: Avoid creation of "ibdata1"

Posted: Tue 15 Jan 2019 11:28
by ViktorV
Thank you for the interest to our product.
Feel free to contact us if you have any further questions about our products.