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