On Tue, 2006-01-31 at 15:44 +0200, Toni Timonen wrote:
> On Tue, Jan 31, 2006 at 03:41:08PM +0200, Toni Timonen wrote:
> > On Tue, Jan 31, 2006 at 06:34:36AM -0700, Gary Thomas wrote:
> > > On Tue, 2006-01-31 at 14:26 +0100, Emmanuel Blot wrote:
> > > > > Thanks for any pointers
> > > > 
> > > > You can use the sqlite(3) tool to dump the DB as SQL statements.
> > > 
> > > Thanks.  Given that I know nothing about SQL, could you elucidate
> > > please?
> > 
> > To backup:
> > sqlite your_db_file '.dump wiki' > wikibackup.sql
> > 
> > To restore:
> > sqlite your_db_file < wikibackup.sql
> > 
> > see 
> >  man 3 sqlite
> > for details.
> > 
> 
> Sorry, not "wiki", but "ticket", "ticket_change" and "ticket_custom",
> ofcourse.

Where do the attachments get stored (which table)?

-- 
------------------------------------------------------------
Gary Thomas                 |  Consulting for the
MLB Associates              |    Embedded world
------------------------------------------------------------

_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac

Reply via email to