After following a promising lead, I'm at a dead end again.
1. Downloaded and installed binary distribution for MySQL 3.23.38 as
recommended (originally tested with 3.23.37).
2. Installed mysqld-max-nt.exe service under Windows NT 4.0 SP 4.
3. perl script successfully executed:
$dbh = DBI->connect("DBI:mysql:mysql:localhost");
$sth = $dbh->prepare("SELECT * FROM db");
$sth->execute;
$row = $sth->fetchrow_hashref;
A row was returned showing fields and values, so the service is running and
databases can be accessed.
4. Created text file c:\mysql\data\mydb.sym with the string:
c:\inetpub\wwwroot\mydb
5. Moved the c:\mysql\data\mydb tree to c:\inetpub\wwwroot\mydb.
6. Stopped and restarted MySQL service just in case.
7. perl script tried to execute:
$dbh = DBI->connect("DBI:mysql:mydb:localhost");
8. Error reported by CGI script:
Error 1049 Text: Unknown database 'mydb'
I tried all manner of "/", "\\" in mydb.sym, extra blank lines. I also
tried using mysqladmin to create the database after the mydb.sym file was
created. It still created the mydb directory under c:\mysql\data.
Can't make it work nohow. Any suggestions?
Thanks
Tom
