…_fast_shutdown = 1 3) rename the 2 log files (ib_logfile0 and ib_logfile1) 4) restart mysql I can see the new log… file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 64 MB…: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 130319 0:10…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 17 Comments
…:16 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB…: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 120502 11:51…
Comment: Jeremy Cole on MySQL Replication
March 27, 2007 By 12 Comments
…’t I be able to restore all data (both MyISAM and all committed InnoDB transactions) by just restoring the last full database backup…? If so, why do I need the InnoDB logs, ib_logfile0 and ib_logfile1? Is there a way to disable them so they…
