Good day all! I'm deploying Zabbix with 3 DBs (ProxySQL on the 2 app servers and 3 MariaDB Galera servers). The zabbix user is able to connect from the ProxySQL/App server and the local servers and the database is there (named zabbix). However, when I attempt to zcat the create.sql.gz file and pipe to mysql, I'm running into issues. The first issue was no database selected, which i put that in a .my.cnf file for my user login, that got me past the "no database selected" issue. But then I ran into ERROR 1173 (42000) at line 1060: This table type requires a primary key. I re-ran zcat create.sql.gz | mysql -uzabbix -p, this time this error came up and I can't move past this:
ERROR 1050 (42S01) at line 1: Table 'users' already exists
Ubuntu 18.04
Zabbix 4.2
MariaDB 10.3.16
I'm doing this from a single DB server. I tried it from ProxySQL, but that failed too, which I'm pretty sure ProxySQL is introducing something in the zcat step, so I tar'd the entire directory where create.sql.gz lives and moved this over to the DB server from the app server. Not sure if I'm missing something there or not, maybe I should have snagged more?
I appreciate any advice! Thank you!
ERROR 1050 (42S01) at line 1: Table 'users' already exists
Ubuntu 18.04
Zabbix 4.2
MariaDB 10.3.16
I'm doing this from a single DB server. I tried it from ProxySQL, but that failed too, which I'm pretty sure ProxySQL is introducing something in the zcat step, so I tar'd the entire directory where create.sql.gz lives and moved this over to the DB server from the app server. Not sure if I'm missing something there or not, maybe I should have snagged more?
I appreciate any advice! Thank you!