[phpesp-general] Population script via phpMyAdmin?

[Joseph W. <jw...@bu...>]

Hello all,



Thank you for your consideration of my newbie troubles.  I am having trouble running the population script off of phpMyAdmin.  I currently use 1&1 internet and have created a database, which has been given the name db174209121 and resides on a different server (db487.perfora.net) than where my web server is (s169227519.onlinehome.us).



My web server has a subdirectory, which I have a domain name pointed to.  In that subdirectory, I have phpESP installed to another subdirectory, called "phpESP."



Whenever I open phpMyAdmin from my server admin to run any of the following commands (to try to find the script):



$ mysql -u root -p db174209121 < s169227519.onlinehome.us/josephjwilk/phpESP/scripts/db/mysql_populate.sql

$ mysql -u root -p db174209121 < josephjwilk/phpESP/scripts/db/mysql_populate.sql

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

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



I get the following result (verbatim, except for the [insert path] which is just a copy of what I used to try and find the database):



SQL query:



$ mysql - u root - p db174209121 & lt;



phpESP / scripts / db / mysql_populate.sql



MySQL said: 



#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '$ mysql -u root -p db174209121 < [insert path]/scripts/db/mysql_popula 



I also tried installing to my web space's root, from which I tried the following commands:



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

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



with exactly the same result.



1&1 has MySQL 4 & PHP 5 installed.  It seems like I'm not even getting the install script to run in the first place.  Does anyone have any ideas for what I might be able to do to get phpESP running?  Thank you all so much for your time.



Best wishes,

Joseph Wilk