Export > Import mysql data

Hello all,

I have Librenms running from last 20 days. 95 Devices and more than 15.000 Ports.
I have a few servers in my company and i’m thinking to move mysql to another mysql server.
I have mysql database exported but when i’m trying to import to the second mysql server i have this error:

Error
SQL query:

CREATE TABLE users (
user_id int(11) NOT NULL,
username char(30) COLLATE utf8_unicode_ci NOT NULL,
password varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
realname varchar(64) COLLATE utf8_unicode_ci NOT NULL,
email varchar(64) COLLATE utf8_unicode_ci NOT NULL,
descr char(30) COLLATE utf8_unicode_ci NOT NULL,
level tinyint(4) NOT NULL DEFAULT ‘0’,
can_modify_passwd tinyint(4) NOT NULL DEFAULT ‘1’,
twofactor varchar(255) COLLATE utf8_unicode_ci NOT NULL,
dashboard int(11) NOT NULL DEFAULT ‘0’,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
MySQL said: Documentation

#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

The idea is that maybe i can go forward to have more than 4000 devices in. (mostly switches with 48 ports).
The current server is a:
Intel Xeon X5660 @ 2.80GHz x24 with 48GB ram.

Also, if i will go foward, where i can find a tutorial to have a separate poller online? or maybe a few.

Thank you,

Paul

Sorry about that it was a bug. I just merged a fix. If you run ./daily.sh and re-export the data, it will work now :slight_smile:

https://github.com/librenms/librenms/pull/6224

Thank you, it’s working. What about having separate poller? How i can do that?

Definitely: http://docs.librenms.org/Extensions/Distributed-Poller/