I keep getting database error displaying alot on this site.

I know, I keep on nagging our host!!! we may have to move hosting.....

Best to get a dedicated server they are really cheap now, such as:

2.8 GHz Pentium 4
80GB Drive
1 GB RAM
1200GB Bandwidth
Private VLAN - 8 IPs (5 usable)
RHE / Windows / FreeBSD
$0 setup / $99 monthly

Yes I may just do that, moving is annoying though....but the site does need it.

Will it be easy enough to transfer the forum database, so that we won't lost all posts?

Very easy, there is a function in WHM for transfering complete sites with all databases etc..Takes a second.

Whats WHM?

Web host manager, Cpanel most and nearly all hosts have it, unless you have plesk.

OK, thanks

Its getting really bad now!