Page 1 of 1
error during Nagios Backup
Posted: Fri Jul 13, 2012 12:43 pm
by benningtonr
Backing up MySQL databases...
mysqldump: Got error: 145: Table './nagios/nagios_systemcommands' is marked as crashed and should be repaired when using LOCK TABLES
Passowrd is correct
Re: error during Nagios Backup
Posted: Fri Jul 13, 2012 12:54 pm
by mguthrie
Try the following procedure and then rerun the backup procedure.
http://assets.nagios.com/downloads/nagi ... tabase.pdf
Re: error during Nagios Backup
Posted: Fri Jul 13, 2012 12:59 pm
by benningtonr
ok, will do,
How do I copy a file to nagios, using putty?
on my switches it is easy, copy tftp flash: enter
Re: error during Nagios Backup
Posted: Fri Jul 13, 2012 2:15 pm
by scottwilkerson
You can use a secure FTP client like filezilla, or WinSCP
http://winscp.net/eng/index.php
Re: error during Nagios Backup
Posted: Fri Jul 13, 2012 2:18 pm
by benningtonr
I have a tftp server, but i am unsure of the commands to run on nagios CLI
Re: error during Nagios Backup
Posted: Fri Jul 13, 2012 2:24 pm
by scottwilkerson
Nagios server doesn't use tftp, it does use SSH which will allow a direct connection with WinSCP to transfer files.
If you are referring to the commands to repair the database, do the following:
Connect with Putty as root
Run the following commands as the terminal
Code: Select all
service mysqld stop
/usr/local/nagiosxi/scripts/repairmysql.sh nagios
service mysqld start