問題描述
我需要使用 ant 任務啟動和停止 mysql 5.5.
I need to start and stop mysql 5.5 using ant task.
早期的 ANT 腳本是為 hsqldb 數(shù)據(jù)庫做的，它使用的類是 org.hsqldb.Server.有人能告訴我 mysql 5.5 使用哪個類.
The earlier ANT script was doing it for hsqldb database for which the class it was using was org.hsqldb.Server. Could someone tell me which class to use for mysql 5.5.
以下是在 hsqldb 用于 mydb 的情況下使用的:<java fork="true" spawn="true" classname="org.hsqldb.Server" classpathref="build.runtime.classpath"><arg line="-database.0 file:data/mydb -dbname.0 mydb"/></java>
Following was being use in case of hsqldb for mydb:
<java fork="true" spawn="true" classname="org.hsqldb.Server" classpathref="build.runtime.classpath">
<arg line="-database.0 file:data/mydb -dbname.0 mydb"/>
</java>
我需要 mysql 5.5 的等效項.我知道連接器是用來連接mysql 5.5數(shù)據(jù)庫的，我用的是mysql-connector-java-5.1.15-bin.jar.
I need to have the eqivalant for mysql 5.5. I know a connector is used to connect to mysql 5.5 database, I use mysql-connector-java-5.1.15-bin.jar.
誰能告訴我如何使用 ant 腳本啟動和停止 mysql 數(shù)據(jù)庫.
Could someone just tell me how to start and stop mysql database using an ant script.
謝謝.
推薦答案
將 MySQL 配置為 機器啟動時自動啟動.MySQL 旨在在后臺持續(xù)運行.
It would be more normal to configure MySQL to automatically start when the machine boots. MySQL is designed to run continually in the background.
如果您真的想從 ANT 中停止和啟動 MySQL，則可以調(diào)用服務器腳本(當然，假設 MySQL 與構(gòu)建運行在同一臺機器上).
If you really want to stop and start MySQL from within ANT it's possible to invoke the server scripts (Assuming of course MySQL is running on the same machine as the build).
<target name="start-db">
<exec executable="C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" osfamily="windows">
</exec>
<exec executable="mysql.server" osfamily="unix">
<arg value="start"/>
</exec>
</target>
<target name="stop-db">
<exec executable="C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" osfamily="windows">
<arg value="-u"/>
<arg value="root"/>
<arg value="shutdown"/>
</exec>
<exec executable="mysql.server" osfamily="unix">
<arg value="stop"/>
</exec>
</target>
注意:
- 此腳本包含在 windows 和 unix 上啟動/停止的命令.
- MySQL 文檔描述了如何啟動 Mysql從 windows 命令行
這篇關于如何使用 ANT 任務啟動 MySql的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！