forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: castion on November 23, 2007, 11:54:26 am

Title: I took a backup.. But now I cant restore it
Post by: castion 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?

Title: Re: I took a backup.. But now I cant restore it
Post by: Nibbler 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

Title: Re: I took a backup.. But now I cant restore it
Post by: castion 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?

Title: Re: I took a backup.. But now I cant restore it
Post by: François Keller 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

Title: Re: I took a backup.. But now I cant restore it
Post by: Nibbler on November 23, 2007, 11:19:51 pm

Ask your host to verify the details for you.

Title: Re: I took a backup.. But now I cant restore it
Post by: castion on November 25, 2007, 05:01:27 pm

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

Title: Re: I took a backup.. But now I cant restore it
Post by: Nibbler on November 25, 2007, 05:09:35 pm

No - see my explanation above.

Title: Re: I took a backup.. But now I cant restore it
Post by: jackd on November 28, 2007, 01:54:25 am

Quote from: castion 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?

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.