Export ScadaBR database to KairosDB
If you're running ScadaBR and you would like to export your MySQL/MariaDB database to KairosDB, a modern NoSQL time series database that runs on top of Cassandra, then you're in the right place.
This small Python script will easily convert your ScadaBR database into a KairosDB database.
Installation / How to use?
It's very simple to use this script and it should work in any Linux distribution that has Python3 installed and mysql-connector-python [both are pre-requisite, please install mysql-connector-python].
1) Before start make sure that you are okay with all of the following items:
- MySQL/MariaDB server up and running.
- KairosDB server up and running.
- ScadaBR database inside your server.
2) Run the script in your Terminal (Ctrl+Alt+T):
chmod +x export.sh
./export.sh3) Provide the credentials:
In order to export the database, our Python script must know your database name, your username and your password for MySQL/MariaDB database.
- Dabase name: the ScadaBR database name. The default is
scadabr. - Username: give the username you use to connect into to MySQL/MariaDB. The default is
root. - Password: give the password you use WITH THE USERNAME PROVIDED PREVIOUSLY to connect to MySQL/MariaDB. The default is `` (empty).
Now the script should do the work! Be patient and if you got any trouble, question, bug or want to suggest us a feature, feel free to contact me at fernandopalad@gmail.com (or via GitHub Issues).
About
This small script was developed by Fernando Paladini on 2015. Hope it help you :)