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

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/

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@gmail.com> 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

It's problem. I don't have dump data :-S


2007/8/24, Olaf Stein <steino@ccri.net>:
>
> 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@gmail.com> 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
>
>

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@gmail.com> wrote:

> It's problem. I don't have dump data :-S
>
>
> 2007/8/24, Olaf Stein <steino@ccri.net>:
>> 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@gmail.com> 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
>>
>

humm... I'm use ext3... I'm see tool and try recover

tks


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

thanks for .. mas no success..

2007/8/24, Stut <stuttle@gmail.com>:
>
> 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/
>