Greetings,<br />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.<br /><br />I'm attempting to install a PHP/MySQL based "Survey Builder" See <a href="http://phpesp.sourceforge.net/" target="_blank">http://phpesp.sourceforge.net/</a><br /><br />Included with the release code for this project are two scripts:<br /><i>1. mysql_create.sql - creates the database<br />2. mysql_populate.sql - populates the databse</i><br /><br />Per the instructions I'm being told to run the following commands via "mysql CLI"...<br /><i>$ mysql -u root -p < scripts/db/mysql_create.sql<br />$ mysql -u root -p phpesp < scripts/db/mysql_populate.sql</i><br /><br />Those scripts should get the project off the ground.<br /><br />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.<br /><br />Hence this post. I'm a bit of a newbie to this, so be kind <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /> Cookies for everyone!<br /><br />Regards,<br />Joe K.<br /><br />BTW Attached are the install instructions if interested.<!--content-->
Since you have already created the database, you only need to use the file <!--coloro:blue--><span style="color:blue"><!--/coloro-->mysql_populate.sql<!--colorc--></span><!--/colorc-->.<br /><br />Access phpMyAdmin via cPanel.<br />Select the database from the pulldown menu on the left of page.<br />Select the SQL tab at top of page.<br />Select Browse button and navigate to <!--coloro:blue--><span style="color:blue"><!--/coloro-->mysql_populate.sql<!--colorc--></span><!--/colorc--> on your PC and then select GO. <br />Your database should now be populated.<!--content-->
<img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/kicking.gif" style="vertical-align:middle" emoid=":dance:" border="0" alt="kicking.gif" /> Welcome to the family, Joe! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/kicking.gif" style="vertical-align:middle" emoid=":dance:" border="0" alt="kicking.gif" /><!--content-->
<img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/kicking.gif" style="vertical-align:middle" emoid=":dance:" border="0" alt="kicking.gif" /> Welcome to the Family Joe! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/kicking.gif" style="vertical-align:middle" emoid=":dance:" border="0" alt="kicking.gif" /> <br /><br />and your new home!<br /><br />We really are like family here.<br />So if you need anything,<br />just ask your new family!<br />We love to help <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><!--content-->
Welcome Joe! Hope you get things worked out!<br /><br />No, we don't offer any command-line-level interface here at TCH.<!--content-->
Thank TCH Crew,<br />Dick's response answered my question exactly. Very nice. It was also nice to hear from the other members of the family <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><br /><br />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.<br /><br />When accessing the <a href="http://www.cmiav.com/survey/admin/manage.php" target="_blank">Survey Program</a>, 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.<br /><br />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.<br /><br />If one item is glaringly a red flag, it would have to be the glaring red "dBase: No" being output to <a href="http://www.cmiav.com/survey/admin/test.php" target="_blank">the PHP_ESP Test Page</a>. Any guidance would once again be appreciated <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><br /><br />Almost there. Thanks.<br /><br />Joe<!--content-->
I sent you a PM, should take care of the problem<!--content-->
Thanks again. That was the idiot check I needed <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/tongue.gif" style="vertical-align:middle" emoid="
" border="0" alt="tongue.gif" /><br /><br />- Joe<!--content-->
No problem, Thumbs Up Glad you got it working.<!--content-->
" border="0" alt="smile.gif" /> Cookies for everyone!<br /><br />Regards,<br />Joe K.<br /><br />BTW Attached are the install instructions if interested.<!--content-->Since you have already created the database, you only need to use the file <!--coloro:blue--><span style="color:blue"><!--/coloro-->mysql_populate.sql<!--colorc--></span><!--/colorc-->.<br /><br />Access phpMyAdmin via cPanel.<br />Select the database from the pulldown menu on the left of page.<br />Select the SQL tab at top of page.<br />Select Browse button and navigate to <!--coloro:blue--><span style="color:blue"><!--/coloro-->mysql_populate.sql<!--colorc--></span><!--/colorc--> on your PC and then select GO. <br />Your database should now be populated.<!--content-->
<img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/kicking.gif" style="vertical-align:middle" emoid=":dance:" border="0" alt="kicking.gif" /> Welcome to the family, Joe! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/kicking.gif" style="vertical-align:middle" emoid=":dance:" border="0" alt="kicking.gif" /><!--content-->
<img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/kicking.gif" style="vertical-align:middle" emoid=":dance:" border="0" alt="kicking.gif" /> Welcome to the Family Joe! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/kicking.gif" style="vertical-align:middle" emoid=":dance:" border="0" alt="kicking.gif" /> <br /><br />and your new home!<br /><br />We really are like family here.<br />So if you need anything,<br />just ask your new family!<br />We love to help <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><!--content-->Welcome Joe! Hope you get things worked out!<br /><br />No, we don't offer any command-line-level interface here at TCH.<!--content-->
Thank TCH Crew,<br />Dick's response answered my question exactly. Very nice. It was also nice to hear from the other members of the family <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><br /><br />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.<br /><br />When accessing the <a href="http://www.cmiav.com/survey/admin/manage.php" target="_blank">Survey Program</a>, 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.<br /><br />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.<br /><br />If one item is glaringly a red flag, it would have to be the glaring red "dBase: No" being output to <a href="http://www.cmiav.com/survey/admin/test.php" target="_blank">the PHP_ESP Test Page</a>. Any guidance would once again be appreciated <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><br /><br />Almost there. Thanks.<br /><br />Joe<!--content-->I sent you a PM, should take care of the problem<!--content-->
Thanks again. That was the idiot check I needed <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/tongue.gif" style="vertical-align:middle" emoid="
" border="0" alt="tongue.gif" /><br /><br />- Joe<!--content-->No problem, Thumbs Up Glad you got it working.<!--content-->