MySQL Forums
Forum List  »  NDB clusters

Re: ERROR 1050 (42S01): Table already exists
Posted by: Han Chee
Date: July 18, 2006 11:21PM

Yes. I have tried using --initial when starting up my ndbd

Below is the command I have used to one NDB node:

###########################################################

mysql> CREATE DATABASE TESTDB;
Query OK, 1 row affected (0.00 sec)

mysql> USE TESTDB;
Database changed
mysql> CREATE TABLE `TABLE1` (`NO` INT(11)) ENGINE = NDBCLUSTER;
Query OK, 0 rows affected, 1 warning (0.02 sec)

mysql> SHOW WARNINGS;
+---------+------+------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------+
| Warning | 1266 | Using storage engine MyISAM for table 'TABLE1' |
+---------+------+------------------------------------------------+
1 row in set (0.00 sec)

mysql> ALTER TABLE `TABLE1` ENGINE = NDBCLUSTER;
Query OK, 0 rows affected, 1 warning (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> SHOW WARNINGS;
+---------+------+------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------+
| Warning | 1266 | Using storage engine MyISAM for table 'TABLE1' |
+---------+------+------------------------------------------------+
1 row in set (0.00 sec)

###########################################################

I still not able to alter the table engine to NDBCLUSTER after I have successfully CREATE the table.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 1050 (42S01): Table already exists
9093
July 18, 2006 11:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.