sqlite to mysql_sympa sqlite to mysql

mysql> show engines;

mysql> show create table etidmap_table;

mysql> show variables like 'character_set%' ;

/etc/my.cnf

chkconfig --add mysqld

mysql < /home/sympa/bin/create_db.mysql

set db_user and db_passwd in sympa.conf

sqlite3 /sympa/sympa.db ".dump" > sqlite.sql

Migration from SQLite to MySQL - How to export a SQLite database???

http://sqlite.phxsoftware.com/forums/p/941/4725.aspx

Convert SQLite to MySQL Database (With Pictures!)

http://otland.net/f137/convert-sqlite-m ... res-47742/

- Replace " (double-quotes) with ` (grave accent)

- Remove "BEGIN TRANSACTION;" "COMMIT;", and lines related to "sqlite_sequence"

- Replace "autoincrement" with "auto_increment"

In addition you should replace the following too in case you have boolean columns with default values:

- DEFAULT 't' -> DEFAULT '1'

- DEFAULT 'f' -> DEFAULT '0'

'mail', NULL, NULL, NULL, NULL, NULL, 1, 0, NULL)

mysql -u root sympa < sqlite.sql