Dizkus

Does it matter whether or not I create the SQL database (via MySQL admin) before or after I actually install PN (as long as I accomplish both before trying to use it!)?

If the sequence does matter, what IS the correct sequence?

I have a PN back-up (I hope!) from a previous host that I'm trying to install on a new host (godaddy.com). I also have a back-up of the SQL dbase as well.

It's evidently not as simple as just installing the new PostNuke, changing a couple lines in the config.php file (either manually or with PSAK) and going on down the road... or, at least not so, in my case!

I have back-up of my "original" (working) PN directory (and all sub-directories). I'm also very confused on what I'm supposed to do with that data. DO I want to over-write the new install with the old? Any directories? All? None? What file(s) besides the edit to the config? Or is a virgin PN install + new SQL file (with imported data from working SQL back-up) all the "old" data that's needed?

In any case, I usually end up with 1 of 2 results:
1) An empty brandy new PN site, eagerly awaiting new stories, etc.
-Or:-
2) I get a database connection error.

Anyone have some time and patience to talk/walk me through this?! This is going on 3 days or so of me banging my head on the wall!

Thanks tons!!!

--Pete

If you have a back-up... you'd better make a database before you start to import your back-up... [where would you import it otherwise]

It seems
1) everything works fine
2) there's something wrong with your old back-up

• not the right PN version
• some folders need to be chmodded to 777

- Igor


--
Have a nice day

zikulapro.be is currently running
Zikula 1.0.2

Ok, I thought I'd "start over" with a clean slate. Blew away the old PN install and the old SQL. In this context, by "old", I mean installed last night, not last year!

I created a MySQL file. I did a new PN install. I then went to MyAdmin (for MySQL) and tried to import the data to the new database. Here's what happened:

=-=-=-=-=-=-=

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 13, 2006 at 01:38 AM
-- Server version: 4.0.25
-- PHP Version: 4.4.2
--
-- Database: `pferris_pnke1`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_autolinks`
--
CREATE TABLE IF NOT EXISTS `nuke_autolinks` (

`pn_lid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`pn_keyword` varchar( 100 ) NOT NULL default '',
`pn_title` varchar( 100 ) NOT NULL default '',
`pn_url` varchar( 200 ) NOT NULL default '',
`pn_comment` varchar( 200 ) NOT NULL default '',
PRIMARY KEY ( `pn_lid` ) ,
UNIQUE KEY `keyword` ( `pn_keyword` )
) TYPE = MYISAM AUTO_INCREMENT =1;



MySQL said:

#1046 - No Database Selected

[ Back ]

=-=-=-=-=-=-=

Great!!!! Now I'm going from bad to worse! Previously, this would import and display a bunch of "stuff" (tables? fields?) off on the left side. I even copied the same file (a .sql attachment in an e-mail my friend sent of the DB backup - the very SAME file that previously seemed to work!).

Now, suddenly, it's erroring. Arrrrgh. Suddenly I have the urge to listen to BB King and play with razor blades! Somebody stop me!!! 3 days and counting...

I'm stopping here for tonight! Maybe good news in the mail box in the morning?! Have a good night all! Thanks for all your help.

Cheers,

--Peter

The simplest way I know to do this is to:

• Install PostNuke.
  
• Delete the new database - it's empty anyhow.
  
• Restore your database backup making sure to use the same database name you used when you installed.
  

OR

• Restore your files from backup if you have 3rd party modules or other customizations.
  
• restore your database backup.
  
• Enter new config data into config.php, like database server, logon, password, etc. Make sure this corresponds with your restored database.
  

It depends on what kind of setup you used to have.

I should add that Godaddy users have had difficulty with running PostNuke, but it is possible. You might search the forum for the previosu discussions on this.

Frank



edited by: FrankDeRosa, Sep 12, 2006 - 05:33 AM

--
Serious hosting - all the features, bandwith and storage you could want without breaking the bank at DreamHost.com


See what I do with PostNuke - http://surreal-dreams.com

Moving Hosts in the Wiki

--
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide

Thanks... I thought it would be just that simple too - the first time or two. It's not, at least in my case. I DO appreciate you pointing out the document though. Unfortunately I've been through all of it several times. I may have to go through it a few more times too, before its over!

I'm glad you pointed it out - it seems helpful at first blush, but I think there could be / should be more more trouble-shooting if things don't just work out perfectly in the "1, 2, 3,4" order. It's helpful as far as it goes. Just not enough depth, IMHO. I'm behining to think I have a more serious problem than a simple case of didn't RTFM!

Just a few possible topics for future reference /inclusion: Perhaps a reference to "For more advanced troubleshooting see...", "For Database Connection Errrors see...", "For common errors importing the tables see...".

Thanks again for the suggestion,

--Pete

Hi,

Thanks!

This is the info I was looking for - I hope!



Ahaaa!!!! THANKS!!! I'll be researching the GoDaddy issues later this afternoon! I just paid for a year's worth... they seemed fine "otherwise" (famous last words, eh?!). When I called them early on in this for support - they were quick to say it's only an optional user "add in", and not directly supported by them (the end - period!).

This may put me on the right scent! At least this confirms that I'm not totally clueless. I mean I've installed PN correctly twice before (two other hosts)and never had this level of problem.

Now I'm wondering if there's something crazy with their cPanel PN install script... maybe I'm better off manually installing it. Try that soon, too!

Thanks to all that have responded. Videokid has been very patient with me, as have all of you. I appreciate it. Stay tuned!

Thanks again to everyone for all help and suggestions,

--Peter