List:General Discussion« Previous MessageNext Message »
From:Adriano Ceccarelli Date:August 24 2007 8:05pm
Subject:Re: Removed ibdata1
View as plain text  
thanks for help.. mas no success..

2007/8/24, Stut <stuttle@stripped>:
>
> 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
> > this erro in all tables type innodb
> >
> >
> > # ls -la /var/lib/mysql/intranet/
> > list all files .frm OK
>
> I'm no expert, but I believe the data in InnoDB tables is stored in
> ibdata1. Game over I'm afraid.
>
> -Stut
>
> --
> http://stut.net/
>

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