You do need to know where the database files are, Josh indicates the
SQLite ones are in the trac environment tree. I use PostgreSQL but I
set it up and know where the files are (and it is only used for our Trac
dBs)...
You can also just dump the appropriate table out of the database, such
as with pg_dump. For example, this is my nightly DB backup script:
#!/bin/bash
if [ `whoami` != 'postgres' ]; then
echo "Please run this as user postgres";
exit 255;
fi
FILE=$(mktemp /opt/trac/eng/db/postgres.bak.`date +%F`.XXXXXXXXXX)
if [ "$?" -eq "0" ]; then
pg_dump trac > $FILE && lzma $FILE;
fi
(this happens before a full filesystem dump to offline media, so even if
the db is caught in an inconsistent state, we can restore from this..
belt and suspenders and all that).
P.S. oh, and I do this on Windows which is not as backwards with such
tools these days as some people think...
Yeah, but why fight with it? I mean, when most Linux distros are free
and (presumably) supported (or at least allowed) in your organization,
why incur the cost of another Windows license and then have to deal with
all the pain and angish of having to set up infrastructure that you get
for free (or, at least, at a very low "<packagemanager> install
<thingy>" cost), it just seems easier to run it on Linux. Heck, most
Linux distros these days are basically turnkey, and picking one over
another ends up coming down a lot to preference.
--
SIXNET - Industrial and Wireless Connectivity
331 Ushers Road, Ballston Lake, NY 12019
Tel: 1.518.877.5173, Fax: 1.518.877.8346
www.sixnet.com
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en.
