Re: [phpesp-general] running scripts on remote host

[Jim B. <jp...@si...>]

* Christopher Adams <chr...@st...> [2005-08-18 19:22]:
> I have installed phpESP. I am now trying to run the scripts, 
> mysql_create.sql and mysql_populate.sql.
> 
> I run MYSQL on one server and the scripts live on another server.
> 
> So, from the server running MYSQL, I issued the command:
> 
> mysql -u root -p -h host.with.scripts < /www/scripts/db/mysql_create.sql
> 
> 
> I get the following message:
> 
> bash: /www/scripts/db/mysql_create.sql: No such file or directory
> 
> 
> The path to the scripts is correct, the user is root and password is 
> correct. What do I have to do to run this script on the remote host?
> -- 


Hi Christopher,

Ideally, the scripts should be on the same host as the database.

Any command given on the command line that takes input via  the
input redirect operator '<' will have to have the input file
available locally.  You could copy them to the /tmp directory
on the database host and run the command:

mysql -u root -p -h host.with.scripts phpesp < /tmp/mysql_create.sql
or 
mysql -u root -p phpesp  < /tmp/mysql_create.sql


on the database host.

That should work.


Best Regards,
Jim B.