Re: how to migrate request-tracker database from sqlite3 to mysql
>
> 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
Reply to: