List:General Discussion« Previous MessageNext Message »
From:Adriano Ceccarelli Date:August 24 2007 9:56pm
Subject:Re: Removed ibdata1
View as plain text  
humm... I'm use ext3...  I'm see tool and try recover

tks


2007/8/24, Olaf Stein <steino@stripped>:
>
> 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" <aceccarelli@stripped> wrote:
>
>  It's problem. I don't have dump data  :-S
>
>
> 2007/8/24, Olaf Stein <steino@stripped>:
>
> 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" <aceccarelli@stripped> 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
>
>
>

Thread
Removed ibdata1Adriano Ceccarelli24 Aug
  • Re: Removed ibdata1Stut24 Aug
    • Re: Removed ibdata1Adriano Ceccarelli24 Aug
  • Re: Removed ibdata1Olaf Stein24 Aug
    • Re: Removed ibdata1Adriano Ceccarelli24 Aug
      • Re: Removed ibdata1Olaf Stein24 Aug
        • Re: Removed ibdata1Adriano Ceccarelli24 Aug