Changed servers question...

[CrazyKZ]

I had to change servers and am now with LunarPages. They provide a quick install of CopperMine.  I had CM running before. I let Lunar do an install of CM automatically.  I still have a full backup though.

What files can I copy over or mod to us my data again?  Lunar installed v1.4.2

Lunar created a whole new database.  Can I import into that one or should I redirect it to my database (wherever that is)?

--KZ

[Stramm]

you need to upload your albums dir, you need to import your sql dump... then you're pretty much done. Eventually you have to run update.php and you should upgrade to 1.4.4

[CrazyKZ]

The server had a previous version that it installs (using Fantastico in cPanel), so I deleted it and did a new install and created a new db, uploaded the files, CHMD, ran install, now it's saying that it can't find the database I created, but I've checked it several times.  What now?

...and yes, I did add user and pw to the db.

--KZ

[Stramm]

include/config.inc.php ... add your new db settings there

[CrazyKZ]

They are correct. Still can't find db. 

--KZ

[CrazyKZ]

...I even just now did a full ftp upload again thinking that something might have been corrupted.

Attached is the screen capture of the db area.

Still no luck.

--KZ

[CrazyKZ]

OK, call me stupid.  I just saw the "add user to db" option.  I was creating the user, but didn't add it to the db.  Doh!

Now that it's running, in order to get my old data installed, what should I do?

you need to upload your albums dir, you need to import your sql dump... then you're pretty much done. Eventually you have to run update.php and you should upgrade to 1.4.4

What do you mean by "importing your sql dump"?
Will I still have the login users from before? Where is that stored?

--KZ

[Joachim Müller]

you must have created a backup of your database entries on the old server (this is what is being called a "dump"). If you haven't done so, create a dump now on your old server. If you can't access it any more, you're lost and will have to start with the empty install you currently have. Take a look at http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#BackupDatabase

[CrazyKZ]

Hmmm, I wish I had know that before changing servers first. 
Anyway I have contacted the webhost company to see what they can do; we have not cancelled the account yet at all.

I don't see in my database area where to import the dump file, I only see an import.
The instructions state: "restore the mySQL table by running the queries of the dump files you created in step 2"
I went to my db and saw the queries area, but not sure what to do next (assuming that I can get the dump file still).

--KZ

[Joachim Müller]

did you read the faq section I refered to?

[CrazyKZ]

I got into the old db
Just to make sure I'm exporting correctly...Which ones of these do I check?  I know I am not to check "add drop table".

[Joachim Müller]

the options should be fine, but you have to make sure to highlight the coppermine tables that need to be backed up.

[CrazyKZ]

OK...I've got my .sql file. I'm confused as to what to do next.

What does it mean:
"restore the mySQL table by running the queries of the dump files you created in step 2"

Do I go to the "Queries" area in the new db area?  I don't see anywhere to run or import a file.

--Ken

[Joachim Müller]

use phpMyAdmin on your new site. Refer to the phpMyAdmin docs. Use the "sql" tab

[CrazyKZ]

OK, that's where I'm at.  See attached image with how I started after installing the dump file.
BTW, the documentation is not real helpful for this one small task.  All I'm trying to do is get my gallery back up and running. 

But then it returns with the following:

SQL query:

`user_id` , `user_group` , `user_active` , `user_name` , `user_password` , `user_lastvisit` , `user_regdate` , `user_group_list` , `user_email` , `user_profile1` , `user_profile2` , `user_profile3` , `user_profile4` , `user_profile5` , `user_profile6` , `user_actkey` SELECT *
FROM `cpg143_users`
WHERE 1
LIMIT 0 , 30
MySQL said: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user_id` , `user_group` , `user_active` , `user_name` , `user_password` , `user_' at line 1

[Joachim Müller]

you're suppossed to paste your backup into the field, not click into the column on the right.

[CrazyKZ]

I see.  OK, I've deleted the db and started over...When I start with a fresh db and paste the dump, it loads sussessfully.  However, when I then go to the gallery page it simply says:  "Fatal error :", but doesn't even show any errors of why.

However, I ran the "update.php" and IT NOW WORKS.  PHew! 

Thanks for your help!

--KZ