* 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.
|
