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...
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
> --
> Andrew Hutchings, MySQL Senior Technical Support Engineer, Americas
> Oracle Corporation UK Limited.
> http://www.mysql.com/
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
> http://lists.mysql.com/cluster?unsub=1
>
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
> http://lists.mysql.com/cluster?unsub=1
>
>
--
Cordialement __Django__
