SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Colorado
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    development vs production environment

    I am a beginning web developer just starting to work with MySQL. My question is how closely or exactly does my development environment have to match the production environment provided by my host in regard to a MySQL database.
    For example, the production environment is Linux, Apache, PHP supported, would a MySQL database developed in MySQL on a Windows machine with IIS work when moved onto the Linux server, assuming I use the same version # of MySQL and that I code in PHP?

  2. #2
    SitePoint Wizard swdev's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    1,053
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have the same setup
    My Host Linux Apache PHP and MySQL
    My Dev Windows XP Apache PHP and MySQL

    I opted to make sure that the version of Apache, PHP and MySQL were the same on my dev server as they are on the host.

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,340
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    yes, mysql versions are the same across platforms

    you should definitely check that the production mysql server is the same version or higher than the development server

    no sense developing sweet queries using something like WITH ROLLUP or GROUP_CONCAT if they won't work in production
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Colorado
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Awesome, I have all the version information I need from my host and can now set up my dev web server and download MySQL.
    Thank you for the help, its much appreciated!


Bookmarks

Posting Permissions

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