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.
Subject
Views
Written By
Posted
47461
July 13, 2006 08:41PM
11534
July 14, 2006 12:10AM
9312
July 17, 2006 01:34AM
9332
July 17, 2006 04:15PM
14217
July 18, 2006 12:14AM
6366
July 18, 2006 04:38PM
7310
July 18, 2006 07:41PM
5575
July 18, 2006 09:30PM
Re: ERROR 1050 (42S01): Table already exists
9093
July 18, 2006 11:21PM
3884
July 19, 2006 02:10AM
4303
July 19, 2006 02:24AM
5081
July 19, 2006 03:25AM
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.