MySQL Help PLEASE!!!!!
#1
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
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
#3
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.
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.
#5
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.
Thread
Thread Starter
Forum
Replies
Last Post