Hi,
Is there a way to recover data and/or database schema when ibdata1 file
has been removed (for InnoDB databases) ?
(MySQL 5.0.26)
Thanks
--
Sébastien Moretti
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--001636c5a4afb9131f046ae0ecd9
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
* Undelete the file
* Restore from backup
* Apply the infinite monkey theorem
On Wed, May 27, 2009 at 8:41 AM, Sebastien MORETTI <
sebastien.moretti@unil.ch> wrote:
> Hi,
>
> Is there a way to recover data and/or database schema when ibdata1 file h=
as
> been removed (for InnoDB databases) ?
>
> (MySQL 5.0.26)
> Thanks
>
> --
> S=E9bastien Moretti
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dvegivamp@tuxera.b=
e
>
>
--=20
Celsius is based on water temperature.
Fahrenheit is based on alcohol temperature.
Ergo, Fahrenheit is better than Celsius. QED.
--001636c5a4afb9131f046ae0ecd9--
Hi,
Your data is gone (unless you can undelete it from whatever filesystems =
you're using).
You should be able to recover the schema from the directories and .frm =
files by doing something like this hack:
1. Take a copy of your .frm files and keep them somewhere safe.
2. Create a database with tables of same name as the XXX.frm files. =
Just make the tables with one column and don't put any data in them.=20
3. Stop the mysqld and replace the newly created .frm files with saved =
..frm files
4. Start mysqld and the tables should be replaced with the old ones but =
with no data.
Andrew
-----Original Message-----
From: Sebastien MORETTI [mailto:sebastien.moretti@unil.ch]=20
Sent: 27 May 2009 07:41
To: mysql@lists.mysql.com
Subject: ibdata1 lost
Hi,
Is there a way to recover data and/or database schema when ibdata1 file=20
has been removed (for InnoDB databases) ?
(MySQL 5.0.26)
Thanks
--=20
S=E9bastien Moretti
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dandrew.braithwaite@love film.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
> Hi,
>
> Your data is gone (unless you can undelete it from whatever filesystems you're using).
I think it's too late for this, because the MySQL server has been restarted.
> You should be able to recover the schema from the directories and .frm files by doing something like this hack:
>
> 1. Take a copy of your .frm files and keep them somewhere safe.
> 2. Create a database with tables of same name as the XXX.frm files. Just make the tables with one column and don't put any data in them.
> 3. Stop the mysqld and replace the newly created .frm files with saved .frm files
> 4. Start mysqld and the tables should be replaced with the old ones but with no data.
Thanks for the schema.
But the main problem is the data. The generation process was near
completion when we lost ibdata1 file. So, no dump.
> Andrew
>
> -----Original Message-----
> From: Sebastien MORETTI [mailto:sebastien.moretti@unil.ch]
> Sent: 27 May 2009 07:41
> To: mysql@lists.mysql.com
> Subject: ibdata1 lost
>
> Hi,
>
> Is there a way to recover data and/or database schema when ibdata1 file
> has been removed (for InnoDB databases) ?
>
> (MySQL 5.0.26)
> Thanks
>
--
Sébastien Moretti
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Sebastien,
On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI
>> Hi,
>>
>> Your data is gone (unless you can undelete it from whatever filesystems
>> you're using).
>
> I think it's too late for this, because the MySQL server has been restarted.
You may be able to recover from the file system. So long as you
haven't written lots of data to the file system since the loss the
restart shouldn't matter.
Cheers,
Ewen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
> Sebastien,
>
> On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI
>
>>> Hi,
>>>
>>> Your data is gone (unless you can undelete it from whatever filesystems
>>> you're using).
>> I think it's too late for this, because the MySQL server has been restarted.
>
>
> You may be able to recover from the file system. So long as you
> haven't written lots of data to the file system since the loss the
> restart shouldn't matter.
Do you know how to do this with Linux Suse ?
> Cheers,
>
> Ewen
--
Sébastien Moretti
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Sebastien,
On Wed, May 27, 2009 at 11:35 AM, Sebastien MORETTI
>>> I think it's too late for this, because the MySQL server has been
>>> restarted.
>>
>>
>> You may be able to recover from the file system. So long as you
>> haven't written lots of data to the file system since the loss the
>> restart shouldn't matter.
>
> Do you know how to do this with Linux Suse ?
It will depend on which file system you are using.
I would stop any writes to the file system and either google file
system recovery for your file system or get on the mailing list/irc
channel for your file system.
If you are using ext3 this might help.
http://code.google.com/p/ext3grep/
Ewen
>
>> Cheers,
>>
>> Ewen
>
>
> --
> S=E9bastien Moretti
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
>> Sebastien,
>>
>> On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI
>>
>>>> Hi,
>>>>
>>>> Your data is gone (unless you can undelete it from whatever filesystems
>>>> you're using).
>>> I think it's too late for this, because the MySQL server has been
>>> restarted.
>>
>>
>> You may be able to recover from the file system. So long as you
>> haven't written lots of data to the file system since the loss the
>> restart shouldn't matter.
>
> Do you know how to do this with Linux Suse ?
I have found how to do this.
The ibdata1 file size was 74G.
Maybe the undelete process will fail for such large files
>> Cheers,
>>
>> Ewen
--
Sébastien Moretti
Department of Ecology and Evolution,
Biophore, University of Lausanne,
CH-1015 Lausanne, Switzerland
Tel.: +41 (21) 692 4221/4056
http://bioinfo.unil.ch/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org