I was going to write a migration guide in the documentation for you, but I got busy.
Yeah, mysqldump, the nat the other end after creating the database (before the isntall guide tells you to run update.php, do mysql -u user -p'password' database_name < backupfile.sql
adam. On 13/08/2015 16:35:49, Ron Marosko ron@rjr-services.com wrote: All my answer are belong to google. ;-) mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql] Sorry for the bandwidth. From: observium [mailto:observium-bounces@observium.org] On Behalf Of Ron Marosko Sent: Thursday, August 13, 2015 8:44 AM To: 'Observium Network Observation System' Subject: Re: [Observium] backup data Sorry to resurrect this thread… apparently at some point my system quit processing inbound syslog messages and I can’t figure out why. I do see through tcpdump that the rsyslog messages are hitting the server, and rsyslogd is running on the observium host, just the messages are no longer showing up in the observium application. I’m figuring this may be a good opportunity to stand up a new VM on 14.04 instead of 12.04 and just migrate everything over… so I’ll show my lack of knowledge of MySQL…. I know to copy config.php and rrd/*, but what’s the best way to back up the database? Just copy that file? Or export/import the database (and if so, how?)? Thanks, Ron From: observium [mailto:observium-bounces@observium.org [mailto:observium-bounces@observium.org]] On Behalf Of Adam Armstrong Sent: Wednesday, June 10, 2015 5:45 AM To: observium@observium.org [mailto:observium@observium.org] Subject: Re: [Observium] backup data MySQL database, config.php and rrd/ Logs are just... logs, no need to back those up. :) adam. Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] On 10/06/2015 11:43:47, Farshid Abediny <farshidabediny@gmail.com [mailto:farshidabediny@gmail.com]> wrote: Hi, how can we backup observium data that if our VMs lost we can recover data ? only backup of database rrd/ logs/ folder is enough? thanks, _______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]