Stupid webhosts and 1 database

Discussion in 'Site & Server Administration' started by NYCSavage, Apr 2, 2008.

  1. #1
    Ok basically, I asked support if they offered mysql databases and they said it was part of the package so yes.

    Great

    So I signed up, paid my fees and find out I only get 1 database!

    Anyway, long story short, I want to use a database of mine hosted elsewhere but my hosts have blocked external connections.

    They only allow access to the 1 root database. I asked if I could buy more but they dont do this.

    I had an idea to create a database in a subfolder and use that, would this work?

    Or another idea, how about using .htaccess somehow to circumnavigate the no external connections rule?

    Basically, what im asking is, is there a way to get arounds this short of buying a new hosting plan elsewhere?
     
    NYCSavage, Apr 2, 2008 IP
  2. gate2vn

    gate2vn Peon

    Messages:
    809
    Likes Received:
    33
    Best Answers:
    1
    Trophy Points:
    0
    #2
    If you are happy with the performance there, you can create many tables with different prefix in one database. Otherwise, moving to new vendor seems to be better
     
    gate2vn, Apr 2, 2008 IP
  3. rllunzmann

    rllunzmann Active Member

    Messages:
    1,796
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    80
    #3
    Also, i'm suprised you are only allowed 1 MySQL database. Interesting.
     
    rllunzmann, Apr 2, 2008 IP
  4. NYCSavage

    NYCSavage Active Member

    Messages:
    249
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    75
    #4
    I am using a script that autoinstalls into the mysql, so if I did, then it would write over existing content
     
    NYCSavage, Apr 2, 2008 IP
  5. rllunzmann

    rllunzmann Active Member

    Messages:
    1,796
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    80
    #5
    Otherwise if things don't pan out, you'll want to find a new free or paid host.
     
    rllunzmann, Apr 3, 2008 IP
  6. ishan

    ishan Prominent Member

    Messages:
    2,212
    Likes Received:
    88
    Best Answers:
    0
    Trophy Points:
    325
    #6
    I agree.
    You can use the same database with multiple users & prefixes, or find a new host which allows more than 1 database. Mostly, all hosts allow unlimited MySQL databases.
     
    ishan, Apr 4, 2008 IP
  7. NYCSavage

    NYCSavage Active Member

    Messages:
    249
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    75
    #7
    I gave up and have just purchased hosting on Hostgator, thanks to those that helpe me
     
    NYCSavage, Apr 4, 2008 IP