[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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> .tables
addr   names
sqlite> .mode csv
sqlite> .output addr.csv
sqlite> select * from addr ;
sqlite> .output names.csv
sqlite> select * from names ;
sqlite> .quit

Stanley C. Kitching
Human Being
Phoenix, Arizona

Reply to: