MySQL Forums
Forum List  »  Backup

dump isn't restoring
Posted by: Reed O'Brien
Date: February 24, 2005 11:31AM

exporting mysqldump Ver 8.13 Distrib 3.23.36, for pc-linux-gnu (i686)
importing mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

@glaum robrien]# mysql surveys </home/robrien/dbbak/surveys.sql

[error message]
ERROR 1064 at line 57: You have an error in your SQL syntax near 'group enum('N','Y') default 'N',
PRIMARY KEY (surveyq_id),
UNIQUE KEY surve' at line 7
[/error message]

CREATE TABLE bug_public_surveyq (
  surveyq_id int(11) NOT NULL auto_increment,
  surveyq_surveyid int(11) NOT NULL default '0',
  surveyq_timestamp datetime NOT NULL default '0000-00-00 00:00:00',
  surveyq_name text,
  surveyq_type enum('radio','checkbox','text','textarea','dropdown') default 'radio',
  group enum('N','Y') default 'N',
  PRIMARY KEY  (surveyq_id),
  UNIQUE KEY surveyq_id (surveyq_id)

Options: ReplyQuote

Written By
dump isn't restoring
February 24, 2005 11:31AM
February 25, 2005 08:53AM

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.