massive mysql failure after shared -> vps.

[tinjon]

i used to be in a shared hosting, my site grew so moved to vps hosting. being a newbie to it, i've asked my host to copy the entire shared account over to my vps. and they did.

when i was in shared, i only used to get the "max user connection" mysql error. but eversince moving to vps, i'm getting that error and i'm being bombarded with other numerous mysql errors.

i' tried stop, start, restarting the vps itself, then start, stop, restart just the mysql service. no luck. changed localhost to 127.0.0.1 in the vb config.php file. still no luck. also tried restarting mysql from cpanel whm. same result. mysql is not available for just five mintues!!

please have a look at the image to get a sense of the errors i'm getting.
i need help.!!!!

here's the image link. http://img504.imageshack.us/img504/1156/helpme3ec.png
there's like 61 emails in each!

here are some sample errors. i hope anyone can help.
i'm so worried.
(i've got like almost a thousand of them since last night).

most of them are these:

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/joubonj/public_html/forum/includes/class_core.php on line 279

MySQL Error :
Error Number :



most of them are this kind and #1 below. .

just for curiosity, i checked out the mysql.sock file size and it said "unknown" . is that normal?

(and now its not even there. just checked.)

1) mysql_connect(): Lost connection to MySQL server during query
/home/joubonj/public_html/forum/includes/class_core.php on line 279



2) Invalid SQL:

                       SELECT COUNT(*) AS count, threadid, MAX(dateline) AS lastpost
                       FROM vbpost AS post
                       WHERE post.userid = 3847 AND
                       post.visible = 1 AND
                       post.threadid IN (0,1954,2394,265,2535,2472,1864,1925,120,1887,1884,2445,1553,968,1881,1255,456,2444,692,2387,2450,635,1268)
                       GROUP BY threadid;

MySQL Error  : Lost connection to MySQL server during query
Error Number : 2013



3) Invalid SQL:

               SELECT
                       userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
                       IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
                       language.phrasegroup_global AS phrasegroup_global,
                       language.options AS lang_options,
                       language.languagecode AS lang_code,
                       language.charset AS lang_charset,
                       language.locale AS lang_locale,
                       language.imagesoverride AS lang_imagesoverride,
                       language.dateoverride AS lang_dateoverride,
                       language.timeoverride AS lang_timeoverride,
                       language.registereddateoverride AS lang_registereddateoverride,
                       language.calformat1override AS lang_calformat1override,
                       language.calformat2override AS lang_calformat2override,
                       language.logdateoverride AS lang_logdateoverride,
                       language.decimalsep AS lang_decimalsep,
                       language.thousandsep AS lang_thousandsep

               FROM vbuser AS user
               LEFT JOIN vbuserfield AS userfield ON (user.userid = userfield.userid)
               LEFT JOIN vbusertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN vblanguage AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

               WHERE user.userid = 1067;

MySQL Error  : Lost connection to MySQL server during query
Error Number : 2013



4) Invalid SQL:

                       SELECT title, data
                       FROM vbdatastore
                       WHERE title IN ('','options','bitfields','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron');



MySQL Error  : Lost connection to MySQL server during query
Error Number : 2013

and so on..

[Code Monkey]

I run fine on VPS.

I think your host screwed up. Copying everything from shared to dedicated format was probably not a good idea.

They should have set up a database there. Dumped your current data into it then had your existing site run from that database to check everything out. Then just copy files over before updating dns.

This could also just be a dns issue if the move just happened.

[Paul M]

Sounds like you need to tune up mysql, what is in your my.cnf file ?