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 > > > 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, "Adriano Ceccarelli" <[EMAIL PROTECTED]> wrote: >> >>> > 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 type innodb >>> > >>> > >>> > # ls -la /var/lib/mysql/intranet/ >>> > list all files .frm OK >>> > >>> > >>> > >>> > thanks >>> > Adriano >> >
