Amazium bvba, your online partner
  • Share post with Twitter
  • Share post with StumbleUpon
  • Share post with Delicious
  • Share post with Digg
  • Share post with Technorati
  • Share post with Blinklist
2011-10-26 18:36

Restore MySQL database using binlog

database, dba

Suppose you take hourly backups and you loose data in between backups. You can restore the most recent backup, but you will still miss data... in this article I'll explain how you can use the binlogs to restore what you lost.

  • Share post with Twitter
  • Share post with StumbleUpon
  • Share post with Delicious
  • Share post with Digg
  • Share post with Technorati
  • Share post with Blinklist
2009-04-18 00:10

MySQL : Timestamp

timestamp, data types, database

The TIMESTAMP datatype in MySQL has some nice features which aren't well known. It's a datatype used to store a date-and-time value.