error while importing mysql file

2 views
Skip to first unread message

Richard Lucassen

unread,
Aug 23, 2006, 10:10:29 AM8/23/06
to Nagios Config
Hello list,

I get the following error:

# mysql -u root -p nagios_config <
/var/www/nagios_config1.3.4/contrib/nagios_config.mysql
Enter password:
ERROR 1064 at line 21: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'DEFAULT CHARSET=latin1' at line 21

Anyone a hint? Debian Sarge, MySQL-4.0.24.

Richard

Martin, Jared

unread,
Aug 23, 2006, 5:21:02 PM8/23/06
to nagios...@googlegroups.com
Yeah, I just fixed that last weekon my Ubuntu system. Go through the
nagios_config.mysql file and remove that wording (DEFAULT
CHARSET=latin1) every time you see it. It was created for an older
verion of MySQL. From what I've heard, removing the text doesn't hurt
anything. (You can always back it up)


Hello list,

Richard



--------------------------------------------------------

IRS Circular 230 Disclosure:
To ensure compliance with requirements imposed by the IRS, we inform you that any U.S. federal tax advice contained in this communication (including any attachments) is not intended or written to be used, and cannot be used, for the purpose of (i) avoiding penalties under the Internal Revenue Code or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein. For more information please click on the following link: http://www.dglaw.com/circular/

This message contains confidential information and is intended only for nagios...@googlegroups.com. If you are not nagios...@googlegroups.com you should not disseminate, distribute or copy this e-mail. Please notify JMa...@dglaw.com immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

Richard Lucassen

unread,
Aug 24, 2006, 5:21:09 AM8/24/06
to Nagios Config
Martin, Jared wrote:

> Yeah, I just fixed that last weekon my Ubuntu system. Go through the
> nagios_config.mysql file and remove that wording (DEFAULT
> CHARSET=latin1) every time you see it. It was created for an older
> verion of MySQL. From what I've heard, removing the text doesn't hurt
> anything. (You can always back it up)

Yep, that did it! Thnx!

R.

Reply all
Reply to author
Forward
0 new messages