Avoid creation of "ibdata1"

[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!

[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

[rahucha]

Thanks VictorV.

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

[ViktorV]

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.

[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!

[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;

[rahucha]

Thanks a lot! Really appreciated!

[ViktorV]

Thank you for the interest to our product.
Feel free to contact us if you have any further questions about our products.