Cluster Backup / Restoration with Disk Data Objects

Hello,

I am trying to restore my cluster data that I've backed up
with
`ndb_mgm -e "start backup"` and the MySQL site
says that if I restart
my ndb node with --initial that it will not remove my table
spaces and
log files from disk, that I have to remove them myself.
http://dev.mysql.com/doc
/refman/5.1/en/mysql-cluster-disk-data-storage-requirements.
html

I have for example created a table space named ts_1 but I
cannot find
a file with the same name as this in my mysql and
mysql-cluster
directories. Where are my table spaces and log files saved?

Secondly, if I deleted my log files and table spaces and
when I
restore my backup would my restoration automatically create
my table
spaces, log files, and associate them with my tables are
they were
previously or do I have to do this manually somehow?

Thank you,
- Jake

-- 
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com
/cluster
To unsubscribe:    http://list
s.mysql.com/cluster?unsub=bondyahoo.com

On Mon, 2007-10-01 at 22:03 -0700, Jake Conk wrote:
> Hello,
> 
> I am trying to restore my cluster data that I've backed
up with
> `ndb_mgm -e "start backup"` and the MySQL
site says that if I restart
> my ndb node with --initial that it will not remove my
table spaces and
> log files from disk, that I have to remove them
myself.
> http://dev.mysql.com/doc
/refman/5.1/en/mysql-cluster-disk-data-storage-requirements.
html
> 
> I have for example created a table space named ts_1 but
I cannot find
> a file with the same name as this in my mysql and
mysql-cluster
> directories. Where are my table spaces and log files
saved?

the datafiles are there in the datadir of the data nodes.
they are not
automatically in a sub-directory of the name of the ts.


> Secondly, if I deleted my log files and table spaces
and when I
> restore my backup would my restoration automatically
create my table
> spaces, log files, and associate them with my tables
are they were
> previously or do I have to do this manually somehow?

yes. the idea of ndb_restore and backup is that you get back
the same
data as you had previously.
-- 
Stewart Smith, Senior Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616sip.us.mysql.com
Mobile: +61 4 3 8844 332

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html