如何備份與還原sqlite資料庫

標籤：

Backing up the database

To make a backup copy of the database, simply do a "dump" and redirect the results to a file.

cd /home/sqlitesqlite3 sample.db .dump > sample.bak

Restoring the database

Restoring the database from a backup is just as easy as backing up, except we must make sure the destination database is empty first. Alternatively you may want to delete or rename the destination database and let sqlite create a new one for you.

cd /home/sqlitemv sample.db sample.db.oldsqlite3 sample.db < sample.bak

After restoring, verify the results.

sqlite3 sample.db ‘select * from music;‘Beastie Boys|Paul‘s BoutiqueJohn, Elton|Goodbye Yellow Brick RoadParliment|Mothership Connection

如何備份與還原sqlite資料庫