Skip to content

Instantly share code, notes, and snippets.

@mmynsted

mmynsted/gist:921b32d06763cb7d9a34

Created May 8, 2015 21:51
Show Gist options
  • Save mmynsted/921b32d06763cb7d9a34 to your computer and use it in GitHub Desktop.
Save mmynsted/921b32d06763cb7d9a34 to your computer and use it in GitHub Desktop.
Download ZIP
sqlite3 recovery attempt for macports
Raw
gistfile1.txt
# pushd /opt/local/var/macports/registry
# mv registry.db registry.db.old
# sqlite3 registry.db.old
sqlite> .load /opt/local/var/macports/sources/rsync.macports.org/release/base/src/cregistry/macports.sqlext
sqlite> .mode insert
sqlite> .output dump_all.sql
sqlite> .dump
sqlite> .exit
# sqlite3 registry.db
sqlite> .load /opt/local/var/macports/sources/rsync.macports.org/release/base/src/cregistry/macports.sqlext
sqlite> .read dump_all.sql
sqlite> .exit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment