forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: ajl2chat2u on June 28, 2007, 08:50:45 am

Title: MySQL Database link
Post by: ajl2chat2u on June 28, 2007, 08:50:45 am

I somehow had a problem with logging in as admin. I did a re-install of ver 1.4 and I think I lost all the data in the database in the process. Would that be the case, if not, how to I correct this as no images are now in the album reflecting.

Thanks

Title: Re: MySQL Database link
Post by: Sami on June 28, 2007, 09:13:46 am

You shouldn't re-install CPG at first place !

- Check your mysql server if you have your old db or not
- If you don't have your old db then you should use your backup (if you don't have backup you are lost! you should re-upload all pics again)
- If you have your old db

• First you should change your old admin account's password, use phpmyadmin or similar mysql utility and open xxx_users table of old db , find the user that has 1 for user_id (this user is admin) and change it's password to 21232f297a57a5a743894a0e4a801fc3 this will set the password to admin
• Now change {gallery-root}\include\config.inc.php file and put your old db infos there

Title: Re: MySQL Database link
Post by: ajl2chat2u on July 02, 2007, 09:09:46 pm

Thanks a lot!

Old db was still there, just had to tweak the config file to point to the correct db and tables.

All cool now!