error during Nagios Backup

[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

[mguthrie]

Try the following procedure and then rerun the backup procedure.
http://assets.nagios.com/downloads/nagi ... tabase.pdf

[benningtonr]

ok, will do,
How do I copy a file to nagios, using putty?
on my switches it is easy, copy tftp flash: enter

[scottwilkerson]

You can use a secure FTP client like filezilla, or WinSCP
http://winscp.net/eng/index.php

[benningtonr]

I have a tftp server, but i am unsure of the commands to run on nagios CLI

[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