Hello
I have two MySQL 4.1 servers installed. One at home
and at my work. Both run WinXP.
I used mysqldump to export my database at work and
tried to import it at my home server, I am getting the
following error in one of the - create table
defintaion
Error Code : 1064
You have an error in your SQL syntax near
'CHARSET=latin1 ROW_FORMAT=DYNAMIC
COMMENT='Inneholder abonnementdata'' at line 38
(113 ms taken)
The create table query is as follows
CREATE TABLE `abonnenter` (
`id` int(11) NOT NULL auto_increment,
`navn` varchar(100) NOT NULL default '',
`abonr` varchar(20) NOT NULL default '',
`adresse` varchar(50) NOT NULL default '0',
`post` varchar(50) NOT NULL default '0',
`telefon` varchar(20) default NULL,
`telefax` varchar(20) default NULL,
`epost` varchar(100) default NULL,
`web` varchar(50) default NULL,
`kp_navn` varchar(50) NOT NULL default '',
`kp_telefon` varchar(20) NOT NULL default '',
`kp_epost` varchar(50) default '',
`abbtype` varchar(10) NOT NULL default '0',
`tdato` date NOT NULL default '0000-00-00',
`kresp` enum('J','N') NOT NULL default 'N',
`passord` varchar(20) binary NOT NULL default '',
`sdato` datetime NOT NULL default '0000-00-00
00:00:00',
`sist_innlogget` datetime NOT NULL default
'0000-00-00 00:00:00',
`kandidat_brukernavn` varchar(30) default NULL,
`skifte_passord` enum('TRUE','FALSE') NOT NULL
default 'FALSE',
`po_spm` varchar(100) NOT NULL default '',
`po_svar` varchar(100) NOT NULL default '',
`visinfo` enum('TRUE','FALSE') NOT NULL default
'TRUE',
`regdato` datetime NOT NULL default '0000-00-00
00:00:00',
`selgernr` varchar(30) NOT NULL default '',
`status` varchar(30) NOT NULL default 'Aktiv',
PRIMARY KEY (`id`,`abonr`),
UNIQUE KEY `abonr` (`abonr`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `abonr_index` (`abonr`),
UNIQUE KEY `kandidat_brukernavn_index`
(`kandidat_brukernavn`(10)),
KEY `id_2` (`id`),
FULLTEXT KEY `navn` (`navn`),
FULLTEXT KEY `navn_2` (`navn`),
FULLTEXT KEY `navn_3` (`navn`)
) TYPE=MyISAM CHARSET=latin1 ROW_FORMAT=DYNAMIC
COMMENT='Inneholder abonnementdata';
When I try to exeucte it at my work office, everything
works fine?
Why the anomaly? Is my home MySQL configuration
missing something?
Even this query is returning me error -
CREATE TABLE `aboutvidelser` (
`id` int(11) unsigned NOT NULL auto_increment,
`abonr` varchar(20) character set latin1 NOT NULL
default '0',
`udato` datetime NOT NULL default '0000-00-00
00:00:00',
`abotype` char(1) character set latin1 NOT NULL
default 'O',
`antall` smallint(5) unsigned NOT NULL default '0',
`selgerid` int(11) unsigned NOT NULL default '0',
`stat` enum('aktiv','slettet') character set latin1
NOT NULL default 'aktiv',
`slettetdato` datetime NOT NULL default '0000-00-00
00:00:00',
PRIMARY KEY (`id`),
KEY `abonr_index` (`abonr`),
KEY `selgerid_index` (`selgerid`)
) TYPE=MyISAM;
The error returned for the above case is -
You have an error in your SQL syntax near 'character
set latin1 NOT NULL
default '0',
`udato` datetime NOT NULL default '' at line 4
Thanks in advance.
Karam
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
