Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: mySQL error?  (Read 2981 times)

0 Members and 1 Guest are viewing this topic.

Uzma

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
mySQL error?
« on: May 28, 2011, 04:42:45 pm »

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

Quote
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

Logged

RaptorUK

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 45
    • F1 Album
Re: mySQL error?
« Reply #1 on: May 28, 2011, 06:07:23 pm »

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 . . .
Logged

Uzma

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: mySQL error?
« Reply #2 on: May 29, 2011, 10:09:42 pm »

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.
Logged

lurkalot

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 933
  • +Tinyportal Support team.
Re: mySQL error?
« Reply #3 on: May 30, 2011, 01:30:12 pm »

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.
Logged
Running SMF 2.0.15  / Tinyportal 1.6.4, bridged with Coppermine 1.6.06, plus cpmfetch 2.0.0

Uzma

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: mySQL error?
« Reply #4 on: May 30, 2011, 04:35:38 pm »

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.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: mySQL error?
« Reply #5 on: May 31, 2011, 12:31:38 pm »

Logged
Pages: [1]   Go Up
 

Page created in 0.073 seconds with 19 queries.