> > hi. I'm trying to migrate request-tracker3.6 database from sqlite > to mysql on lenny. Is there a way to export data from sqlite > so they can be imported into mysql for request-tracker3.6? > ....
martin .... One way might be to export from sqlite as .csv files and then import into mysql .... Following is an example sqlite session for the export of two tables that comprise a simple data base .... $ sqlite3 abook.sql3 SQLite version 3.5.9 Enter ".help" for instructions sqlite> sqlite> .tables addr names sqlite> sqlite> .mode csv sqlite> sqlite> .output addr.csv sqlite> select * from addr ; sqlite> sqlite> .output names.csv sqlite> select * from names ; sqlite> sqlite> .quit -- Stanley C. Kitching Human Being Phoenix, Arizona -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org