MySQL Forums :: InnoDB :: Restore data from table (InnoDB)


Advanced Search

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
Restore data from table (InnoDB) 51 Pierre Koehler 03/15/2017 03:11AM
Re: Restore data from table (InnoDB) 25 Peter Brawley 03/15/2017 12:31PM
Re: Restore data from table (InnoDB) 21 Pierre Koehler 03/15/2017 10:24PM
Re: Restore data from table (InnoDB) 21 Peter Brawley 03/16/2017 10:31AM
Re: Restore data from table (InnoDB) 19 Pierre Koehler 03/16/2017 11:04PM


Sorry, only registered users may post in this forum.

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.