Hi. I just found this software and it seems almost perfect for my needs. I'd prefer using MySQL instead of sqlite, but have problem importing the shema file. I red on the ML archive and in the README file that the schema should work also with MySQL, but I couldn't find how. Even after removing the first two lines (PRAGMA, BEGIN TRANSATION) and the last on (COMMIT) which are AFAIK sqlite specific, mysql still complains:
mysql dl < include/scripts/sqlite.sql ERROR 1064 (42000) at line 3: 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 'PRIMARY KEY, value VARCHAR)' at line 1 I've found a few scripts supposed to convert sqlite to mysql dumps, but they are not very clean, and I still have the same kind of errors. Anybody managed to import the schema file in MySQL ? (I'm using mysql 5.0.95 on CentOS 5) Regards, Daniel -- Daniel Berteaud FIREWALL-SERVICES SARL. Société de Services en Logiciels Libres Technopôle Montesquieu 33650 MARTILLAC Tel : 05 56 64 15 32 Fax : 05 56 64 15 32 Web : http://www.firewall-services.com
