MySQL Forums
Forum List  »  Newbie

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?

Options: ReplyQuote


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.