import_spells.pl

[gredesh]

Can't seem to get this working. Perl 5.10 installed, did the ppm install DBI. It's in C:\Perl.
I get this error:

C:\EQEmu>perl import_spells.pl
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains:
C:/Perl/site/lib C:/Perl/lib .) at (eval 5) line 3, <F> line 51.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Proxy, SQLite,
Sponge.
at import_spells.pl line 61

I also tried googling and installing DBD. I'm not sure that i'm doing it right though, i'm pretty bad at this stuff. I managed to get it to say it installed DBD but the settings were to TestDB and user: ''. Not sure how to change the settings or if it's needed.

[blackdragonsdg]

If you are trying to run sql from inside of a perl script then you will need more than just the DBI package.

Try this:

1. From the Start Menu, navigate to the Perl Directory and launch the Perl Package Manager.

2. From the View Menu select All Packages...allow it to load from the internet.

3. Navigate to DBD-mysql, right click, select Install DBD-mysql, then repeat that process for the following packages

DBD-mysqlPP
DBI

4. From the File Menu, select Run Marked Actions, Allow installs to complete.

There are several other mysql packages on that list so you might have to do a bit of trial and error to figure out which ones you need.

[gredesh]

Works! Thank you very much! At first I couldn't find them but then I found the button to view all packages, instead of just the ones already installed.