An error is reported when importing the Zabbix database using the following command
Solution:
Edit the database file to be imported
vim /usr/share/doc/zabbix-server-mysql-4.0.7/create.sql.gz
# Add in the first line
use zabbix;
As shown below:
Save and exit!
Then re-import the MySQL database. Note: The import process may take a few seconds.
zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -u zabbix -p
Read More:
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used by doubl
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- [Solved] zabbix configure: error: MySQL library not found
- [Solved] C# connecting to MySQL database reports an error
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- [Solved] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
- Using Mybatis to connect to the database error: Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver···
- IDEA maven Config MYSQL Connection Error: Could not create connection to database server.
- [Solved] dbeaver import Error: Error 1840 (HY000) at line 24
- scm_prepare_database.sh CDH initial data script execute error
- [Solved] Connections could not be acquired from the underlying database
- [How to Fix] Database can’t open file (errno:24)
- MYSQL Slave is not configured or failed to initialize properly. You must at least set –server-id
- [Solved] Error 1044: Access denied for user ‘syz-remote‘@‘%‘ to database ‘webapp‘
- C# System.Data.SQLite.SQLiteException:“SQL logic error or missing database no such table: XX”
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- [Solved] Worker 1 failed executing transaction ‘ANONYMOUS‘ at master log mall-mysql-bin.000001, end_log_pos
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘