Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • Won't this break all the aplications that install DBD::SQLite off of cpan and expect it to be able to read a version 2 database?
    • Yup! I just upgraded from .27 to 1.0, hoping to solve a sqllite/Moveable Type bug, and.... well, I'm glad I exported my postings first! Question: Are there any utilities for converting version 1 dbs?
      • This document [sqlite.org] on the sqlite website that was linked to in a previous journal entry seems to suggest:
        sqlite OLD.DB .dump | sqlite3 NEW.DB
        • OK, it's not that hard. Here's a few more of the steps on a linux machine:

          go to sqlite.org and download sqlite v.3 from

          http://www.sqlite.org/download.html

          Download version 2 as well

          gunzip sqlite*.gz

          copy sqlite3-3.0.3.bin to /usr/bin as sqlite3

          copy sqlite-2.8.15.bin to /usr/bin as sqlite

          chmod 755 sql*

          Then, with the two different programs properly named, the command above works quite well:

                    sqlite OLD.DB .dump | sqlite3 NEW.DB