MySQL Forums
Forum List  »  InnoDB

Re: Restore data from table (InnoDB)
Posted by: Peter Brawley
Date: March 16, 2017 10:31AM

It is a setting in my.ini. Consult xampp docs for how to read and modify my.ini in your installation. Look up innodb_file_per_table in the manual. It defaulted to Off through version 5.6.5, then On.

Regenerating the log is a longshot. Most likely the data is gone. To prevent more disasters like this, set up daily backups.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Restore data from table (InnoDB)
189
March 16, 2017 10:31AM


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.