SQLite 2.x - 3.x upgrade - Slashdot

Want to read Slashdot from your mobile device? Point it at m.slashdot.org and keep reading!

×

Journal lithron's Journal: SQLite 2.x - 3.x upgrade 1

Journal by lithron on Tuesday May 31, 2005 @03:20PM

If anyone here is planning on upgrading from SQLite 2.x to 3.x, let me suggest reading the documentation rather well. Then go back and read it again.

Now, learn to love the ".dump" command.

I spent about 3 hours of my time this weekend upgrading Movable Type to version 3 of SQLite. If I'd have been intelligent it would have taken about 30 minutes.

This discussion has been archived. No new comments can be posted.

SQLite 2.x - 3.x upgrade

Load All Comments

Search 1 Comments Log In/Create an Account

Comments Filter:

Future Reference (Score:2)

by Neon Spiral Injector ( 21234 ) writes:

Just for future reference (although you may have already made the logical conclusion) every piece of database software with which I have worked has changed the on-disk structure between major revisions. Some provide a more seamless migration tool, but most need a dump and restore.

There may be more comments in this discussion. Without JavaScript enabled, you might want to turn on Classic Discussion System in your preferences instead.

"Spock, did you see the looks on their faces?" "Yes, Captain, a sort of vacant contentment."