Newbie needs help with PHP-Nuke setup

[kermit]

Sorry for what I'm certain will be a no-brainer for most but PHP-Nuke says to create the database with mysqladmin (which I did) and then
"mysql nuke<nuke.sql" which isn't obvious from the mysqladmin applet. I tried coming in the front door with putty but from the directory containing nuke.sql I get the "Error 1045:Access denied user..."

I would guess that security has been set to prevent ham handed programmers like me from bunging up the works. If we need to be building from the mysqladmin applet (from within the Control Panel) how do we redirect output from a file?

Thanks

[steven]

Try this
1) Delete your database via the CP
2) Create nuke database via the CP
3) Modify your config.php file to reflect the username, password, and databasename.
4) upload your sql file via telnet
5) Have fun

If you have any other questions, let me know.

[kermit]

Hi Steven

The Database was created and the username assigned from inside the Control Panel. I have not attempted to do anything beyond copy the table structure from the file nuke.sql to my database via the command the install instructions indicated.
"mysql nuke<nuke.sql"
The nuke.sql file was part of the tarball and so is on the site already. My problem is using the unix command above when HR obviously has set security that prevents this type of entry. They obviously want me to make all my changes from within mysqladmin. mysqladmin only permits a few entries and the redirection doesn't seem to be one of them.

Thanks

[steven]

try to use the following command in telnet
mysql -ppassword database_name < nuke.sql

replace password with the password setup with the mysql database and replace database_name with the name of your database. That should set up your tables in your nuke database up correctly. If you still are having problems after that, shoot a pm to me with the login details of your site and I will set everything up for you in 5 minutes. What version ar you trying to install?

[jetsetter]

You could try this:

1. Go into phpMyadmin though CP
2. Click on your database in the left frame
3. In the right frame look for the part that says

"Run SQL query/queries on database

or Location of the textfile:"

4. Put the path to the nuke.sql file in the Location of file field.
5. Hit the Go button and wait.

That's all.

Good Luck. Joe

[kermit]

Thanks both of you but no cigar......yet

mysql -xxx derek_gen0501 < nuke.sql
(where xxx would be my password) yielded

invalid option -- x

using the syntax prompt I reentered

mysql -p[xxx] derek_gen0501 < nuke.sql

Error 1045: Access denied user: "derek@localhost" (using password : YES)
------

trying the CP like jetsetter had suggested was eqally dismal..

at the appropriate box, I typed

"/home/derek/public_html/phpscripts/nuke/sql/nuke.sql"

"your SQL-Query has been executed successfully
No tables found in database"

and when I choose "view dump (schema) of database"
it confirms there are
"no tables found in database"
------
I'll be tied up till late Sat/early Sun but I will check back.

Thanks

[jetsetter]

Originally posted by kermit
trying the CP like jetsetter had suggested was eqally dismal..

at the appropriate box, I typed

"/home/derek/public_html/phpscripts/nuke/sql/nuke.sql"

[/b]

In the box put your local drive path not your network path i.e c:\temp\nuke.sql

Joe

[eric418]

mysql -xxx derek_gen0501 < nuke.sql -p

which it'll ask for password. just add "-p" at the end

[petesmc]

mysql -u username derek_gen0501 < nuke.sql -p

that may also work

[kermit]

Thanks everyone and the problem has been solved.

eric418 had suggested
"mysql -xxx derek_gen0501 < nuke.sql -p"
the -xxx was where I had been entering my password.
I removed it and
"mysql derek_gen0501 <nuke.sql -p"
did the trick. Now let's see if I can finish it on my own.

Thanks again to everyone who contributed.