How to convert *.ddl to *.sql file

[vasu pampana]

Hi everbody,

I am using MySQL database server for my project but i have database file in form of *.ddl...but to run following mysql dump command, i need *.sql file...

mysql dbname -uroot -ppass < test.sql

can anyone give me an idea how to convert *.ddl file into *.sql file...then i can use it easily...I tried by saving this ddl file with sql extension...but when i run mysql dump command it failed because some of the statements in that ddl file are not supported by MySQL..some of those are

CONNECT TO RXDATABASE;

CREATE SCHEMA GENRXDB;

SET SCHEMA=GENRXDB;

Please help me in this regard



Edited 1 time(s). Last edit at 10/23/2008 05:12AM by vasu pampana.