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??
10MB HA! Get one FREE for 1 year in my signature - comes with 10 MySQL Databases (1 GB each), 10GB disk space, unlimited transfer...
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.
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.
"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.