I am trying to move a database to a new machine
Posted by:
nikos k
Date: May 01, 2005 05:55AM
Hello, I am trying to move a database to another machine. I use mysqldumb to create a file with
CREATE TABLE statements and
cat filename | mysql db_name
to run the statements to the new machine
However at the table:
CREATE TABLE loginout (
idLog mediumint(9) unsigned NOT NULL auto_increment,
id_user mediumint(9) unsigned NOT NULL default '0',
ip char(16) NOT NULL default '0.0.0.0',
when datetime NOT NULL default '0000-00-00 00:00:00',
action enum('LOGIN','LOGOUT') NOT NULL default 'LOGIN',
PRIMARY KEY (idLog)
) TYPE=MyISAM;
Everytime mysql pops me the following error:
ERROR 1064 (42000) at line 195: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'when datetime NOT NULL default '0000-00-00 00:00:00',
action enum('LOGIN','LO' at line 5
DO you have any idea what can be wrong? SInce mysqldumb created the CREATE TABLE statement isn't it supposed to run smoothly?
Subject
Written By
Posted
I am trying to move a database to a new machine
May 01, 2005 05:55AM
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.