Messed up my.cnf file Help me guys

[kos]

Error in my Forum When i open usercp.php only ...

Database error in vBulletin 4.1.4:

Invalid SQL:

SELECT contenttype.contenttypeid AS itemid

FROM contenttype AS contenttype
INNER JOIN package AS package
ON package.packageid = contenttype.packageid LEFT JOIN product AS product
ON product.productid = package.productid
WHERE
1 = 1 AND (product.active = '1' OR package.productid = 'vbulletin') AND contenttype.canattach = '1';

MySQL Error : Incorrect information in file: './XXXXXXXX/contenttype.frm'
Error Number : 1033
Request Date : Saturday, September 24th 2011 @ 05:22:37 PM
Error Date : Saturday, September 24th 2011 @ 05:22:37 PM
Script : http://www.XXXXXX.com/usercp.php
Referrer : http://www.XXXXXX.com/showthread.php?t=173058
IP Address : XXXXXXXXX
Username : XXXXXXXX
Classname : vB_Database
MySQL Version : 5.0.92

This is my Present my.cnf file

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 1000M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1

[mysqldump]
quick
max_allowed_packet = 2000M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[mysql.server]
user=mysql

[mysqld_safe]
open_files_limit = 8192
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"

I got this error when i am Generating backup using SSH

mysqldump: Got error: 1033: Incorrect information in file: './XXXXXX/contenttype.frm' when using LOCK TABLES

Hope some one will solve my problem . Thank you very much waiting for replay (

 

[NewEraCracker]

Which control panel are you using?

 

[kos]

Kloxo

my Vbulletin version is 4.1.4

 

[NewEraCracker]

Then you better forget any optimizations.
I dislike Kloxo, has too many issues (such as streaming backup downloads with php :facepalm: )

Get a new VPS, read some tuts in how to use ssh and install WebMin

 

[kos]

Thank you brother yeah sure i will