Kannan Ekanath wrote:
Hi,
ANT - 1.6.5
I am trying to execute the following command line from ANT
"D:\>mysql -u root -pwelcome --database=warranty <
target/create-schema.sql"
Basically the create-schema sql file has to be loaded using mysql
command. I
understand that there is a problem with "<" symbol in ant command line as
mentioned in http://ant.apache.org/faq.html#shell-redirect-1, Hence I
tried,
<target name="execute.schema.script.cmd">
<echo message="Executing schema script..." />
<exec executable="mysql">
<arg line="--user=root --password=welcome --database=wararnty
< target/create-schema.sql" />
</exec>
</target>
This dint do the job and gave me mysql usage information. Then I tried the
"-c" option that is specified in the link (Guess this is available only
with
SHELL?)
<target name="execute.schema.script.cmd">
<echo message="Executing schema script..." />
<exec executable="mysql">
<arg line='-c "--user=root --password=welcome
--database=wararnty < target/create-schema.sql"' />
</exec>
</target>
This gave me a mysql unknown option "-c".
I think there is some confusion here.
1. Redirects are a shell function. You cannot exec anything other than
bash, csh, zsh, tcsh or cmd.exe and expect them to understand redirects.
2. the faq example explicitly shows how to run a shell, because that is
exactly what you should be doing.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
