Error Importing default cacti database

[cabin]

Installing on WinXP pro SP2
cacti 0.8.6g
mysql 5.0.1
apache 2.0.54
php 5.0.5

after I create the cacti database I import the cacti database

C:\>mysql -u root -p -D cacti < c:\apache2\htdocs\cacti\cacti.sql
Enter password: *****
ERROR 1264 (22003) at line 1856: Out of range value adjusted for column 'availability' at row 1

I continued on and created cactiuser@localhost for the database, finished rest of install

When I launch the webpage I get message:

Error
You have created a new database, but have not yet imported the 'cacti.sql' file. At the command line, execute the following to continue:

mysql -u cactiuser -p cacti < cacti.sql


I try importing catcti.sql again and get :
ERROR 1050 (42S01) at line 4: Table 'cdef' already exists

Any ideas?

I have gotten cacti running on a 2000 Server but with older versions of everything, was hoping to get this running with the latest versions.

Thanks

[Lmiller]

To start with the basics, have you verified that there is a cacti.sql file in the path you are typing?

[Lmiller]

Also, have you tried any other versions of MYSQL?

[cabin]

I have verified the path, it takes the file but hangs up on the

100.00000 in the line in cacti.sql

availability decimal(7,5) NOT NULL default '100.00000',

if I change 100.00000 to 99.99999 here and in the INSERT INTO host VAULES it takes and imports everything correctly.

I have not tried an older version as this seems to have fixed it and allowed me to get things up and running.

[rony]

Cacti is not supported on mysql 5.x, go back to 4.x.