[ bogdan.kecman @ 10.07.2014. 16:26 ] @
Bolje da imate i probate pre nego vam zatreba:

https://twindb.com/recover-innodb-table-after-drop-table-innodb/

https://twindb.com/how-to-recover-innodb-dictionary/

https://launchpad.net/undrop-for-innodb

Citat:

TwinDB data recovery toolkit is a set of tools that operate with InnoDB tablespaces at low level.
The toolkit allows to recover data:
* After table was dropped
* If InnoDB tablespace is corrupt so badly so MySQL doesn't start with innodb_force_recovery
* If file system with InnoDB data is corrupt
* If InnoDB files were accidentally deleted
* After records were deleted from table

[ bogdan.kecman @ 10.07.2014. 16:28 ] @
Ovo je najkorisniji 3rd party alat za MySQL koji sam ja ikad video. Svakome ko radi sa MySQL-om predlazem da isproba "odma"!

(naravno nemojte da ga testirate na produkciji :D )
[ farmaceut @ 15.07.2014. 09:52 ] @
Ja sam kao neko alternativno rjesenje postavio dodatnu replikaciju, sa 1h kasnjenja.... (CHANGE MASTER TO MASTER_DELAY = N)
Mislim da je korisna opcija, za "nedaj boze" :)