SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 2003
    Posts
    92
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Hosting MySQL Question

    My site host does not support MySQL. I have been told I can install it on my local machine and have my shopping cart access it here. How do I do this? I have down loaded and installed MySQL but do not know what to do next. If someone could walk me through this it would be appreciated.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    i cannot walk you through it, sorry (i don't do installs)

    however, if you are thinking of hooking up your hosted web site to a shopping cart on your local machine, you are asking for a world of hurt -- don't do that
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast
    Join Date
    Dec 2003
    Posts
    92
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937
    …if you are thinking of hooking up your hosted web site to a shopping cart on your local machine, you are asking for a world of hurt -- don't do that
    No, not the cart just the SQL database. The cart would still reside on the site server. Is that any better?

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by Don1
    Is that any better?
    no

    most hosts offer some type of database

    if yours doesn't, i would seriously consider moving to a new host, instead of the local machine idea
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    Programming Team silver trophybronze trophy
    Mittineague's Avatar
    Join Date
    Jul 2005
    Location
    West Springfield, Massachusetts
    Posts
    16,449
    Mentioned
    160 Post(s)
    Tagged
    1 Thread(s)

    hosting MySQL

    Consider these points
    Do you want your computer to be a server and left on and connected to the internet all the time?
    Do you want to risk data corruption or loss (do you have another computer to store backup files on)?
    IMHO, which is meant to reinforce r937's post , GET A NEW HOST or give up the MySQL

  6. #6
    SitePoint Enthusiast
    Join Date
    Dec 2003
    Posts
    92
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Mittineague
    Consider these points
    IMHO, which is meant to reinforce r937's post , GET A NEW HOST
    My options are leaning toward moving from earthlink (it's amazing that such a large company doesn't support MySQL). Just to review, I have these options:

    1. Move and hope we can find a host we can trust and has an up time as good as earthlink.
    2. Keep it there and rebuild the present store in with CSS and continue to update information manually.
    3. Try the above setup to see how things go on some "unpublished" pages. This way I'll at least see if the shopping cart (osCommerce) will do what we need it to do. Our machines are running around the clock and I am looking to see if we can get a static IPA.
    4. Host everything right here. We may just have to invest in an Xserve G5

    Did I miss any?

    My thinking is I would really like to see if this osCommerce can do what we need it to do without bugs. If it can then I could easily be sold on moving.

  7. #7
    Programming Team silver trophybronze trophy
    Mittineague's Avatar
    Join Date
    Jul 2005
    Location
    West Springfield, Massachusetts
    Posts
    16,449
    Mentioned
    160 Post(s)
    Tagged
    1 Thread(s)

    Earthlink full sevice web hosting

    Do they have another database other than MySQL? It may be easier and better to learn how to use what they have. Especially if you prefer them for hosting. If osCommerce requires MySQL, how about a different shopping cart app?


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
  •