Ticket Backup in manual
<<< backup steps >>>
1.) Export the database file which you would import from.
# sqlite3 trac.db (eg. from WN111v2's database)
sqlite>.mode column
sqlite>.separator |
sqlite>.output '''WN111v2_file_ticketDB.txt'''
sqlite>select * from ticket;
sqlite>.exit
2.) Import the WN111v2_file_ticketDB.txt to Netgear_UB8x's database.
# sqlite3 trac.db (eg. from Netgear_UB8x's database)
sqlite> .mode column
sqlite> .separator |
sqlite> .import '''''WN111v2_file_ticketDB.txt''''' '''ticket'''
sqlite> select * from ticket;
Note: WN111v2_file_ticketDB.txt should be remove the "\r\n" from each value (row) between fields(columns) of ticket table.
全站熱搜