title: How to Sync mySQL Logs
body: <p>I recently experienced a DDoS attack. It overwhelmed and crashed my server. Upon restart all of the innodb tables were corrupted in every database on the server. </p>
  
  <p>I have since rebuilt the databases and all of the tables. I had to recreate innodb_table_stats, innodb_index_stats.</p>
  
  <p>Everything now seems to be running fine, the website is up but I have one persistent error that keeps coming up. The general log is filling with these quite rapidly.</p>
  
  <p><code>2014-07-13 15:28:37 7fd70b374700 InnoDB: Error: page 193 log sequence number 526819726
  InnoDB: is in the future! Current system log sequence number 156433332.
  InnoDB: Your database may be corrupt or you may have copied the InnoDB
  InnoDB: tablespace but not the InnoDB log files. See
  InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
  InnoDB: for more information.</code></p>
  
  <p>I tried <a href="http://dev.mysql.com/doc/refman/5.5/en/innodb-data-log-reconfiguration.html" rel="nofollow">Changing the Number and Size of mySQL logs</a>. It all went fine with no errors. But I am still seeing these errors mount up in the new log.</p>
  
  <p>What else can I try to sync up these log sequence numbers? I am pretty new to this backend database work. Being forced to learn since my hosts tech support sucks.</p>
  
  <p>I am currently on: CENTOS 6.5 x86_64 virtuozzo – vps- WHM 11.44.0 (build 22)
  mySQL: 5.6.17</p>