MySQL Extension cannot be loaded

**dandono** · Jan 13th, 2006, 10:45 AM

hi, i am trying out mysql (again!!!). i need some help because when i enable the mysql extension i get an error every time anyone goes to a php doc on my server. the error is:
PHP Startup: Unable to load dynamic library './php_mysql.dll' - The specified module could not be found.
I dont know how to fix it. can any one help?
thanks, dandono.

**visualAd** · Jan 13th, 2006, 11:16 AM

Do you have php_mysql.dll in your PHP installation directory? If so, move it to the directory specified as the extension_dir in the php.ini file. If you do not you need to download the ZIP version of PHP 5 from the site. The standard installer does not ship with the php installer.

Also, ensure you have libmysql.dll copied into your windows directory or have the directory it is contained in appended to the windows PATH envrionment variable.

**dandono** · Jan 13th, 2006, 04:28 PM

i have done both but i still get the error. i changed the extension dir to "C:\PHP\ext" and put the php_mysql.dll file in to that dir. i dont know if i have done anything wrong

**visualAd** · Jan 13th, 2006, 05:16 PM

Where is libmysql.dll stored?

**dandono** · Jan 13th, 2006, 05:41 PM

libmysql.dll is in C:\Windows\

**visualAd** · Jan 13th, 2006, 06:00 PM

Have you installed PHP as a module? If so you will need to restart the web server before changes take effect.

**visualAd** · Jan 13th, 2006, 06:03 PM

BTW, your error page should now say:

Code:

PHP Startup: Unable to load dynamic library './ext/php_mysql.dll' - The specified module could not be found.

If it does not, it means PHP has either not found the PHP.ini file or it is using a different one. To confirm this you might want to create file with a call to phpinfo(), this will tell you exactly which configuration file is being use.

**dandono** · Jan 14th, 2006, 10:15 AM

do you meen restart the server as in restart the iis server or restart as in reboot?

**visualAd** · Jan 14th, 2006, 05:27 PM

Restart IIS.

**dandono** · Jan 14th, 2006, 05:54 PM

ok, once again my server has messed up. it is not that big of a problem but it still needs it to be reinstalled but some how i got my self into reformatting all the partitions on it and getting it ready for a new hard drive that i will ghost it onto. i will try MySQL as soon as i get it running again

im upgrading from an 80 gb hdd to a 300gb hdd and then in a few months im buying a few more 300gb's

i just had to brag

**dandono** · Jan 15th, 2006, 06:22 PM

ok i fixed it. so all i got to do is download php_mysql.dll from zip file on php.net, copy it to C:\php\ext\ and copy libmysql.dll to C:\windows\

**dandono** · Jan 15th, 2006, 06:31 PM

yay!!! i have finaly got MySQL working

thanks visualad
i would give you some rep but it says i need to spread it around; lol

Thread: MySQL Extension cannot be loaded

Thread Tools

Display

MySQL Extension cannot be loaded

Re: MySQL Extension cannot be loaded

Re: MySQL Extension cannot be loaded

Re: MySQL Extension cannot be loaded

Re: MySQL Extension cannot be loaded

Re: MySQL Extension cannot be loaded

Re: MySQL Extension cannot be loaded

Re: MySQL Extension cannot be loaded

Re: MySQL Extension cannot be loaded

Re: MySQL Extension cannot be loaded

Re: MySQL Extension cannot be loaded

Re: MySQL Extension cannot be loaded

Posting Permissions