Thread: (urgent) Problems to import a dump generated from dolphin

Hello, i have been trying to upgrade from dolphin 6.0 to 6.1 without any luck.
Im looking to revert back the situation and put my previous my old version back up but im having the following error:

# mysql -uuser -ppass --database dolphindb < 2008-05-14_09-17-38_all.sql

ERROR 1064 (42000) at line 11: 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 'INSERT INTO `AccountCompose` VALUES (1, 'My Photos', 'my_photos', '_My Photos', ' at line 14

----
I do not understand what is happening. I tried upgrading mysql4 to mysql5 today but im still receiving this error.

This are the first lines of the sql dump:

Code:

--
-- Database Dump For Dolphin: 6.0
--


--
-- Table structure for table `AccountCompose`
--

DROP TABLE IF EXISTS `AccountCompose`;
CREATE TABLE `AccountCompose` (
  `ID` int(8) unsigned NOT NULL auto_increment,
  `Title` varchar(255) NOT NULL default '',
  `Div` varchar(255) NOT NULL default '',
  `Caption` varchar(255) NOT NULL default '',
  `Desc` varchar(255) NOT NULL default '',
  `Func` varchar(40) NOT NULL default '',
  `Content` text NOT NULL,
  `Visible` set('non','memb') NOT NULL default '',
  `Column` int(11) NOT NULL default '0',
  `Order` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM
--
-- Dumping data for table `AccountCompose`
--

INSERT INTO `AccountCompose` VALUES ('1', 'My Photos', 'my_photos', '_My Photos', '', 'MyPhotos', '', '', '1', '0');
INSERT INTO `AccountCompose` VALUES ('2', 'Site Stats', 'member_stat', '_Site Stats', '', 'MembersStats', '', '', '1', '1');
INSERT INTO `AccountCompose` VALUES ('3', 'Member Info', 'member_info', '_member info', '', 'MemberInfo', '', '', '2', '0');
INSERT INTO `AccountCompose` VALUES ('4', 'Contacts', 'contacts', '_contacts', '', 'Contacts', '', '', '2', '1');

Please advice.

Thank you.

Looks like if i manually copy the first lines on mysql it does not show any error. This is pretty odd.

Does anyone experienced this?

I simply added a ";" on every line after ) TYPE=MyISAM
and it works now.

Thanks.

How did you / where from - did you do your backup - it is strange that it would do it in a way that was not importable without editing.

????

Smoge