MySQL4 - MySQL5 migration woes

[Promoking]

I searched the forums and did not find relevant info so if this is a repeat I apologize.

Just created a new db using MySQL5 and migrated my previous db MySQL4 data into it. I've edited includes/config.php to refelect the new db however, vb never connects.

Are there other files that need to be modified or any other steps I need to take to access the new MySQL5 db?

Thanks!

-Brian

[punchbowl]

Can you post the error message? Can you connect to the db with phpadmin or anything else?

[Promoking]

phpMyAdmin connects fine. The error is thus:

Database error
The database has encountered a problem.

And then tells me to refresh or try again. Not much help. My collation on the new db is:

latin1_general_ci

Could that have anything to do with it?

the only changes I made to includes/config.php are:

dbname
servername
port

username and password remain the same

Ideas?

Thank you

[punchbowl]

Have a look here http://www.vbulletin.com/forum/project.php?issueid=5627

not the answer but you may be onto something re collation

[Promoking]

Hmm... lots of good info in there - thank you.

is: latin1_bin = latin1

Thanks

--------------- Added [DATE]1224687377[/DATE] at [TIME]1224687377[/TIME] ---------------

Naw that didnt work

Should be a simple thing right? BTW im using vb3.6.8 right now but plan to upgrade as soon as this db thing is fixed

System:

vb 3.6.8
MySQL client version: 5.0.45
php 4.2.1 (I think )

Steps:

1) Created a new db using mysql5 (tried various char sets "latin1_general_ci" default)
2) Migrated the existing db4 to the new one (checked with phpMyAdmin)
3) created a new user and password just to eliminate any potential conflicts
4) Updated my includes/config.php file
- dbname
- servername
- port

but I get a simple "The database has encountered a problem" error when try to access the forum.

Help?

Thank you

--------------- Added [DATE]1224690086[/DATE] at [TIME]1224690086[/TIME] ---------------

Solved....

I got this back from my hosts tech support:

" It seems that Vbulletin does not understand the "localhost:/tmp/mysql5.sock" syntax used to connect to a MySQL 5 database.

To circumvent this restriction, please edit the vBulletin configuration file (includes/config.php), and add the following line to the beginning:

ini_set('mysql.default_socket', '/tmp/mysql5.sock');

You will need to use

localhost

for the database host. "

Thanks for all your help... maybe this can benefit others in the future if they upgrade older mysql4 db's to mysql5

Cheers

-Brian

[Marco van Herwaarden]

I have never seen a host where such an edit was needed.

[Allnick]

I've had exactly the same problem at the weekend.
Unfortunately, I only found this thread after hours of frustration.

I was given the exact same code from my hosts tech support.
Just added it to the beginning of config.php, and problem solved.