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/
