Mysql Command Line Interface?

[finishdish]

Greetings,

First time poster. MySQL Newbie. Glad to see such an active board. Here are the specifics of my situation. Any help/guidance would be appreciated. Thanks in advance.

 

I'm attempting to install a PHP/MySQL based "Survey Builder" See http://phpesp.sourceforge.net/

 

Included with the release code for this project are two scripts:

1. mysql_create.sql - creates the database

2. mysql_populate.sql - populates the databse

 

Per the instructions I'm being told to run the following commands via "mysql CLI"...

$ mysql -u root -p < scripts/db/mysql_create.sql

$ mysql -u root -p phpesp < scripts/db/mysql_populate.sql

 

Those scripts should get the project off the ground.

 

However I don't think it's possible to Telnet into the TotalChoice server, and I don't know any other method for executing these scripts. I managed to manually create the database (and db user) via the cpanel before crashing directly into a Dead End sign.

 

Hence this post. I'm a bit of a newbie to this, so be kind Cookies for everyone!

 

Regards,

Joe K.

 

BTW Attached are the install instructions if interested.

INSTALL.txt

[TCH-Dick]

Since you have already created the database, you only need to use the file mysql_populate.sql.

 

Access phpMyAdmin via cPanel.

Select the database from the pulldown menu on the left of page.

Select the SQL tab at top of page.

Select Browse button and navigate to mysql_populate.sql on your PC and then select GO.

Your database should now be populated.

[TCH-Bruce]

Welcome to the family, Joe!

[TCH-Don]

Welcome to the Family Joe!

 

and your new home!

 

We really are like family here.

So if you need anything,

just ask your new family!

We love to help

[DarqFlare]

Welcome Joe! Hope you get things worked out!

 

No, we don't offer any command-line-level interface here at TCH.

[finishdish]

Thank TCH Crew,

Dick's response answered my question exactly. Very nice. It was also nice to hear from the other members of the family

 

So...I created the database manually, then populated it using the supplied script. Everything looks great. However (yes, sadly there is a however), PHP_ESP is not recognizing the username and password of the DB user.

 

When accessing the Survey Program, I'm prompted to enter a Username and Password. As I understand the documentation, this is the U&P of the DB we created earlier (thanks again Dick). It would seem that after first logging in, the user (me/the DB user) would then begin configuring the program. Wah-hoo.

 

I've entered username and password information in only two places...the DB via the CPanel, and in the config file of the program (per the instructions). The fact it's asking me for a U&P at this point is reassuring, however something else remains.

 

If one item is glaringly a red flag, it would have to be the glaring red "dBase: No" being output to the PHP_ESP Test Page. Any guidance would once again be appreciated

 

Almost there. Thanks.

 

Joe

[TCH-Dick]

I sent you a PM, should take care of the problem

Edited May 20, 2004 by TCH-Dick

[finishdish]

Thanks again. That was the idiot check I needed

 

- Joe

[TCH-Dick]

No problem, Thumbs Up Glad you got it working.