billchen198318 / bamboobsc

next version move to https://github.com/billchen198318/hillfog, bambooBSC is an opensource Balanced Scorecard (BSC) Business Intelligence (BI) Web platform. BSC's Vision, Perspectives, Objectives of strategy, Key Performance Indicators (KPIs), Strategy Map, and SWOT, PDCA & PDCA report, Time Series Analysis.
Apache License 2.0
227 stars 110 forks source link

Run bambooBSC 0.7.7 with MariaDB 10 version. #91

Open billchen198318 opened 5 years ago

billchen198318 commented 5 years ago

Run bambooBSC with MariaDB 10 version step

SQL dump file download (use 7z to decompress) : https://github.com/billchen198318/bamboobsc/releases/download/v0.7.7/bamboobsc-0.7.7-MariaDB-SQL-dump.7z

1. Need MariaDB 10.3.13 or later version

2. Config MariaDB parameter --lower_case_table_names=1 on UNIX like system ( Linux or FreeBSD )

Please view: https://mariadb.com/kb/en/library/server-system-variables/#lower_case_table_names

on windows system please ignore step-2.

3. Start MariaDB server

4. Create database file

# mysql -u root -p MariaDB [(none)]> create database bbcore; Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> exit; Bye

# mysql bbcore -u root -p < bbcore.sql