Can't you just specify the filename without redirection? Is there a commandline option to specific the sql to execute? If not. look at the exec tasks I/O redirector.
On 6/15/07, Kannan Ekanath <[EMAIL PROTECTED]> 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". 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
-- Chris Velevitch Manager - Sydney Flash Platform Developers Group m: 0415 469 095 www.flashdev.org.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
