| Unable to execute a command mysql with a < symbol | Unable to execute a command mysql with a < symbol 2007-06-15 - By Kannan Ekanath
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".
Presently I am using <SQL> tag to actually create the schema, this being
JDBC indirectly takes a lot of time. I would like to reduce it. Any
suggestions?
--
Regards,
Kannan Ekanath
|
|
 |
