after migration: question about recommended backup procedure

Peter Funk <[email protected]>
Newsgroups gmane.comp.bug-tracking.roundup.user
Message-ID <20160126154534.GC16985@pfmaster-P170EM>
Hello all,

First I would like to say thank you to Anatoly, Bernhard, Ezio,
Ralf and all others who have helped to improve Roundup and to get
1.5.1 released.

With the help of our employees we successfully migrated our roundup
instance from version 0.8.4 (yes, that old!!!) up to version 1.5.1
last week.  During the same step we have migrated our data base
backend from sqlite to mysql.

Now I've a question: 

The roundup Administration Guide points out that the
roundup-admin export is **NOT** recommended for backups.
( http://www.roundup-tracker.org/docs/admin_guide.html#tracker-backup )

But in the following paragraph this section gives only clear
advice of what could be done for users of the postgresql
backend.

We had during the past 11 years a cron script running hourly
which simply copied the tracker home directory using the
rsync program.  I'm aware of the fact that this was probably
a little bit risky if a transaction happened to the sqlite db
file during the process of copying of this file.

Now with mysql as our backend I assume we should use mysqldump
to take snapshot backups of the RDBMS.  Am I right?

Best Regards and thanks in advance,
Peter Funk
-- 
Peter Funk, home: ✉Oldenburger Str.86, D-27777 Ganderkesee
mobile:+49-179-640-8878 phone:+49-421-20419-0 <http://www.artcom-gmbh.de/>
office: ArtCom GmbH, ✉Haferwende 2, D-28357 Bremen, Germany

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Roundup-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/roundup-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.