trying to move coppermine installation

[jadzia1182]

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

[François Keller]

did you read the doc ?
how to move a gallery

[jadzia1182]

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.

[SaWey]

Code Select Expand

MySQL said: Access denied for user 'snuglive'@'localhost' (using password: NO)"
Does this ring a bell?

Try creating a user with the right permissions.