Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

MySQL Help PLEASE!!!!!

Thread Tools
 
Search this Thread
 
Old 11 October 2003, 03:56 PM
  #1  
marxsmann
Scooby Regular
Thread Starter
 
marxsmann's Avatar
 
Join Date: Oct 2002
Posts: 281
Likes: 0
Received 0 Likes on 0 Posts
Post

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
Old 11 October 2003, 04:05 PM
  #2  
chiark
Scooby Regular
 
chiark's Avatar
 
Join Date: Jun 2000
Posts: 13,735
Likes: 0
Received 0 Likes on 0 Posts
Post

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...
Old 11 October 2003, 04:08 PM
  #3  
marxsmann
Scooby Regular
Thread Starter
 
marxsmann's Avatar
 
Join Date: Oct 2002
Posts: 281
Likes: 0
Received 0 Likes on 0 Posts
Post

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.
Old 11 October 2003, 04:51 PM
  #4  
IanW
Scooby Regular
 
IanW's Avatar
 
Join Date: Jul 2001
Posts: 21,865
Likes: 0
Received 0 Likes on 0 Posts
Post

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.
Old 11 October 2003, 04:55 PM
  #5  
IanW
Scooby Regular
 
IanW's Avatar
 
Join Date: Jul 2001
Posts: 21,865
Likes: 0
Received 0 Likes on 0 Posts
Post

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.
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Wurzel
Computer & Technology Related
2
07 May 2007 05:45 PM
g3m xr
Southern (England)
6
13 September 2006 11:38 PM
GaryK
Computer & Technology Related
2
08 December 2004 11:04 AM
SiDHEaD
Computer & Technology Related
7
03 November 2003 10:17 AM



Quick Reply: MySQL Help PLEASE!!!!!



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