Install WORDPRESS SQL on GoDaddy

Discussion in 'WordPress' started by netgo, Jan 21, 2010.

  1. #1
    I have a hosting account with Godaddy and they have a limit of 25 SQL's installations. Is there a way to go around it and install another SQL (not using their easy auto install process)?

    Other hosting companies offer unlimited domains so I need to figure a way to work around this.

    Any help on how to do this would be great.

    Thank you.
     
    netgo, Jan 21, 2010 IP
  2. abhijit

    abhijit Notable Member

    Messages:
    4,094
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    215
    #2
    you can choose different table names in one database and host many blogs
     
    abhijit, Jan 21, 2010 IP
  3. netgo

    netgo Active Member

    Messages:
    279
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    75
    #3
    Thank you - good to know it can be done.

    Where do I set the different table names?

    And how do I go about installing wordpress once I've set them?
     
    netgo, Jan 21, 2010 IP
  4. netgo

    netgo Active Member

    Messages:
    279
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    75
    #4
    Anyone? I spoke Godaddy and they said it can't be done - that I have to upgrade
    Does anyone know of a workaround ?
     
    netgo, Jan 22, 2010 IP
  5. Firegirl

    Firegirl Peon

    Messages:
    1,257
    Likes Received:
    105
    Best Answers:
    0
    Trophy Points:
    0
    #5
    It's not 25 MySQL installations, it's 25 databases. If you have 25 wordpress blogs, you would have a database for each site. Wouldn't recommend that many though because Godaddy is already a tad slow with just one.

    If you log into Godaddy you should be able to go to hosting options and find MySQL and setup another database. I usually name it something like sitename_wordpress(or joomla, or blogger, whatever), so you know which database is which. Once it's setup, you can find what the settings for it are that you need to give to wordpress to connect to the database. If you get confused, the online Godaddy help is usually pretty accurate.
     
    Firegirl, Jan 22, 2010 IP
  6. addlinkurl

    addlinkurl Well-Known Member

    Messages:
    2,409
    Likes Received:
    129
    Best Answers:
    0
    Trophy Points:
    155
    Digital Goods:
    1
    #6
    - create a database.
    - while installing wordpress, you will see something like "Table Prefix", write wp1_
    - install wp.

    if you want to install another blog,
    - while installing the new wordpress, use the same database informations. just change the "Table Prefix". for example, write wp2_

    by this way, you can use one database for more than one blogs.

    but @firegirl is right. godaddy is slow. if you have more than 1k visitors/daily, use one database for one blog.
     
    addlinkurl, Jan 22, 2010 IP
  7. netgo

    netgo Active Member

    Messages:
    279
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    75
    #7
    Thank you both - but that means that I have to install a new database which I can't because I already used all 25 right?
     
    netgo, Jan 22, 2010 IP
  8. addlinkurl

    addlinkurl Well-Known Member

    Messages:
    2,409
    Likes Received:
    129
    Best Answers:
    0
    Trophy Points:
    155
    Digital Goods:
    1
    #8
    use one of the old databases. imprtant part is "table prefix".
     
    addlinkurl, Jan 22, 2010 IP
  9. falconeye849

    falconeye849 Active Member

    Messages:
    63
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #9
    Hey netgo ,
    Install your wordpress tables within a database and change the database name in config.php file problem solved.
    if you will pay for this then PM me about your problem i will do the rest.
    Thanks
     
    falconeye849, Jan 22, 2010 IP