Subject | Re: [firebird-support] Backup / Restore |
---|---|
Author | Milan Babuskov |
Post date | 2003-10-08T14:27:04Z |
Louis wrote:
destination directiory. In Firebird you have a single database file with
all tables.
only the entire database. If you only want to backup/restore data from
one of the tables, you can try (for example) to do that with fbexport
tool (see my signature at the end of file). If you want to get the same
behavior as MySQL's RESTORE_TABLE, you should issue: DELETE FROM table,
before doing import of data.
It would be good if you would write what exactly are you trying to
accomplish, so we can give you some good advice.
--
Milan Babuskov
http://fbexport.sourceforge.net
> Does FireBird have something simular to these commands?Not really. In MySQL each table has its files, which are then copied to
destination directiory. In Firebird you have a single database file with
all tables.
> http://www.mysql.com/doc/en/BACKUP_TABLE.htmlIf you want, you can backup the database while you're connected. But
> http://www.mysql.com/doc/en/RESTORE_TABLE.html
>
> I'm trying to backup/restore the database while my application is still
> connected.
only the entire database. If you only want to backup/restore data from
one of the tables, you can try (for example) to do that with fbexport
tool (see my signature at the end of file). If you want to get the same
behavior as MySQL's RESTORE_TABLE, you should issue: DELETE FROM table,
before doing import of data.
It would be good if you would write what exactly are you trying to
accomplish, so we can give you some good advice.
--
Milan Babuskov
http://fbexport.sourceforge.net