Hi there, I am trying to migrate an existing Trac database from sourceforge to a personal one. I used the backup utility from sf.net to backup the table. It generates an SQL file. I tried then importing that SQL base using sqlite3. But it fails with (*).
The particular line it is failing on is: SET @saved_cs_client = @@character_set_client; The whole SQL statement is: ... -- -- Table structure for table `attachment` -- DROP TABLE IF EXISTS `attachment`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `attachment` ( `type` varchar(64) collate utf8_bin NOT NULL, `id` varchar(111) collate utf8_bin NOT NULL, `filename` varchar(111) collate utf8_bin NOT NULL, `size` int(11) default NULL, `time` int(11) default NULL, `description` text collate utf8_bin, `author` varchar(32) collate utf8_bin default NULL, `ipnr` varchar(32) collate utf8_bin default NULL, PRIMARY KEY (`type`,`id`,`filename`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET character_set_client = @saved_cs_client; ... Has anyone tried migrating a Trac using MySQL to a Trac using sqlite3 ? Thanks -Mathieu (*) $ cat csmtk_trac_mysqldump.sql | sqlite3 trac.db Error: near line 23: near "SET": syntax error Error: near line 24: near "SET": syntax error Error: near line 25: no such collation sequence: utf8_bin Error: near line 36: near "SET": syntax error Error: near line 42: near "LOCK": syntax error Error: near line 44: near ",": syntax error Error: near line 46: near "UNLOCK": syntax error Error: near line 53: near "SET": syntax error Error: near line 54: near "SET": syntax error Error: near line 55: no such collation sequence: utf8_bin Error: near line 62: near "SET": syntax error Error: near line 68: near "LOCK": syntax error Error: near line 71: near "UNLOCK": syntax error Error: near line 78: near "SET": syntax error Error: near line 79: near "SET": syntax error Error: near line 80: no such collation sequence: utf8_bin Error: near line 86: near "SET": syntax error Error: near line 92: near "LOCK": syntax error Error: near line 94: near ",": syntax error Error: near line 96: near "UNLOCK": syntax error Error: near line 103: near "SET": syntax error Error: near line 104: near "SET": syntax error Error: near line 105: no such collation sequence: utf8_bin Error: near line 111: near "SET": syntax error Error: near line 117: near "LOCK": syntax error Error: near line 119: near ",": syntax error Error: near line 121: near "UNLOCK": syntax error Error: near line 128: near "SET": syntax error Error: near line 129: near "SET": syntax error Error: near line 130: no such collation sequence: utf8_bin Error: near line 137: near "SET": syntax error Error: near line 143: near "LOCK": syntax error Error: near line 145: near ",": syntax error Error: near line 370: near "UNLOCK": syntax error Error: near line 377: near "SET": syntax error Error: near line 378: near "SET": syntax error Error: near line 379: no such collation sequence: utf8_bin Error: near line 390: near "SET": syntax error Error: near line 396: near "LOCK": syntax error Error: near line 398: near ",": syntax error Error: near line 400: near "UNLOCK": syntax error Error: near line 407: near "SET": syntax error Error: near line 408: near "SET": syntax error Error: near line 409: no such collation sequence: utf8_bin Error: near line 415: near "SET": syntax error Error: near line 421: near "LOCK": syntax error Error: near line 424: near "UNLOCK": syntax error Error: near line 431: near "SET": syntax error Error: near line 432: near "SET": syntax error Error: near line 433: no such collation sequence: utf8_bin Error: near line 439: near "SET": syntax error Error: near line 445: near "LOCK": syntax error Error: near line 447: near ",": syntax error Error: near line 449: near "UNLOCK": syntax error Error: near line 456: near "SET": syntax error Error: near line 457: near "SET": syntax error Error: near line 458: no such collation sequence: utf8_bin Error: near line 470: near "SET": syntax error Error: near line 476: near "LOCK": syntax error Error: near line 478: near "s": syntax error Error: near line 480: near "UNLOCK": syntax error -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
