Re: sqlite upgrade

El Fri, Nov 02, 2007 at 01:58:53PM -0300, Trac va escriure:
> Hello
> 
> has any one upgraded sqlite ?
> we want to upgrade our sqlite to 3.2.2-1 to 3.3.6-2.
> 
> I want to know if it will be backward compatible and if
 I need to do 
> backup as well.

I believe that the file format is compatible and the newer
version can read
the old one, anyway I've moved various databases between
different systems
with different sqlite versions and I always do a dump and
restore:

1. On the original system:

  $ sqlite trac.db .dump > trac.db.orig.dump
  $ mv trac.db trac.db.orig

2. On the new or upgraded system:

  $ sqlite3 trac.db < trac.db.orig.dump

-- 
Sergio Talens-Oliag <stodebian.org>   <http://people.debi
an.org/~sto/>
Key fingerprint = 29DF 544F  1BD9 548C  8F15 86EF  6770 052B
 B8C1 FA69

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

> 1. On the original system:
>
>   $ sqlite trac.db .dump > trac.db.orig.dump
>   $ mv trac.db trac.db.orig
>
> 2. On the new or upgraded system:
>
>   $ sqlite3 trac.db < trac.db.orig.dump

As both versions use a 3.x version, I think the backup
should be done
with sqlite3, not sqlite. You'll get an error if you use
"sqlite" on a
V3 db file.

Cheers,
Manu

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---