mySQL error?

[Uzma]

Hello,
I just moved my gallery from one host to another. I'm getting the following error:

Coppermine critical error:
Unable to connect to database !

MySQL said: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)

I've tried to find this mysql.sock file but it's nowhere to be found. Can someone help me? Thanks in advance.

The link to the site is: http://ramkapoorrocks.com/gallery

[RaptorUK]

Hello,
I just moved my gallery from one host to another.

It would probably help if you explained what steps you took to move your gallery to a new host.  For example if you just copied the files across then it won't work . . .

[Uzma]

I backed up the database, all the files in the directories. Uploaded the files to the new server/domain, restored the database, changed the config file to match the new database info (username and password). I had done the same once before to move the gallery (different site) and it had worked perfectly without any issues.

[lurkalot]

I backed up the database, all the files in the directories. Uploaded the files to the new server/domain, restored the database, changed the config file to match the new database info (username and password). I had done the same once before to move the gallery (different site) and it had worked perfectly without any issues.

Normally you would use the export function in phpmyadmin to export the old database, then create a new empty database on the new server. (make sure config.inc.php file is set to it)   Then import that data to the new database, using phpmyadin import function.

[Uzma]

Yes, that's exactly what I did. Exported, then imported.

I've just never gotten this sort of an error before. there's no mysql.sock file anywhere.

[Αndré]

Double post Question already answered here: http://forum.coppermine-gallery.net/index.php/topic,72576.msg350602.html#msg350602