Hi,

I'm trying to export a MySQL database using DdlUtils. I went through a tutorial (http://db.apache.org/derby/integrate/db_ddlutils.html) that showed how to export a derby DB and I'm trying to modify the build.xml file to do the same thing for a MySQL database on my local machine. The build.xml file is copied below.

When I run "ant export-source-db", I get the following error:

BUILD FAILED
build.xml:16: Could not read the schema from the specified database: Could not get a connection from the datasource

I have no doubt that my line 16 is wrong, but I cannot find any information about the correct format for connecting to a MySQL database. The full path to the database on my machine is /usr/local/ mysql/data/vcctl_user

Other information: My mysql server is definitely running on the machine, and the vcctl_user database can be accessed from within mysql from the command line (show tables, etc.).

Thanks in advance for any help about how I can properly connect to MySQL database.

<?xml version="1.0"?>
<project name="MigrateToDerby" basedir=".">

   <path id="classpath">
      <fileset dir="./lib">
         <include name="**/*.jar"/>
      </fileset>
   </path>

<target name="export-source-db" description="Dumps db structure and data">
      <taskdef name="databaseToDdl"
              classname="org.apache.ddlutils.task.DatabaseToDdlTask">
         <classpath refid="classpath"/>
      </taskdef>

      <databaseToDdl modelName="MigrateTest">
          <database url="jdbc:mysql://localhost:3306/vcctl_user"
                 driverClassName="com.mysql.jdbc.Driver"
                 username="root"
                 password="vcctl7"/>

         <writeSchemaToFile outputFile="db-schema.xml"/>
         <writeDataToFile outputFile="data.xml"/>
      </databaseToDdl>

   </target>
</project>

Reply via email to