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 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 > > >