Re: FN-FORUM simple mysql problem

date posted 25th April 2001 17:01

Rob

You could try and see if the table has been created this
can be done from the command line

$>mysqlshow -p nuke

this may require the root password - which guess you
don't have.

Alternatively you can open up the (very basic MYSQL
command line client)

$> mysql -uUser -pPassword -hHost

this will give prompt
mysql>
issue the following

mysql> SHOW TABLES;

if the table exists then you need to check your next
statement

Contact me off line if you want to to have a look at your
scripts

Mark


>I'm new to mysql, so this will probably be an easy one
for you gurus.
>
>I am renting linux space with a company called
westhost, which so far have offered a good service. I
have a php/mysql portal I wish to install on it. The
scripts include the database file "nuke.sql" in an "sql"
folder which I'm led to believe is a file that expands
within the mysql database ( also called nuke) to
produce the tables.
>
>I can telnet into my account, and they've set up the
database nuke. The command I've been using to try to
make the nuke.sql expand into the nuke database is
the following:
>
>nuke < sql/nuke.sql
>
>where "sql" is a folder to the root.
>
>on return, this produces a new line, which I presume
means the command is successful, however I'm still
getting the
>
>Table 'shopmob.stories' doesn't exist
>
>message on load up of the index file
>
>any help on this would be highly appreciated!!!
>
>Regards
>
>Rob
>
>
>
>=======================================
=====================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
>Freelancers and Freelance Jobs
>http://www.freelancers.net
>
>To post to the Forum:
[EMAIL REMOVED]
>
>To unsubscribe please email:
[EMAIL REMOVED]
20freelancers
>
>If you have difficulties unsubscribing please email:
[EMAIL REMOVED]
>
>To subscribe to the digest for this list or for further
information please visit:
>http://www.freelancers.net/forum.html
>
>