> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:nagios-users- > [EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, July 03, 2007 10:05 PM > To: Morris, Patrick > Cc: nagios-users@lists.sourceforge.net > Subject: Re: [Nagios-users] nagios with Mysql > > I have dropped nagios DB which I created and trying to re create again. > > When I execute installdb script for tables creation, I get below error > > DBD::mysql::db do failed: Table 'nagios.nagios_dbversion' doesn't exist > at ./installdb line 51. > ** Creating tables for version 1.4b4 > Using mysql.sql for installation... > ERROR 1064 at line 19: You have an error in your SQL syntax near > 'ENGINE=MyISAM COMMENT='Current and historical host and service > acknowledgements'' at line 15 > Installation from mysql.sql failed at ./installdb line 59.
What version of MySQL are you building it with? I'd have to be a pretty old version not to support the "ENINE=MyISAM" option. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null