I have a innodb table i need to recover some rows from it, that have been deleted. After deletion the mysql server was shut down so the deleted data isnt lost.
I know it can be recovered using this method:
[login to view URL]
But i am opened to other methods.
I attached the idb file, also the structure is:
-- ----------------------------
-- Table structure for items
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
`UniqueId` int(8) NOT NULL AUTO_INCREMENT,
`StaticId` int(8) NOT NULL,
`Owner` int(8) NOT NULL,
`Amount` int(8) NOT NULL,
`Durability` int(8) NOT NULL,
`Location` int(8) NOT NULL DEFAULT '0',
`Color` tinyint(2) unsigned NOT NULL DEFAULT '4',
`Plus` tinyint(2) unsigned NOT NULL,
`Bless` tinyint(2) unsigned NOT NULL,
`Enchant` tinyint(2) unsigned NOT NULL,
`Gem1` smallint(6) NOT NULL,
`Gem2` smallint(6) NOT NULL,
`Effect` smallint(3) NOT NULL DEFAULT '0',
`Locked` tinyint(2) unsigned NOT NULL DEFAULT '0',
`Flag` tinyint(2) unsigned NOT NULL DEFAULT '0',
`ForgeLevel` int(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`UniqueId`),
UNIQUE KEY `UID` (`UniqueId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=457970 DEFAULT CHARSET=latin1;
I need this ASAP.
Hi there,
I have 9+ years of experience in PHP/MySql and Linux with 440+ reviews on freelancer.
I have worked on similar projects earlier.
I can restore your deleted rows from the innodb.
Looking forward to work for you.
Best Regards,
Syed