Help about save tables on disk

From: Tarcisio Layme <tlayme(at)msn.com>
Date: Sat Oct 20 2007 - 21:07:00 EDT

I need create and save table and data on hard disk, using Mysql 6.0.22. I do this using this model:  

################################### Basic test of disk tables for NDB# Start by creating a logfile group##################################CREATE LOGFILE GROUP lg1ADD UNDOFILE 'undofile.dat'INITIAL_SIZE 16MUNDO_BUFFER_SIZE = 1MENGINE=NDB;#################################################### Create a tablespace connected to the logfile group###################################################CREATE TABLESPACE ts1ADD DATAFILE 'datafile.dat'USE LOGFILE GROUP lg1INITIAL_SIZE 12MENGINE NDB;######################################### Create a table using this tablespace########################################CREATE TABLE t1(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)TABLESPACE ts1 STORAGE DISKENGINE=NDB;

But when i try open the table they don't show.  

I create logfile and tablespace on one node (SQL node). I must create logfile and tablespace on each storage node?pls help me.

---

Veja mapas e encontre as melhores rotas para fugir do trânsito com o Live Search Maps! http://www.livemaps.com.br/index.aspx?tr=true Received on Sat Oct 20 21:07:15 2007