Removed ibdata1

Hi, I removed accidentaly the files : /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile1 how can I remover them from data files note show tables list all tables OK desc wiki_text ERROR 1146 (42S02): Table 'intranet.wiki_text' doesn't exist this erro in all tables

Re: Removed ibdata1

If you use default configuration (meaning all innodb data in one idata file) you just deleted your data. If you have a recent dump, drop all innodb tables and use the dump to restore On 8/24/07 3:20 PM, Adriano Ceccarelli [EMAIL PROTECTED] wrote: Hi, I removed accidentaly the files :

Re: Removed ibdata1

Adriano Ceccarelli wrote: I removed accidentaly the files : /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile1 how can I remover them from data files note show tables list all tables OK desc wiki_text ERROR 1146 (42S02): Table 'intranet.wiki_text' doesn't exist

Re: Removed ibdata1

It's problem. I don't have dump data :-S 2007/8/24, Olaf Stein [EMAIL PROTECTED]: If you use default configuration (meaning all innodb data in one idata file) you just deleted your data. If you have a recent dump, drop all innodb tables and use the dump to restore On 8/24/07 3:20 PM,

Re: Removed ibdata1

Then see if you can recover the deleted files from your filesystem I think there is a tool called e2undel for ext2 filesystems, not sure how easy this is on journaling fs olaf On 8/24/07 3:41 PM, Adriano Ceccarelli [EMAIL PROTECTED] wrote: It's problem. I don't have dump data :-S

Re: Removed ibdata1

humm... I'm use ext3... I'm see tool and try recover tks 2007/8/24, Olaf Stein [EMAIL PROTECTED]: Then see if you can recover the deleted files from your filesystem I think there is a tool called e2undel for ext2 filesystems, not sure how easy this is on journaling fs olaf On 8/24/07

Re: Removed ibdata1

thanks for help.. mas no success.. 2007/8/24, Stut [EMAIL PROTECTED]: Adriano Ceccarelli wrote: I removed accidentaly the files : /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile1 how can I remover them from data files note show tables list all