RE: migrating existing database to mysql cluster - Scott Campbell - com.mysql.lists.cluster

7 messages in com.mysql.lists.clusterRE: migrating existing database to my...

From	Sent On	Attachments
VIJU PADMAN	10 Jan 2005 06:40
Scott Campbell	12 Jan 2005 08:21
Thomas Bader	12 Jan 2005 08:28
jon stuart	12 Jan 2005 08:41
Scott Campbell	12 Jan 2005 08:44
Mikael Ronström	12 Jan 2005 09:26
Jonas Oreland	12 Jan 2005 09:54

Subject:	RE: migrating existing database to mysql cluster
From:	Scott Campbell (SCam...@qcomm.com)
Date:	01/12/2005 08:44:45 AM
List:	com.mysql.lists.cluster

-----Original Message----- From: Thomas Bader [mailto:thom...@trash.net] Sent: Wednesday, January 12, 2005 9:29 AM To: clus...@lists.mysql.com Subject: Re: migrating existing database to mysql cluster

On 10.01.2005, 15:40, VIJU PADMAN wrote:

2) Lets says that I have a existing database that is not part of the cluster. How do I migrate this database into the MYSQL cluster ?

You need to create the database on all API nodes. Then you can change each's table engine to NDB:

ALTER TABLE sometable ENGINE=NDB;

Did you do this with an existing data set in the database? I have a lot of data that I need to migrate to the cluster from an existing MyISAM structure and I am trying to find the best way to do that. So far I have been dumping the raw files into the data directory and then trying to alter them. Maybe I have that all wrong..., but the docs don't seem to cover doing anything more than creating new databases and starting from scratch.

I have been attempting a similar statement: ALTER TABLE sometable ENGINE=NDBCLUSTER; However, a SHOW TABLE STATUS still lists the table type as MyISAM, where a newly create table is shown as TYPE=ndbcluster;

Is there a difference between NDB and NDBCLUSTER as an ENGINE type?

Regards, Scott

This worked for me.