I moved the entire directory of a working PN installation to a new server (domain is the same-changed hosting). The web address where the PH installation should be displays the error: "Problem in Database Connection". The URL and directories are the same as the prior installation, and the DNS change has propagated.
I guess it's time to learn more about SQL databases. I had assumed that the "Phoenix-.0.7.2.6.sql" contained in the default installation was all that was needed, and could travel with the the other files and connection remain intact.
I'd really like to know how to accomplish an intact PN move from server to server. Any help would be most welcome.
Login
Donate to Zikula
Installation, Configuration, & Upgrades
::
"Problem in Database Connection" after move...
-
- rank: Freshman
- registered: March 2004
- last visit: 22.04.04
- Posts: 15
-
Posted: 10.04.2004, 02:37
-
- rank: Freshman
- registered: March 2004
- last visit: 08.04.04
- Posts: 5
-
Posted: 10.04.2004, 07:40
You have to use phpMyAdmin to export the DB from your original site to a file .. then import it into the new site's DB. -
- rank: Freshman
- registered: March 2004
- last visit: 22.04.04
- Posts: 15
-
Posted: 10.04.2004, 07:56
(follow up)
Since entering the above post, among other things, I've run PSAK, which predictably returned "Access denied for user" followed by a substitute username and password which were duly pasted into config.php.
Here is the part I'm just not understanding.... (it's the same situation experienced a week ago when I first tried to install a fresh installation of PN from the set of unzipped files, finally turning to Fantastico and letting it do things automatically, hence not knowing the user and password it chose).... No matter what databases I create in CPANEL, or how many variations of usernames, passwords, and Phoenix SQL I attempt to create or link, the result is the same. No database connection, access denied.
Yes, I've read the FAQ, searched the forums, and double-checked the "encoded" setting in the config file. I've re-uploaded the "install" folder and PHP and ran the install (for upgrade). Same result.
I know there's a solution somewhere. Probably done every day. And since I know that the server I'm using now is temporary this will have to be done again soon.
Please help if you can. -
- rank: Freshman
- registered: March 2004
- last visit: 22.04.04
- Posts: 15
-
Posted: 10.04.2004, 08:03
Ooops. Looks like I was typing while you were providing this solution to the problem.
Thank you very much. Looks like I just learned a hard lesson: Never give up access to your previous server before your next installation is complete. Looks like I'll be installing from scratch.
Thanks again. -
- rank: Freshman
- registered: March 2004
- last visit: 22.04.04
- Posts: 15
-
Posted: 10.04.2004, 08:07
...by the way...
Is the method described above the best way to BACKUP a database?
(My confusion seems to be about the "phoenix-SQL" directory and the "Phoenix-0.7.2.6.sql" file it contains. I've been assuming that this constitutes the entire database, which is why I thought it could simply be copied along with the rest of the files and transplanted.) -
- rank: Freshman
- registered: March 2004
- last visit: 22.04.04
- Posts: 15
-
Posted: 10.04.2004, 08:39
Quote
Here is the part I'm just not understanding.... (it's the same situation experienced a week ago when I first tried to install a fresh installation of PN from the set of unzipped files, finally turning to Fantastico and letting it do things automatically, hence not knowing the user and password it chose).... No matter what databases I create in CPANEL, or how many variations of usernames, passwords, and Phoenix SQL I attempt to create or link, the result is the same. No database connection, access denied.
So, I'm back in the same circle. Installing from scratch from the unzipped files, only this time with no access to Fantastico. Same result. Same problem. As before, won't even work using defaults.
My question is this: What is the relationship between the database I've created with cpanel and the PN installation? I can't seem to see how to tie them together. Even if I check the box for the installer to create a DB, it still returns access denied. Even using the same DB name, username and password I create in cpanel, or the ones I fill into the installation form.
I truly would like to understand this. -
- rank: Legend
- registered: December 1969
- Posts: 6596
-
Posted: 10.04.2004, 09:05
To install on a CPanel server, which is what you have do the following:
1. Log in to your CPanel (I'm assuming you're at least still on CPanel, just not one with the, IMHO worthless Fantastico).
2. Go to your MySQL page, hard to say what it will say exactly as different CPanel themes call it different ly,
3. Create a database, your CPanel username will be added to the name, so if your CPanel user name is jondoe and you create the database PostNuke, it will become jondoe_postnuke.
4. Create a database user, like the database, the CPanel user name will be added to the username in the same manner.
5. Assign the user you create to your database.
6. Now go to the install.php script in your browser and when you get to the database info part of the install, put in the information from the previous steps. Remember, the CPanel User is part of the database and user names, not your password however.
7. Do NOT tick the box that says "Create Database" that isn't refering to the tables needed for PostNuke, but rather the database itself, this is what you did via CPanel.
Complete the install, and log in with the Admin name and password you set up.
