echo ".dump" | sqlite3 old.db | sqlite3 new.db
Explanation: pipe “.dump” to sqlite and use that output (the dump itself) to fill the new.db database.
How to repair an SQLite database
September 17th, 2012 | development, Linux
-
Search
-
Draft posts
- Ivman, backing up, gutsy
- Creating a jruby .deb
- gnome-do-plugins
- Webby: short tutorial
- Python & Ruby (what I like and dislike)
- Installing Flash Media Server
- opensuse 11.0 (vs. ubuntu 8.04?)
- Cisco vpn client for linux (Ubuntu Hardy 64 bit)
- More bugs in ubuntu
- Olie directmeter
- last.fm radiostation clients
- Streaming to an icecast server
- xbmc stuff
- Installing roundcube 0.3.1 on Ubuntu Hardy 8.04
- Making vpn connection to Microsoft (pptp) under Ubuntu
- Installing php's uploadprogress
- PHP sessions expiring too quick
- Synology & Active directory directory service
Archives
- September 2012
- August 2012
- July 2012
- June 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- May 2011
- April 2011
- February 2011
- December 2010
- October 2010
- September 2010
- August 2010
- April 2010
- March 2010
- February 2010
- December 2009
- November 2009
- October 2009
- September 2009
- July 2009
- June 2009
- April 2009
- February 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- February 2008
-
LeonB @ GitHub
- Status updating...
0 comments ↓
There are no comments yet...Kick things off by filling out the form below.
Leave a Comment