I am trying to move my coppermine gallery from one hosting service to another. Because of moving, my database details are different (the prefix name on the db). The database itself is moved, but Coppermine won't access it. How can I install coppermine on the new server, without losing all album settings and without having to reupload all the photos? Is there somewhere in the coding where I can change the database name? Or a way to port the current settings into a fresh installation on the new server?
Thanks
did you read the doc ?
how to move a gallery (http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#moveGallery)
Thanks for your reply, but the information you referenced would be of more use if I knew more about MySQL.
Here are the current issues...
I backed up the database on the old host via "database backup" in cpanel. I restored the database on the new host. The Gallery files, with the proper structure and permissions were uploaded. I checked the database on the new server... it contains all necessary tables (as far as I can tell). I changed the config.inc.php file to reference the new database location.
the site is http://www.snuglive.com/gallery
I'm getting new errors...
"Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 253
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 254
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 255
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 256
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 257
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 258
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 259
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 260
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 261
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 262
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 263
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 264
Notice: Undefined index: TABLE_PREFIX in /home2/snuglive/public_html/gallery/include/init.inc.php on line 265
Coppermine critical error:
Unable to connect to database !
MySQL said: Access denied for user 'snuglive'@'localhost' (using password: NO)"
I have no idea how to run queries in MySql... Any suggestions.
Thanks.
MySQL said: Access denied for user 'snuglive'@'localhost' (using password: NO)"
Does this ring a bell?
Try creating a user with the right permissions.