ScoobyNet.com - Subaru Enthusiast Forum

ScoobyNet.com - Subaru Enthusiast Forum (https://www.scoobynet.com/)
-   Computer & Technology Related (https://www.scoobynet.com/computer-and-technology-related-34/)
-   -   MySQL Help PLEASE!!!!! (https://www.scoobynet.com/computer-and-technology-related-34/259140-mysql-help-please.html)

marxsmann 11 October 2003 03:56 PM

Hi,

I've got a hosting business account with www.oneandone.co.uk.

I'm trying to install postnuke onto my domain.

The instructions say:

1) Create a database called, for example, nuke:

mysqladmin create nuke

2) Now fill the databases with the tables in nuke.sql file:

mysql nuke < nuke.sql

Well i can't seem to name my database - it is already named for me. So i guess that'll do. But how do i do number 2? I know nothing about mysql/php etc etc. Any ideas??

Marc

chiark 11 October 2003 04:05 PM

learn sql otherwise you'll get nowhere ;)

seriously, you need to write a script that creates your tables. Loads of on-line help sites for SQL...

marxsmann 11 October 2003 04:08 PM

hmmmmm.....well the instructions don't mention having to do that:

Installing the Package
----------------------

Untar the package into the directory you want to use on you web
server, if you're unsure where that is, ask you system administrator.
(Windows users can use WinZip or WinRAR to uncompress .tar.gz files)

tar -zxvf PHP-Nuke.tar.gz

Now go to the directory where you uncompressed all files and edit the
file "config.php". Change all the fields until you are happy with the
changes and they fits the need of your web site. Give special attention
to the database configuration section. When you have finished to edit
config.php file change to the /sql/ directory and there is a file called
"nuke.sql" this file contains the commands to build the database structure,
tables and the default data.

1) Create a database called, for example, nuke:

mysqladmin create nuke

2) Now fill the databases with the tables in nuke.sql file:

mysql nuke < nuke.sql

3) In order to use the ultramode.txt news file please be sure to chmod 666.
This file is used to show news from your site in some old programs and
frontends and is reserved to future use in PHP-Nuke. For backend use
backend.php file instead.

4) That's it!... now you need to edit the file "config.php" to set the
database options. Please read carefully the instruction on that file!
After that, point your browser to:

http://yourdomain.com/admin.php

We use MySQL as the example and nuke.sql file is in MySQL format
because PHP-Nuke was made using this database server. You can find
many programs out there to convert the database schema from MySQL to
whatever else you want. But this is a task for you.

IanW 11 October 2003 04:51 PM

You should have a MYSQL client or something similar in your control panel, if not you will have to use Shell access to run the script.

IanW 11 October 2003 04:55 PM

just had a quck look at the oneandone website, and it looks to me like you ahve 2 otions really, use Shell Access to run the script, or install and use something like PHPMyAdmin.


All times are GMT +1. The time now is 06:55 AM.


© 2024 MH Sub I, LLC dba Internet Brands