List:General Discussion« Previous MessageNext Message »
From:Stut Date:August 24 2007 7:24pm
Subject:Re: Removed ibdata1
View as plain text  
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