How to import a dump to MySql with ANT?

Have you considered piping it into the regular mysql client executable?

mysql -u root -pmy_pass howto < howto.sql

proev:

mysql -u root -pmy_pass < howto.sql

I will try it at home!
Exciting!!

Btw is mysqlimport only for comma separated files? Then I guess the mapping is one file for each table?

Best regards
Fredrik

Yes (with flexibility for delimiters though).

Hello Arne!

I tried "mysql -u root -pmy_pass howto < D:\how
to5.sql" from command line.

But when I try it like this from ANT:
    <target description="Import the database howto" name="import">
        <exec executable="mysql">
          <arg line="-u root -pmy_pass howto < D:\howto5.sql"/>
        </exec>
    </target>

I get:
D:\ant\build.xml:56: The value of attribute
"line" associated with an element type "arg" must not contain the '<' character.

Do you have any idea how to solve this?

I have also tried:
<arg line="-u root -pmy_pass howto --local-infile D:\howto5.sql"/>
<arg line="-u root -pmy_pass howto &lt; D:\howto5.sql"/>

Tricky.

Best regards
Fredrik

Try:

cmd /c mysql ... < ...

I just checked the ant documentation, and according to that, it should be like this:

        <exec executable="mysql" input="D:\howto5.sql">
          <arg line="-u root -pmy_pass howto"/>
        </exec>

You need Ant 1.6 or later. (see http://ant.apache.org/manual/CoreTasks/exec.html)

Or try specify the file as input attribute to the exec tag.

Hello guys!
I tried the cmd version as well but I got the same error.
But the:
        <exec executable="mysql" input="D:\howto5.sql">
          <arg line="-u root -pmy_pass howto"/>
        </exec>
...really did the trick!

Please bothof you give answers so I an reward you!
Again, thanks alot!!!
Best regards
Fredrik

You're welcome :)

Give the points to pidgeot - he was first with the answer.