Could you increase the verbosity of the task (see http://db.apache.org/ddlutils/ant/org.apache.ddlutils.task.DatabaseToDdlTask.html) to debug to get more detail logging, and post that here ?
Tom On Wed, Jan 13, 2010 at 11:20, Jeffrey W. Bullard <[email protected]> wrote: > 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> > >
