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.


arrow
arrow
    全站熱搜

    Bluelove1968 發表在 痞客邦 留言(0) 人氣()