Re: [NAnt-users] Executing a mysql script inside Nant

[r0lan2]

Thanks for your help, 
I tried theses options but it doesn't work :( 


First option:
<exec program="mysql" append="True" verbose="True" commandline="-h localhost
-u root -pholamundo">
        <arg value="CreateDataBase.sql" />
    </exec>
    <exec program="mysql" append="True" verbose="True" commandline="-h
localhost -u root -pholamundo" >
      <arg value="Populatelookups.sql" />     
    </exec>

Second option:
<exec program="mysql">
      <arg line="-h localhost"/>
      <arg line="-u root"/>
      <arg line="-pholamundo &lt; CreateDataBase.sql"/>        
    </exec>

Third option:
<exec program="mysql" append="True" verbose="True" commandline="-h localhost
-u root -pholamundo &lt; CreateDataBase.sql"/>
    <exec program="mysql" append="True" verbose="True" commandline="-h
localhost -u root -pholamundo &lt; Populatelookups.sql" />
    

another question: What is the correct way to write spcial character like '<'
'>' ?

Thanks a lot!!!




r0lan2 wrote:
> 
> Hi,
> I'm trying install a  Mysql database using nant, this is a part of my
> build file:
> <target name="CreateStructure" description="Creating Database" >
>     <exec program="mysql" append="True" verbose="True" commandline="-h
> localhost -u root -pholamundo">
>         <arg value="CreateDataBase.sql" />
>     </exec>
>     <exec program="mysql" append="True" verbose="True"
>               commandline="-h localhost -u root -pholamundo -e source " >
>       <arg value="Populatelookups.sql" />     
>     </exec> 
>   </target>
> 
> My problem is with: How to put the name of the script to execute ??
> 
> 
> Really, I want execute a command like this:
> 
> mysql -h localhost -u root -pholamundo < Script1.sql
> 
> 
> 
> any commnet or help =) ?
> 
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Executing-a-mysql-script-inside-Nant-tp16256023p16257374.html
Sent from the NAnt - Users mailing list archive at Nabble.com.


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
NAnt-users mailing list
NAnt-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nant-users