innodb UNDROP table

Odgovori Nova tema

2 odgovora
2.496 pregleda

innodb UNDROP table 10.07.2014. u 17:26 · pre 149 meseci #1

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

Potpis

arhimed
http://www.mysql.rs/ | http://elco.crsndoo.com/

Re: innodb UNDROP table 10.07.2014. u 17:28 · pre 149 meseci #2

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 )

Potpis

arhimed
http://www.mysql.rs/ | http://elco.crsndoo.com/

Re: innodb UNDROP table 15.07.2014. u 10:52 · pre 149 meseci #3

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" :)

Prijavite se da biste odgovorili u ovoj temi.Prijava Registracija

Forum kao aplikacija na telefonu

Srodne teme