Avoid creation of "ibdata1"
Avoid creation of "ibdata1"
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!
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"
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"
Thanks VictorV.
But is there any way to skip the creation of "ibdata1"?
But is there any way to skip the creation of "ibdata1"?
Re: Avoid creation of "ibdata1"
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!
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"
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"
Thanks a lot! Really appreciated!
Re: Avoid creation of "ibdata1"
Thank you for the interest to our product.
Feel free to contact us if you have any further questions about our products.
Feel free to contact us if you have any further questions about our products.