i accidentaly “emptied” a table with approx 360 entries.
After adding “chatname varchar(30)”, i executed “alter ignore add unique(chatname)” on the “users” table, resulting only 1 row left.
After this i got a bit angry, and truncated all tables in the database :S
Is there any way this database can be recovered? This database is innodb. What tool should i use?
Also i am having some difficulties compiling the percona tools. I use “./configure” inside mysql-source/, then i do a “make” 1 directory below, and get the error “/usr/bin/ld: cannot find -lrt”
Above problem is solved, -lrt on centos is provided by “yum install glibc-static”
The 1 percone tool i did manage to use gave me an error like “does not support point”