Subject Re: [firebird-support] data dumping
Author Milan Babuskov
Maris Paupe wrote:
> I did some reading but didn't find a way how to dump only data from a
> firebird database. With isql I could dump only a database structure(DDL)
> with no data(MLD). I found some tools like fbcopy and fbexport but their
> execution terminates immediatly with no errors and with no results :(

FBCopy is just for pumping i.e. copying the data. If you wish to dump
the data to text file (or standard output), you can use FBExport. It
can dump the data as INSERT statements or comma separated values. To
dump as INSERTS (I guess you need that), use something like this:

fbexport -D /path/to/db -U sysdba -P password -F- -V tablename -Si

Or simply use the graphical variant of FBExport. It's only a few
mouse-clicks. Make sure you run "fbx-gui.exe" which has a graphical
interface, and not "fbexport.exe" which is a command-line tool (run
from MSDOS prompt, for example).

> Btw, maybe somebody have experienced such strage behavior of the fbcopy too?

I've never had some problems. Can you write:

- what version of Firebird
- what version of FBExport
- what operating system
- what exactly are you doing (which command).

The more I think about it, it looks like you didn't read the
"command-line tool" part. So, using fbx-gui.exe should solve all the
problems.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org