Hi ,
My Ibdata file is grown to 5.8 G , to fix the issue , i recreated the database . I recreated the database and tried to restore with the backup . I go the below error once back up got completed . Please find the details of my mysql.dmp file and help me out .
MYSQL DUMP File:
zabbix.dmp.201012050315
Restoring Process:
mysql zabbix < zabbix.dmp.201012050315
Error after restoring Database:
ERROR 1062 (23000) at line 1834: Duplicate entry '0-events-eventid' for key 1
Error getting while accesing through Web Interface:
Error in query [SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid] [Table 'zabbix.nodes' doesn't exist]
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:546]
mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:548]
Error in query [SELECT u.* FROM users u WHERE u.alias='guest' AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.users' doesn't exist]
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:546]
mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:548]
Error in query [UPDATE sessions SET status=1 WHERE sessionid=''] [Table 'zabbix.sessions' doesn't exist]
Error in query [SELECT count(u.userid) as user_cnt FROM users u] [Table 'zabbix.users' doesn't exist]
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:546]
mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:548][/B]
Followed in the Forum:
http://www.zabbix.com/forum/showthre...abase+recreate
My Ibdata file is grown to 5.8 G , to fix the issue , i recreated the database . I recreated the database and tried to restore with the backup . I go the below error once back up got completed . Please find the details of my mysql.dmp file and help me out .
MYSQL DUMP File:
zabbix.dmp.201012050315
Restoring Process:
mysql zabbix < zabbix.dmp.201012050315
Error after restoring Database:
ERROR 1062 (23000) at line 1834: Duplicate entry '0-events-eventid' for key 1
Error getting while accesing through Web Interface:
Error in query [SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid] [Table 'zabbix.nodes' doesn't exist]
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:546]
mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:548]
Error in query [SELECT u.* FROM users u WHERE u.alias='guest' AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.users' doesn't exist]
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:546]
mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:548]
Error in query [UPDATE sessions SET status=1 WHERE sessionid=''] [Table 'zabbix.sessions' doesn't exist]
Error in query [SELECT count(u.userid) as user_cnt FROM users u] [Table 'zabbix.users' doesn't exist]
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:546]
mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/php/include/db.inc.php:548][/B]
Followed in the Forum:
http://www.zabbix.com/forum/showthre...abase+recreate