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
