I'm not worried about size of the tables, we just only want the devices and their custom location/geoloaction/ect settings brought over. We also don't want to bring over the config.php file as the original (server) has many of the lines manually changed rather than relying on the web interface to apply the custimaztions. The thought being that the new server installation will be easier to others on the team to work with if mostly managed over the web gui...
I suppose the simplest way to explain what i'm trying to accomplish is that we want a new server stood like we don't have an existing one, but I don't want to take the time to add all of the devices in again.
I've made the new servers' Database name and root username and password the same as the old one in hopes to ease the migration some.
I'm sure i'm butchering my explanation of this so for that I'm sorry.
PS. For what it's worth Adam we (Wisconsin DOC) love your product. Just wanted to throw that in there :)
-Josh
On Wed, Feb 28, 2018 at 12:14 PM, Adam Armstrong adama@observium.org wrote:
Copy the entire database, along with the rrd directory and config.php.
It's pretty easy, only possible complexity is adding the mysql username and password back!
You /will/ break your installation if you try to copy individual tables. I don't know why anyone would even want to mess around like that. You could truncate super large (GB+) tables before the mysql dump if you think it'll take too long.
adam.
On 2018-02-28 17:41:23, Josh Williams joshwilliams3737@gmail.com wrote:
We just purchased an upgraded server in which to host Observium on and I would like to know the “best” way to migrate over all of our monitored devices. I’m not concerned with any of the graphed data being migrated, or any of the old Observium config. I only want to do a mass export of all of the devices and their properties. Will a dump of the ‘devices’ and ‘devices_locations’ tables suffice? Are there other tables/directories/configs I need to be concerned about?
Thanks,
Josh Williams
Bureau of Technology Management
WI Department of Corrections
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/ cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium