From: Johan Andersson
Date: October 20 2010 8:11pm
Subject: Re: All tables remove on ndbd --initial
List-Archive: http://lists.mysql.com/cluster/7848
Message-Id: <89959096-94BE-40E2-9E99-4B3964804F3F@severalnines.com>
MIME-Version: 1.0 (Apple Message framework v1081)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

Hi Umar,
If you start _all_ data nodes with --initial  then you remove the redo =
log files and checkpointing information.
This is called an 'initial system restart', and all of your data is =
gone.

The only way to recover from this is by restoring a backup.

You should always issue a ' ndb_mgm -e "start backup"  '  before you do =
config changes.

Best regards,
johan andersson=20
johanandersson.blogspot.com


20 okt 2010 kl. 22.05 skrev David Ennis:

> Sorry.
>=20
> Misread part of the message and replied too quickly.
>=20
> As for getting your data back - it should get recovered from the other =
nodes - unless you did the same step to each node.?
>=20
> However, there should be a backup as well..
> Each node has its own backup.  Luckily, the --initial does *not* =
remove these.
> The location is defined using BackupDataDir directive
>=20
> Regards and sorry for the 2nd reply.. Should have read  more =
carefully.
>=20
>=20
> -David
>=20
>=20
> On 20/10/10 20:31, Tears ! wrote:
>> Dear All,
>>=20
>> For some reason I had changed config.ini on management node.
>>=20
>> After that I had kill (ndbd) on both storage nodes. And then again =
start
>> ndbd with ndbd --initial.
>>=20
>> But when I had checked tables in my database there was nothing , all =
tables
>> were removed
>>=20
>> Would you please help me how I can recover my old tables.
>>=20
>> And what is the correct procedure to change config.ini and load =
again.
>>=20
>> Regards,
>>=20
>> Umar
>>=20
>=20
> --=20
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:    =
http://lists.mysql.com/cluster?unsub=3Djohan@stripped
>=20