+ Post New Thread
Page 1 of 3 123 LastLast
Results 1 to 15 of 45
Web Development Thread, using mysql & php on a W2K SP2 server in Coding and Web Development; I'm currently hosting our school's website (what there is of it) in my own webspace so that I could get ...
  1. #1

    beeswax's Avatar
    Join Date
    Jul 2005
    Location
    England
    Posts
    2,285
    Thank Post
    285
    Thanked 225 Times in 153 Posts
    Rep Power
    131

    using mysql & php on a W2K SP2 server

    I'm currently hosting our school's website (what there is of it) in my own webspace so that I could get my head around CMS Made Simple. the Head has now sent a newsletter out saying that the new site will be up and running in 2 weeks, so look out for it.
    My host uses linux servers with mysql and php and the databases mostly set up. As you can guess, I want to try and replicate this on our W2K server in house. I could do with some help with this, or it's off to the east wing with a pearl handled revolver.
    beeswax

  2. #2

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,417
    Thank Post
    644
    Thanked 965 Times in 665 Posts
    Blog Entries
    2
    Rep Power
    328

    Re: using mysql & php on a W2K SP2 server

    www.en.wampserver.com

    Looks VERY smart by the way, good job

  3. #3

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,850
    Thank Post
    110
    Thanked 598 Times in 514 Posts
    Blog Entries
    1
    Rep Power
    227

    Re: using mysql & php on a W2K SP2 server

    Do you already have an internal web server?
    Do you want to use Apache or IIS?
    Is using a Linux server an option?
    Do you want to be able to access the website externally?

  4. #4

    Join Date
    May 2006
    Location
    Leicestershire
    Posts
    345
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: using mysql & php on a W2K SP2 server

    you will be able to back up the whole of the mysql database by using the mysqldump function, and this will create a txt file holding all the SQL required to build the database back from scratch

    Code:
    mysqldump -u username -p password databasename > fileName.sql
    the above is to back up the database, and the below is to recreate the database.... note that the sql needs to sit where the mysql.exe is.... and u run this at the command line.

    Code:
    mysqldump -u username -p password databasename < fileName.sql
    thats for the database

    as for the webserver..... i have set up PHP and mysql on 2K3 server using both IIS and apache..... which one are you going to be using?

  5. #5

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,417
    Thank Post
    644
    Thanked 965 Times in 665 Posts
    Blog Entries
    2
    Rep Power
    328

    Re: using mysql & php on a W2K SP2 server

    PHP runs very poorly on IIS, take our site for example :? Apache will be better.

  6. #6

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,850
    Thank Post
    110
    Thanked 598 Times in 514 Posts
    Blog Entries
    1
    Rep Power
    227

    Re: using mysql & php on a W2K SP2 server

    Hosting providers usually have PHPMyAdmin avalible too which will allow you to export the database easily.

    You can transfer the files with FTP.

  7. #7
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,491
    Thank Post
    10
    Thanked 502 Times in 442 Posts
    Rep Power
    114

    Re: using mysql & php on a W2K SP2 server

    Just remember not to use Apache 2.2 as php is still not built to work with it, I do have an alternate build at home that works, but there appears to be a memory leak in the apache version used. I'll probably go back to 2.0

  8. #8

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,597
    Thank Post
    109
    Thanked 770 Times in 598 Posts
    Rep Power
    183

    Re: using mysql & php on a W2K SP2 server

    Why are you running SP2? That's a good couple of service packs old and must surely leave tthat vulnerable IIS box open to more attacks than a pointy stick may be pointed at!

    BTW... php4 and mySQL have been fine for me on 2K in the past... never had much luck with php5 though :S

  9. #9

    beeswax's Avatar
    Join Date
    Jul 2005
    Location
    England
    Posts
    2,285
    Thank Post
    285
    Thanked 225 Times in 153 Posts
    Rep Power
    131

    Re: using mysql & php on a W2K SP2 server

    my mistake. trying to get 25 hours out of every day. I meant SP4. thanks for taking the time to answer, and the compliments.

  10. #10
    Guest

    Re: using mysql & php on a W2K SP2 server

    http://apache2triad.net/

    Have it running on a W2K3 box hosting demo moodle / intranet / gallery2 / and soon to be atmail. Works a treat.

  11. #11
    Joedetic's Avatar
    Join Date
    Jan 2006
    Location
    Walsall
    Posts
    1,316
    Thank Post
    6
    Thanked 13 Times in 13 Posts
    Rep Power
    22

    Re: using mysql & php on a W2K SP2 server

    http://www.apachefriends.org/en/xampp.html

    That's what i use if i've got to put AMP type stuff on a doze machine.

    I used it to test a php website before committing a LAMP server to it.

  12. #12

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,850
    Thank Post
    110
    Thanked 598 Times in 514 Posts
    Blog Entries
    1
    Rep Power
    227

    Re: using mysql & php on a W2K SP2 server

    Yep, bear in mind the performance of Apache on Windows is terrible. Also consider the fact that PHP on IIS performance is similarly terrible.

    Basically, if you need a high performance web server, you need a LAMP box.

  13. #13
    Joedetic's Avatar
    Join Date
    Jan 2006
    Location
    Walsall
    Posts
    1,316
    Thank Post
    6
    Thanked 13 Times in 13 Posts
    Rep Power
    22

    Re: using mysql & php on a W2K SP2 server

    And for which i'd suggest Ubuntu Server because it has the option to install a basic LAMP server during the installation

  14. #14

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,417
    Thank Post
    644
    Thanked 965 Times in 665 Posts
    Blog Entries
    2
    Rep Power
    328

    Re: using mysql & php on a W2K SP2 server

    Quote Originally Posted by Joedetic
    And for which i'd suggest Ubuntu Server because it has the option to install a basic LAMP server during the installation
    Seconded! Installed it last night, brilliant stuff

  15. #15

    beeswax's Avatar
    Join Date
    Jul 2005
    Location
    England
    Posts
    2,285
    Thank Post
    285
    Thanked 225 Times in 153 Posts
    Rep Power
    131

    Re: using mysql & php on a W2K SP2 server

    I made similar enquiries last September/October/November regarding using linux based server(s) to host the school's website, and looked at several, including Debian. My worry, ok, my NM's worry, is security. If I have a machine running Ubuntu server to host our website (and eventually our moodle intranet) within the school, how do I go about securing it?
    thanks again for your time



SHARE:
+ Post New Thread
Page 1 of 3 123 LastLast

Similar Threads

  1. OS X Server MySQL default installation
    By HodgeHi in forum *nix
    Replies: 2
    Last Post: 30th May 2008, 03:37 PM
  2. MYSQL Help
    By danIT in forum General Chat
    Replies: 2
    Last Post: 18th December 2007, 10:52 PM
  3. SiteAtSchool / IIS / PHP / MySQL / Server 2003
    By OutToLunch in forum Windows
    Replies: 4
    Last Post: 5th February 2007, 03:19 PM
  4. Access DB to MySQL
    By Gatt in forum Web Development
    Replies: 3
    Last Post: 29th November 2006, 11:32 PM
  5. php MySql
    By iking in forum Books and Manuals
    Replies: 0
    Last Post: 11th July 2005, 04:35 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •