Hosting Provided By

Re: Removed ibdata1

From: Olaf Stein <steino(at)ccri.net>
Date: Fri Aug 24 2007 - 15:27:28 EDT

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

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com

Received on Fri Aug 24 15:29:56 2007

This message: [ Message body ]
Next message: Adriano Ceccarelli: "Re: Removed ibdata1"
Previous message: Stut: "Re: Removed ibdata1"
In reply to: Adriano Ceccarelli: "Removed ibdata1"
Next in thread: Adriano Ceccarelli: "Re: Removed ibdata1"
Reply: Adriano Ceccarelli: "Re: Removed ibdata1"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:07:21 EDT