How can I reduce my database usage in shared hosting???

Discussion in 'Site & Server Administration' started by sphinx498, Jun 23, 2012.

  1. #1
    I have opened account with manashosting.co.in( a real s$$t hosting service provider)

    they have set my database limit to be 10 MB and my database size is now 32 MB.They say that I have exceeded the limit and hence I cant create any new database for my another domain which I purchased few days back.What should I do???

    Isnt it bullying like when every hosting service provider gives nowadays at least 1 GB database space, these guys provide only 10 MB space in their unlimited plan...

    How can i reduce the database usage??
     
    sphinx498, Jun 23, 2012 IP
  2. atxsurf

    atxsurf Peon

    Messages:
    2,394
    Likes Received:
    21
    Best Answers:
    1
    Trophy Points:
    0
    #2
    10MB HA! Get one FREE for 1 year in my signature - comes with 10 MySQL Databases (1 GB each), 10GB disk space, unlimited transfer...
     
    atxsurf, Jun 23, 2012 IP
  3. InnovusHost

    InnovusHost Peon

    Messages:
    136
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Have you run optimize on your databases? They might be some data stored that would be discarded through optimize. However, 10mb is very small for any database and you'd probably be better off finding a new host altogether.
     
    InnovusHost, Jun 23, 2012 IP
  4. SolidShellSecurity

    SolidShellSecurity Banned

    Messages:
    262
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    45
    #4
    Whats in the DB? Is there stuff you can delete?
     
    SolidShellSecurity, Jun 23, 2012 IP
  5. sphinx498

    sphinx498 Member

    Messages:
    86
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    43
    #5
    I did select optimize but it didnt reduce any data....
     
    sphinx498, Jun 23, 2012 IP
  6. sphinx498

    sphinx498 Member

    Messages:
    86
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    43
    #6
    There are 512 tables in it and the data is I think as I came to know has all log details or member details of the people joining my website.I dont know which I can delete and which I cant.
     
    sphinx498, Jun 23, 2012 IP
  7. atxsurf

    atxsurf Peon

    Messages:
    2,394
    Likes Received:
    21
    Best Answers:
    1
    Trophy Points:
    0
    #7
    "optimize" optimizes for speed, not the size. if you really think it is possible to run out 10MB database, think of data you could move out of there. Such as if you store pictures/avatars in the database binary fields, store them in the files instead and store only their filenames in the database.
     
    atxsurf, Jun 23, 2012 IP