Avoid creation of "ibdata1"

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
rahucha
Posts: 23
Joined: Tue 18 Nov 2014 09:52

Avoid creation of "ibdata1"

Post by rahucha » Thu 10 Jan 2019 09:22

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
Devart Team
Posts: 2656
Joined: Wed 30 Jul 2014 07:16

Re: Avoid creation of "ibdata1"

Post by ViktorV » Thu 10 Jan 2019 12:18

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
Posts: 23
Joined: Tue 18 Nov 2014 09:52

Re: Avoid creation of "ibdata1"

Post by rahucha » Thu 10 Jan 2019 12:49

Thanks VictorV.

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

ViktorV
Devart Team
Posts: 2656
Joined: Wed 30 Jul 2014 07:16

Re: Avoid creation of "ibdata1"

Post by ViktorV » Thu 10 Jan 2019 13:08

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.

rahucha
Posts: 23
Joined: Tue 18 Nov 2014 09:52

Re: Avoid creation of "ibdata1"

Post by rahucha » Fri 11 Jan 2019 09:47

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
Devart Team
Posts: 2656
Joined: Wed 30 Jul 2014 07:16

Re: Avoid creation of "ibdata1"

Post by ViktorV » Mon 14 Jan 2019 16:09

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
Posts: 23
Joined: Tue 18 Nov 2014 09:52

Re: Avoid creation of "ibdata1"

Post by rahucha » Tue 15 Jan 2019 10:19

Thanks a lot! Really appreciated!

ViktorV
Devart Team
Posts: 2656
Joined: Wed 30 Jul 2014 07:16

Re: Avoid creation of "ibdata1"

Post by ViktorV » Tue 15 Jan 2019 11:28

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

Post Reply