#11 conflict between mysql and gff

[deepak]

i tried to copy gff file into database .but its throughing
some exceptions.

C:\mysql\bin>mysql -uroot -p
Enter password: *******
ERROR 1045: Access denied for user: 'root@localhost'
(Using password:
YES)

C:\mysql\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end
with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.24-
debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database volvox;
Query OK, 1 row affected (0.17 sec)

mysql> grant all privileges on volvox.* to gopi@localhost;
Query OK, 0 rows affected (0.55 sec)

mysql> grant select on volvox.* to nobody@localhost;
Query OK, 0 rows affected (0.01 sec)

mysql> quit
Bye

C:\mysql\bin>cd ..

C:\mysql>cd data

C:\mysql\data>bp_load_gff.pl -c -d volvox volvox_all.fa
volvox_all.gff

------------- EXCEPTION -------------
MSG: Unable to load dbi::mysqlopt adaptor: Can't
locate DBI.pm in @INC
(@INC
con
tains: ../blib/lib C:/Perl/lib C:/Perl/site/lib .) at
C:/Perl/site/lib/Bio/DB/GF
F/Adaptor/dbi.pm line 24.
BEGIN failed--compilation aborted at
C:/Perl/site/lib/Bio/DB/GFF/Adaptor/dbi.pm
line 24.
Compilation failed in require at
C:/Perl/site/lib/Bio/DB/GFF/Adaptor/dbi/mysql.p
m line 15.
BEGIN failed--compilation aborted at
C:/Perl/site/lib/Bio/DB/GFF/Adaptor/dbi/mys
ql.pm line 15.
Compilation failed in require at
C:/Perl/site/lib/Bio/DB/GFF/Adaptor/dbi/mysqlop
t.pm line 29.
BEGIN failed--compilation aborted at
C:/Perl/site/lib/Bio/DB/GFF/Adaptor/dbi/mys
qlopt.pm line 29.
Compilation failed in require at (eval 13) line 1.

STACK Bio::DB::GFF::new
C:/Perl/site/lib/Bio/DB/GFF.pm:643
STACK toplevel C:\Perl\bin\bp_load_gff.pl:107

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

C:\mysql\data>

i don't know how to proceed plz help me ..deepak

[Scott Cain]

Logged In: YES
user_id=616711

Deepak,

Is MySQL, DBI.pm, DBD/mysql.pm installed? If you installed
with ppm, those are optional modules and you need to install
them separately. Please post support requests to the
GBrowse mailing list.

Scott

[Nobody/Anonymous]

Logged In: NO

thankz for you prompt reply
ok i did it in the same way through ppm , now tell me.
how do i install the optional modules?
plz specify the steps to me.