SQL Database too large

[wickedfate]

I moved attachments to the file system, and that has cleared up some of the size issue, but I am still experiencing the cache size issues where I have to truncate it every day or 2 to get rid of hundreds...

[wickedfate]

Also, in the above reply, it said I can drop search. I don't have just search, but is searchlog the same thing? I noticed that's over 100mb as well.

[wickedfate]

I have done both, a couple times now. I had to do it again today, because cache is back up to over 600mb.

[wickedfate]

Thanks. I will try that.

Also, I noticed this morning when I went to look at the database again, the cache was up to almost a gig, after truncating it yesterday. I did the same today, and...

[wickedfate]

I have dropped the tables you suggested, along with truncating the cache and cacheevent tables. Yes, this brought the database down in size.

How do I know the path to move attachments to...

[wickedfate]

I received a message from my host:
It has come to our attention that your site is using an excessive amount of MySQL resources on your Bluehost account. This is causing performance problems not...

[wickedfate]

I have opened a ticket.

[wickedfate]

Any other ideas?...

[wickedfate]

It did not work. When I upload a new style, and go to select it in the drop down, it's like it combines the 2 styles into an awful looking mess. The only way I can use it is to set it as default, then...

[wickedfate]

I have now done that, and I will try loading a new style and see if it works.

[wickedfate]

Yes it is.

[wickedfate]

When I look at my latest activity, it shows things in a random order. Could be yesterday, could be today, etc.

[wickedfate]

The only workaround I've found this is to delete all other styles, and have only 1 active on my board. Kind of defeats the purpose of multiple styles.

[wickedfate]

Sorry, I guess it would be styles, not themes.

[wickedfate]

When I try to upload a theme, it seems to upload fine, but then it "merges" with the default vb theme. Parts dont load, like the header or the background.

Is there a way to reset...

[wickedfate]

I have figured it out. I had to add [sigpic][/sigpic] to the text box for it to show.

[wickedfate]

I want it to be a signature picture, not an thumbnail attachment.

[wickedfate]

Awesome, ty!

[wickedfate]

Yes I have.

[wickedfate]

All that does for me is add a very small thumbnail attachment picture. Is there something else I have to do?