Hi Geert,
First i ran the command you suggest :
mysql> CREATE TABLE t1 (id INT NOT NULL KEY) ENGINE=NDB;
ERROR 1046 (3D000): No database selected
mysql> SHOW WARNINGS;
+-------+------+----------------------+
| Level | Code | Message |
+-------+------+----------------------+
| Error | 1046 | No database selected |
+-------+------+----------------------+
1 row in set (0.00 sec)
Then i thought maybe i should use the database i want to import the mysql
file into
mysql> CREATE TABLE test1 (id INT NOT NULL KEY) ENGINE=NDB;
ERROR 1046 (3D000): No database selected
mysql> SHOW WARNINGS;
+-------+------+----------------------+
| Level | Code | Message |
+-------+------+----------------------+
| Error | 1046 | No database selected |
+-------+------+----------------------+
1 row in set (0.00 sec)
Then i did the following :
mysql> use test1
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> CREATE TABLE t1 (id INT NOT NULL KEY) ENGINE=NDB;
Query OK, 0 rows affected (0.91 sec)
mysql> SHOW WARNINGS;
Empty set (0.00 sec)
Thanks,
Sarang
On Fri, Nov 20, 2009 at 1:32 PM, Geert Vanderkelen <
Geert.Vanderkelen@stripped> wrote:
>
> On Nov 20, 2009, at 08:51 , lonetwin wrote:
> ..
> > # mysql -uroot -ppass test < backup.sql
> >
> > This operation starts and give error after a while saying :
> > ERROR 1005 (HY000) at line 3853: Can't create table test.location (errno
> > 136)
>
> mysql> CREATE TABLE t1 (id INT NOT NULL KEY) ENGINE=NDB;
> mysql> SHOW WARNINGS;
>
> What it says?
>
> Cheers,
>
> Geert
>
> --
> Geert Vanderkelen, MySQL Senior Support Engineer
> Sun Microsystems GmbH Sonnenallee 1, D-85551 Kirchheim-Heimstetten
>
> Geschaeftsfuehrer: Thomas Schröder, Wolfgang Engels, Wolf Frenkel
> Vorsitz d. Aufs.rat.: Martin Haering HRB MUC 161028
>
>
>
>
