Re: MySQL Enterprise Import to One File Per Table
Posted by:
Rick James
Date: August 23, 2015 05:57PM
SET innodb_file_per_table = ON;
before executing the CREATE TABLE in the .sql.
If the table already exists (and if it won't be DELETEd & CREATEd by the .sql), the do the SET, plus
ALTER TABLE foo ENGINE=InnoDB;
to get it to convert to file_per_table.
Subject
Views
Written By
Posted
1956
August 21, 2015 07:03AM
Re: MySQL Enterprise Import to One File Per Table
1309
August 23, 2015 05:57PM
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.