1Databasecreationscripts.PDF

2016/10/16 15:47 1/3 1 Database creation scripts 1 Database creation scripts Overview A Zabbix database must be created during the installation of Zabbix server or proxy. This section provides scripts for creating a Zabbix database. A separate schema script is provided for each supported database. schema.sql, images.sql and data.sql files are located in the database subdirectory of Zabbix sources. If Zabbix was installed from distribution packages, refer to the distribution documentation. For a Zabbix proxy database, only schema.sql should be imported (no images.sql nor data.sql) The order of database file import has been changed - images must be imported before data.sql now. Scripts MySQL We assume that a username user with password password exists and has permissions to create database objects. shell mysql -uusername -ppassword mysql create database zabbix character set utf8 collate utf8_bin; mysql quit; shell mysql -uusername -ppassword zabbix database/mysql/schema.sql # stop here if you are creating database for Zabbix proxy shell mysql -uusername -ppassword zabbix database/mysql/images.sql shell mysql -uusername -ppassword zabbix database/mysql/data.sql PostgreSQL We assume that a username user exists and has permissions to create database objects. shell psql -U username psql create database zabbix; psql \q shell cd database/postgresql shell psql -U username zabbix schema.sql # stop here if you are creating database for Zabbix proxy Zabbix Documentation 2.0 - /documentation/2.0/ Last update: 2016/02/10 13:39 manual:appendix:install:db_scripts /documentation/2.0/manual/appendix/install/db_scripts shell psql -U username zabbix images.sql shell psql -U username zabbix data.sql Oracle We assume that a zabbix database user with password password exists and has permissions to create database objects in ORCL service located on the ho