Page 1 of 1
sql error on restore
Posted: Fri Jul 17, 2020 7:16 pm
by scheived
Attempting to restore backup on centos6 I get,
Restoring MySQL databases...
ERROR 1005 (HY000) at line 1713: Can't create table 'nagiosql.tbl_lnkServicedependencyToServic
I tried to create the database manually and got the same error, why can't we create this table?
Re: sql error on restore
Posted: Mon Jul 20, 2020 1:07 pm
by benjaminsmith
Hi,
Just to clarify, are you restoring from a previous backup on the existing server or a new one? Let's start by running the database repair script, then try to run the restore again?
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
If this fails again, can you send over your system profile? And post the output of the following SQL command? Thanks. Benjamin
Code: Select all
echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.