Anyone working with mySQL and PHP?
 

I work with IT, but I'm green as to databases and web servers. I've got a backup of the old X-Factory forums, and I want to bring them to life.

I've tried to set up mySQL and PHP first on a test PC (following guides on the net) but I'm not able to make it spin.

Could anyone help me get this up and running?

What errors is it throwing back? I would say in the php file there is a connection string somewhere, make sure that points to your server (localhost or whatever it is)

Followed this guide:
http://www.builderau.com.au/program/...9271632,00.htm

Tried to set it up on an XP SP3 PC.

Didn't get past this:

Configure IIS
Even though PHP is configured, before you can start using it, you need to tell IIS how it is able to use the new service. Until you do this, trying to load PHP files into a Web browser from your IIS server will result in nothing but errors.
You can run PHP in one of two ways with IIS - using ISAPI, or as a CGI extension. Since the ISAPI method generally results in better performance, we'll go that route for this article. To get started, you need to add the PHP ISAPI extension to IIS.

1. Go to Start | Administrative Tools | Internet Information Services (IIS) Manager.
2. Select server name | Web Service Extensions.
3. From the right pane, click the "Add a new Web service extension..." option.

(see no such option...)

Then tried this:

To get all the hassle out of the way for installing and setting Apache - PhP - MySql, you can look at the project at http://vertrigo.sourceforge.net/

...but no success either...

Do you have mySQL and PHP set up already? Could you try an import of the backup files? (can put them on my server for FTP download)

Edit: Trying WAMPserver 2.0i now...

Have you got IIS installed on your machine? Its a windows component and not on as standard.

I do have mysql server, but its in use and i can't access it from work.

Yes, I installed the component as per the instructions. But got stuck as I explained in the previous post on some setting...

K, FTP it somewhere and PM me the location, I will download and take a look.

I might be able to host the DB and if you can find some free PHP hosting, I can point the connection strings to my server (depends on DB size of course)

U got PM.

I'm sure I can get someone I know to host PHP service.

Cheers

Received, Will sort somit out, its just SQL so quick to upload, will change config files and send them over.

Give EasyPHP a go: http://www.easyphp.org/

That contains Apache (Webserver), PHP module, mysql (SQL server) and PHPmyadmin (SQL admin) and installs really easily.

If it were me, I would download something called xampp. It's really simple and will get a web server with Mysql running on your PC within minutes.

It's great because it also provides phpmyadmin, which you can use to create a database and import the data you have.

DB's are up, just looking for php hosting now.

With Wampserver I got all the stuff installed fine. But I didn't manage to restore the databases.

But thanks to Toadeh here, they're now up and running! :thumbsup:

Thx guys! This really is the best forum in the world! Not only for RC obviously!!!