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