南特：指示MySQL创建数据库和运行脚本 [英] Nant: instruct MySql to create db and run scripts

问题描述

我如何指导南特告诉MySQL来运行特定的位置DDL脚本，然后再运行其他脚本的指示？

How do I instruct Nant to tell MySql to run ddl scripts from a particular location and then run other scripts as instructed?

谷歌让我来许多网站不幸的是不工作。 ..

Google let me to many sites which unfortunately do not work...

推荐答案

我用一个恶性脚本来重新创建存储在程序文件夹中的文件MySQL的存储过程。我南特的目标是这样的：

I use a nant script to recreate mysql stored procedures from files stored on a "procedures" folder. My Nant target looks like:

<target name="migrate-storeds" description="Creates stored procedures">
    <echo message="Creating Stored Procedures"/>
    <foreach item="File" property="filename">
    <in>
        <items>
            <include name="procedures\*.sql"></include>
        </items>
    </in>
    <do>
        <echo message="filename ${filename}"/>
        <exec program="${mysql.path}\mysql"
            workingdir="."
            failonerror="true"
            commandline='--host=${database.server} --user=${database.user} --password=${database.pwd} ${database.name} -e "source ${filename}"'/>
    </do>
    </foreach>
    <echo message="Procedures created succesfully"/>
</target>

这篇关于南特：指示MySQL创建数据库和运行脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！