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: I took a backup.. But now I cant restore it  (Read 3311 times)

0 Members and 1 Guest are viewing this topic.

castion

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
I took a backup.. But now I cant restore it
« on: November 23, 2007, 11:54:26 am »

I recently changed servers and took at complete backup of both site and DB..

I have now restored the DB and uploaded the files on the new server.
The trouble is that I originally installed through fantastico, so I dont know the password for the Database..

Is there any way I can change the DB user and DB name in a config file somewhere?
Logged

Nibbler

  • Guest
Re: I took a backup.. But now I cant restore it
« Reply #1 on: November 23, 2007, 12:06:12 pm »

The config file is include/config.inc.php.

Note that the username and password is not in the backup, it is part of the configuration of the new server. Make a new user and put the details in config.inc.php
Logged

castion

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: I took a backup.. But now I cant restore it
« Reply #2 on: November 23, 2007, 10:47:55 pm »

Thank you very much for your answer..

But for some reason I keep getting the same message:
--------------------------

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'den_copp1'@'localhost' (using password: YES)

------------------------------------

den_copp1 is the new user I created..

And I am pretty sure that all the info is correct in the config.inc.php file..
You wouldent have a suggestion to what might be going wrong here?
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: I took a backup.. But now I cant restore it
« Reply #3 on: November 23, 2007, 11:12:50 pm »

re check the config.inc.php and be sure to overwrite the old file.
Quote
so I dont know the password for the Database..
but you must have this information to complete the database connection info
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Nibbler

  • Guest
Re: I took a backup.. But now I cant restore it
« Reply #4 on: November 23, 2007, 11:19:51 pm »

Ask your host to verify the details for you.
Logged

castion

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: I took a backup.. But now I cant restore it
« Reply #5 on: November 25, 2007, 05:01:27 pm »

Hmm... But do I need the original password for the DB ?

Logged

Nibbler

  • Guest
Re: I took a backup.. But now I cant restore it
« Reply #6 on: November 25, 2007, 05:09:35 pm »

No - see my explanation above.
Logged

jackd

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: I took a backup.. But now I cant restore it
« Reply #7 on: November 28, 2007, 01:54:25 am »

Thank you very much for your answer..

But for some reason I keep getting the same message:
--------------------------

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'den_copp1'@'localhost' (using password: YES)

------------------------------------

den_copp1 is the new user I created..

And I am pretty sure that all the info is correct in the config.inc.php file..
You wouldent have a suggestion to what might be going wrong here?


Once you created the user den_copp1 did you give that user full permissions to the database....

If you have it go into cpanel, and click mysql databases.

From three scroll down to "Add User to Database" and add that user, with full permissions to the database, then try connecting again.
Logged
Pages: [1]   Go Up
 

Page created in 0.048 seconds with 20 queries.