moved databases to new server, new/reinstall hangs up on startup

[fitvilla]

In moving my site to a new server, and not being a database expert, I searched around for how to backup the databases on the old server and move them to the new server.

Fortunately, my old install of CPG shares a db with phpBB2, I set them up together that way because I have them bridged (sort of).  Unfortunately, CPG doesn't have a built-in database restore/backup function; fortunately, phpBB2 does.  I sucessfully backed up, downloaded, uploaded and restored the database for phpBB and thought, great, CPG will be no problem.

Wrong.

The first thing I did was to upload a fresh CPG 1.3.2 and install.  No recognition of the old database was seen.

So the next thing I did, based on what I had to do with the phpBB, was download all of the files from the old server and upload them to the new server.  I then deleted the include/lock.php file (possibly a mistake?) and proceeded with the installation.

After filling in the information on the first install page and proceeding to the next page, I get the following message:

Code:
The following errors were encountered and need to be corrected first:

mySQL Error: Table 'cpg132_albums' already exists

So now, before I venture into the totally unknown to me, and really make a mess of things and generally start spinning my wheels, I thught I'd better ask

How do I get the new install to recognize the transferred database, and can anyone tell what I did wrong?

I greatly appreciate all advice given...

The gallery is at http://www.fitvilla.com/gallery/

[kegobeer]

All you have to do when moving servers is backup and then restore the database, and copy the files over to the new server.  Then go into your database and change your ecard_more_pic_target value if it is different from the old value, and also verify your settings in config.inc.php are correct.  That's it.  You don't have to run the install process again.

[fitvilla]

Aha, ok, thank you.  I'll do those things and report back. 

[fitvilla]

OK, I didn't see anything named [ecard_more_pic_target] in either database...Can you tell me exactly where it is?

The config.inc.php file looks correct for the new server (different from the old one though - should they be identical for recognition purposes?  phpBB recognized it)...Still no dice, it didn't restore...

I know zero abotu db operations, please be patient...LOL

[donnoman]

Its a row in the config table.

You SHOULD be able to login to coppermine and fix it in the admin configuration menu.

[fitvilla]

Ok, I went into the Admin Tools section, I didn't see how to do anything specific with teh database that I understood.  So I told it to "update the database" which it did, some things it said "ok" and other things it said "already done."

No change.

So, I figured out how to get into each table and row in phpMyAdmin and looked at the ecard_more_pic_target row in the config table.  It's the same as the install on the old server.

So...Here's what I did next...

In my rooting around, I saw how to export and import each individual table.  So I exported each table and examined them.  The only thing that I found different was the name of the database.  So I corrected that name on the tables from the old server, and uploaded them to the new server, with the message "SQL query successful" or similar message, with the inserted lines highlighted in green.  I noted that the users, groups, and etc were listed in the correspondingly named tables.

Yet still, there is no change and I'm now frustrated.  I don't have any errors that appear, so things are at least working properly...

I thank you for your time and input; I sure thought that it would be easier/faster to move than it's winding up being.  I can't help but think that I'm missing something stupid.

[kegobeer]

You've got me confused.  There are no error messages, but there is no change?

This is how a typical server move goes:

1.  You export your Coppermine tables using phpMyAdmin.
2.  You move your Coppermine files from your old server to the new server.
3.  You look at config.inc.php and make any changes necessary.
4.  You create a new database on your new host, naming it exactly as you did on your old host.
5.  You import your Coppermine tables into your new database.

If you had an older version of Coppermine and you uploaded 1.3.2 instead of your original Coppermine files you need to run the update.php script after step 5.

[fitvilla]

I forgot to note that after I inserted the lines/table data via phpMyAdmin, I went back to Admin Tools and updated the database again.   Again, some items said "ok" while the majority said "already done."

kegobeer:

I performed step 1 a couple of different ways, and thought I did it most successfully the last time I did it, table by table.

Step 2, I think I did as successfully as step 1.

I did step 3, and didn't see any changes to be made.

Step 4 is a bit stickier - the new server control panel, for whatever reason, would not allow me to name the database exactly the same.

The old database was named 'usaglamourgirls_com_-_fitvilla' whereas the new server's database is named simply 'fitvilla'

I thought that I had the database restoration whipped when I did it via the control panel in phpBB2, as it has a built in "backup and restore" function, and I had phpBB2 and CPG 1.3.2 on the same database. 

So after examining the individual table dumps from phpMyAdmin, I saw where the database is named, made the appropriate change, saved it, and imported them (again via phpMyAdmin), which should have completed step 5.

I did not make a version change - I uploaded my local copy of what I had originally uploaded to the old server.

Here is the new server installation http://www.fitvilla.com/gallery/index.php the only reason that there is anything there is that I loaded it manually before venturing further into the database restoration process.

Here is the old server's installation, just for point of reference.  There is no nudity or explicit content of any kind, but fair warning, not all images may be appropriate for all environments.  http://207.44.144.48/usaglamourgirls.com/fitvilla/gallery

[Joachim Müller]

 http://www.fitvilla.com/gallery/index.php shows

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user: 'usaglamour@localhost' (Using password: YES)

, which means that you haven't applied step 3 properly - your new server probably needs other mySQL settings than the old one did. Are we talking about the same file? You need to edit http://www.fitvilla.com/gallery/include/config.inc.php, not http://www.fitvilla.com/gallery/include/config.inc.php.sample nor http://www.fitvilla.com/gallery/config.php !

Joachim

[fitvilla]

Yes, I had it borked for a moment, it's back up now. 

And yes, include/config.inc.php is what I messed with.

[Joachim Müller]

Are your issues solved then? Your new site appears to be up and running, and the pics are there.

Joachim

[fitvilla]

The issues are not really solved, as the moved tables (that are from the old server) are not being recognized.  The images that are there are because I reloaded them manually.

I've done everything that y'alls have suggested to the best of my comprehension, and it just isn't happening the way it's supposed to be.

I feel that I've spun my wheels long enough on this avenue, I need to get it fully loaded back up.  I'll take the alternate course of action that I know of.

Thank you all again for your time, suggestions, and patience.