Preperation for moving day
I’ve decided to go with WordPress for my blogging platform. I wanted to test it out at home on one of my computers. I installed MySQL and PHP. I installed the MySQL Administrator to manage the MySQL database to create a user and then give them permission to access a database.
I downloaded WordPress and unzipped it into a directory. Visiting the web site on my local machine told me that MySQL wasn’t available to PHP. I spent the next 3 hours debugging the PHP.ini file and googling for help. I tried the following:
- in PHP.ini, set extension_dir = “c:\PHP\ext\”
- uncomment extension=php_mysql.dll
- download pecl-5.0.5-Win32.zip and copy php_mysql.dll to the “ext” subdirectory
No matter what I would do, I would keep getting this error:
“Unable to load dynamic library ‘c:\PHP\ext\php_mysql.dll’”
Finally I found an answer in a forum post by DoopyNL.
I’ve copyed the file libmysql.dll from the main php folder to \windows\system32 and the error went away and I could use the mysql functionality in PHP.
I found the file in php-5.0.5-Win32.zip and copied it to the directory. As soon as that was done, WordPress installed itself without any problems.
Tags: WordPress, Troubleshooting, PHP, MySQL, php_mysql.dll, Installations, Web Development
September 29th, 2005 at 12:54 pm
Good move. Share your experience I can’t wait to set-up wordpress for my blog.
But currently I am having some issues with my hosting company.
Congrats once more!
September 29th, 2005 at 4:24 pm
This is so exciting! Sorry to hear you had a hiccup in the install though.
September 29th, 2005 at 5:30 pm
Lewis-
I was archiving some old email yesterday and ran across one of our short conversations. A few years ago you helped me with some ASP upload code for a file manager I created.
Long story short, I appreciated your help & insight in classic ASP nearly 2-1/2yrs ago. I was curious what youve been up to, which led me here.
I just saw your posting regarding word-press. I’d like to attempt to payback some of my debt. You struck me as a sophisticated and pragmatic programmer — not the typical hack you often find on the net.
Before you get married to Wordpress, check out http://www.drupal.org
it has awesome blogging capabilities (including API for 3rd party clients, such as blogger), but it is SO much more flexible than simple blogging projects such as wordpress. It is an open source CMS. the best I’ve used, in fact. Though xoops is pretty good too — thogh the architecture just didnt seem quite as mature. Drupal has a lot of features “out of the box… ” for blogging — and plenty of add-ons that are simple to install (and elegant to maintain). Simply, it is by far the most sophisticated open source php project I’ve encountered. (in terms of it’s architecture & API).
It’s a simple install if you’ve any familiarity with php & mysql… (and decent documentation if you’re not).
It is a little complex, but not in the initial setup. In fact it’s easy to overlook much of the complexity becuase it is mature and very user friendly… which should aid in learning its depth.
best of luck whatever you decide!
September 30th, 2005 at 2:33 am
I just ceased my paid hosting for 5 WP module that I had up and running on my domain. Went back to blogger … why pay a monthly hosting fee? Guess I haven’t cut it as a yuppy yet.
Linda
September 30th, 2005 at 5:18 am
There are quite a few reasons why I am leaving blogger. I’ve pretty much used blogger to its full capabilities. I feel its limitations constantly. I need to grow - not in data, but functionality.