Reposting as earlier post seemed to disappear...
On 16 Nov 2011, at 09:34, umapathi b wrote:
> I am not able to even recover with the option ..innodb_force_recovery=4.
> I don't even have the backup of the data ..
> How can I recover ..the data ..? atleast the old data ...
This might help: http://raphaelhahn.com/2009/08/innodb-caused-mysql-to-crash/
If it's really important and you've got the cash, talk to Percona.
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/