Hello Ismael,
On Jul 21, 2010, at 2:29 , ismael Django wrote:
> Thanks for answers.
> What I currently have is the node just after --initial command.
> Unfortunately, I have no binlogs.
> So my database directories are empty (no frm and ndb files).
> The ndb_#_fs directory have few LCP files (probably got just after the
> nodes initialisation but i'm not sure) but the D# directories contains huge
> file that could have the data.
> Is there any procedure to retrieve lost data and at least perform a SQL dump
> of the database? If yes I would like to know how...
No, if you did --initial on both data nodes, it did remove all files after which they will
be recreated when the data node starts.
As Andrew mentioned, if you don't have a backup of previous ndb_*_fs/ directories, or no
binary logs, I'm afraid your data is lost.
What tool you used btw?
-Geert
> 2010/7/20 Joshua Gordon <jgordon@stripped>
>
>> You need to backup everything you currently have redo ndbfs ect. If you
>> have bin logs back them up also.
>>
>> ----- Original Message -----
>> From: Andrew Hutchings <andrew.hutchings@stripped>
>> To: cluster@stripped <cluster@stripped>
>> Sent: Tue Jul 20 14:07:56 2010
>> Subject: Re: Is it possible to Restore after a --initial performed?
>>
>> Hello Ismael,
>>
>> On 20/07/10 20:57, ismael Django wrote:
>>> I would like to know if it's possible to use LCP and Redo Log files to
>>> restore a MySQL cluster data.
>>> I use a tool that execute the command across my node so when I performed
>>> --initial (instead of nothing) it retart all my nodes and I lost all my
>>> data.
>>> Like my last backup is very old, i would kie to know if there is any
>> chance
>>> to have my data back.
>>
>> If you have a backup of the LCP and Redo (as well as the rest of the
>> ndbfs) then theoretically you should be able to start the data node
>> using this by replacing the ndbfs. If you mean the LCP and Redo
>> currently in the ndbfs that will be blank, nothing possible to restore
>> in there.
>>
>> Kind Regards
--
Geert Vanderkelen
Oracle, MySQL Principal Support Engineer
ORACLE Deutschland B.V.& Co. KG
Registered Office: Riesstr. 25, 80992 Muenchen, Germany
Commercial Register: Local Court Of Munich, HRA 95603
General Partner: ORACLE Deutschland Verwaltung B.V.
Rijnzathe 6, 3454PV De Meern, Niederlande
Register Of Chamber Of Commerce: Midden-Niederlande, No. 30143697
Managing Directors: Juergen Kunz, Marcel van de Molen, Alexander van der Ven
