Subject | Re: [firebird-support] data dumping |
---|---|
Author | Milan Babuskov |
Post date | 2005-02-17T18:26:56Z |
Maris Paupe wrote:
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).
- 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
> I did some reading but didn't find a way how to dump only data from aFBCopy is just for pumping i.e. copying the data. If you wish to dump
> 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 :(
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