mysql5 upgrade

[Guest vivid]

hi guys

My host has upgraded from mysql4 to mysql5 ive done the database conversion but cant file the file in cubecart to change to point to the new db.

Local (web applications): Host: localhost | Socket: /tmp/mysql.sock

is what im looking for because according to my host supprt i need to change this to

Local (web applications): Host: localhost | Socket: /tmp/mysql5.sock

any ideas thanks in advance

[Guest vivid]

any ideas surely this is an easy one for you guys

[rowdyplace]

yoursite/includes/global.inc.php is THE file that has the database linkage in it.

[Guest vivid]

this is my global file what perameters do i change ?? mysql.sock to mysql5.sock

<?php

$glob['dbdatabase'] = 'testaccount';

$glob['dbhost'] = 'localhost';

$glob['dbpassword'] = 'password';

$glob['dbprefix'] = '';

$glob['dbusername'] = 'testaccount';

$glob['installed'] = '1';

$glob['rootDir'] = '/home/vividwholesale/www/test';

$glob['rootRel'] = '/';

$glob['storeURL'] = 'http://test.vividwholesale.com.au';

?>

[rowdyplace]

When I setup my database,

My database file is "ccrt1"

my server hosting account name is "bamabar"

Note that the database name has the site name appended to it when I set up the database in CPanel's MySQL manager. "bamabar_ccrt1"

My global.inc.php file:

$glob['dbdatabase' ] = 'bamabar_ccrt1' ;

$glob['dbhost' ] = 'localhost' ;

$glob['dbusername' ] = 'bamabar_ccrt1' ;

$glob['dbpassword' ] = 'aabbccddd' ;

$glob['dbprefix' ] = '' ;

$glob['installed' ] = '1' ;

$glob['rootDir' ] = '/home/bamabar/public_html/cart' ;

$glob['rootRel' ] = '/cart/' ;

$glob['storeURL' ] = 'http://bamabar.com/cart' ;

I'm thinking that you need the correct database and user names (with the appended site name...) in your global.inc.php file.

I hope I'm not sending you down the wrong path...

[Guest vivid]

any help is appreciated ill look into it

[Guest vivid]

mmm? i dont think this is the solution I have 2 other databases with cube working on them and they are exactly the same as this on and they work ok. This is my test account. What my host has done is upgrade their sql database from 4 to 5 with both running side by side( so my other two stores are on 4 and still running ok) what I believe i need to do is change this sock /tmp/mysql.sock to /tmp/mysql5.sock file since there are 2 DB so cube knows which one to access as i think it defaults to mysql.sock.

Thanx rowdy for your response, maybe you r on the right track but my eyes are blind and i cant see the answer!!

[Guest vivid]

ok got the answer from my host support

<?php

$glob['dbdatabase'] = 'testaccount';

$glob['dbhost'] = 'localhost';

DELETE ABOVE LINE AND REPLACE WITH BELOW LINE

$glob['dbhost'] = 'localhost:/tmp/mysql5.sock';

$glob['dbpassword'] = '2561mb';

$glob['dbprefix'] = '';

$glob['dbusername'] = 'vividwholesale';

$glob['installed'] = '1';

$glob['rootDir'] = '/home/vividwholesale/www/test';

$glob['rootRel'] = '/';

$glob['storeURL'] = 'http://www.test.vividwholesale.com.au';

?>