| 362 | | sqlite> select * from ticket; |
| 363 | | 1|1092797666|1094723786|component1|normal|normal|Martin|someone@somewhere.com|||||reopened||test|testing| |
| 364 | | sqlite> select * from ticket_change; |
| 365 | | 1|1092798124|leigh|comment||Testing notification |
| 366 | | 1|1092798319|leigh|owner|somebody|Leigh |
| 367 | | ... |
| 368 | | ... |
| 369 | | |
| 370 | | |
| 371 | | It should be possible to take this output , and produce a script that would insert records into the ticket and ticket_change tables in the new trac installation. |
| | 362 | sqlite> .output ticket.sql |
| | 363 | sqlite> .dump ticket |
| | 364 | |
| | 365 | |
| | 366 | Outputs the table, both the schema and the data, into the file ticket.sql. You can then in import this file into your new installation |
| | 367 | by doing something like sqlite < ticket.sql. |
| | 368 | You will need to either drop the ticket table in your new installation or remove the "create table" statement out of the ticket.sql file. |
