At 12:54 PM 4/15/2004, hamsder wrote:

>With a small mysql db I'm used to being able to dump the schema and/or
>the data to text files which are sql statements that, if re-run, will
>recreate the database. ... I can
>then do things like edit the schema file with a text editor, reload
>the db using the edited schema file, and reload data by sourcing the
>data file.

Most modifications to the schema are done in place with ALTER statements
from ISQL, DSQL programs, or tools. If you want to create a copy of the
schema file, use
isql -x <database name>
as a command line tool. There are a number of database administration
tools, open source, share-ware, trust-ware, and purely commercial that let
you manage schema changes.

One very rarely needs to unload and reload a Firebird database

>

Regards,

Ann
www.ibphoenix.com
We have answers.