南特:指示MySQL创建数据库和运行脚本 [英] Nant: instruct MySql to create db and run scripts
本文介绍了南特:指示MySQL创建数据库和运行脚本的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我如何指导南特告诉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屋!
查看全文