MySQL Forums
Forum List  »  Backup

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Enterprise Import to One File Per Table
1260
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.