Subject | Re: [firebird-support] mysql to firebird |
---|---|
Author | unordained |
Post date | 2005-09-21T20:31:32Z |
You can use isql (in the /bin/ directory of firebird's install directory) to run batch sql files.
(You can also use it interactively.)
isql /somewhere/my_database.gdb -u sysdba -p masterkey -i some_batch_file.sql
However, what mysql dumps may or may not be exactly compatible with firebird's understanding of
sql. The two have rather different abilities, and this gets expressed in the sql dumps too. You may
have to clean it up a bit before running it -- removing mysql-specific options, etc.
-Philip
---------- Original Message -----------
From: "tymorrisy" <tymorrisy@...>
(You can also use it interactively.)
isql /somewhere/my_database.gdb -u sysdba -p masterkey -i some_batch_file.sql
However, what mysql dumps may or may not be exactly compatible with firebird's understanding of
sql. The two have rather different abilities, and this gets expressed in the sql dumps too. You may
have to clean it up a bit before running it -- removing mysql-specific options, etc.
-Philip
---------- Original Message -----------
From: "tymorrisy" <tymorrisy@...>
> I have dumped a mysql db to a sql file. Is there a utility that will------- End of Original Message -------
> take that file and import it into a firebird db?