How to free up some SQL space

[Shazz]

I use 1and1 hosting...
With the gay 100 MB SQL storage
And im starting to worry that im going to run out, what would be the best way to free up some?
Ive moved my attachments to file system if that did anything...

I have arcade scores saved to the SQL database, Im not sure how much that sucks up but any ideas?

[Dismounted]

Get a new host? :D

[Shazz]

Do I have any other choices besides that ? :(

[Ziki]

Sure.Delete some members :D

[Shazz]

Sure.Delete some members :D

LOL
yea thats a nice solution, as well as prune every post and thread(blank site) :hurt:

Do custom avatars store on the SQL database as well?
I wonder what else could get off the database to free up some room like I did with attachments -.-

[peterska2]

custom avatars and profile pics are stored in the db by default although you can change them to be stored in the file system along with sig pics. Make sure you set the customavatars, customprofilepics, and signaturepics folder to 777 before changing the settings in the ACP though.

[Shazz]

custom avatars and profile pics are stored in the db by default although you can change them to be stored in the file system along with sig pics. Make sure you set the customavatars, customprofilepics, and signaturepics folder to 777 before changing the settings in the ACP though.

Doing that now, hope that makes a difference. Thanx for your input perterska :)

[khmh06]

You can del the words table but your search tool will be not work corectly

[Adrian Schneider]

empty the postparsed table and/or get a new host. 100mb is nothing :(

[Shazz]

Threads: 336, Posts: 1,003, Members: 317

Used Storage Space
9.16 MB

With attachments and avys on file system :D

[Ntfu2]

you have a while to go yet. But you should really look away from 1and1 hosting as they suck to begin with, and limiting your database size to 100mb is stupid.

[Shazz]

you have a while to go yet. But you should really look away from 1and1 hosting as they suck to begin with, and limiting your database size to 100mb is stupid.

They want money from me..
1and1 replied to me saying I should go with there dedicated which is 10x more... :hurt:

[Ntfu2]

Tell them to hit the road Shazz.

Get some real hosting, there are plenty of places that dont limit the MySQL size such as ASmallOrange, HostGator, Hostww just to name a few good ones.

[Shazz]

Tell them to hit the road Shazz.

Get some real hosting, there are plenty of places that dont limit the MySQL size such as ASmallOrange, HostGator, Hostww just to name a few good ones.

Ive always had them since day one in the internet.
Previously it was just going to be for a blog or something lol...
But for a vB is out of its league

I don't want the hassle of moving everything over to a new server :cross-eyed:

[Ntfu2]

its simple. Do they provide SSH access? If they do you can have it all moved outta there and setup on your new host in about 10 minutes :D

[Shazz]

its simple. Do they provide SSH access? If they do you can have it all moved outta there and setup on your new host in about 10 minutes :D

Errm Not that im aware of :cross-eyed:

[Ziki]

Change to hostmonster.com.I am using their hosting and it is awsome and just 5$ a month.

[Brandon Sheley]

you can limit your users PM's
when ever I've moved databases, this takes up a Lot of room.

[Shazz]

you can limit your users PM's
when ever I've moved databases, this takes up a Lot of room.

I was always thinking of PM's on the database
Especially if you have a welcome PM to every member on the board and don't have a auto prune PM for x days

[Ntfu2]

If you think its a pain to move hosts now.

Just think how much you're going to love it in the future when you're constantly deleting members, threads and other information

[Shazz]

If you think its a pain to move hosts now.

Just think how much you're going to love it in the future when you're constantly deleting members, threads and other information

MMmm true.
:hurt: