Find the attached script. I used it just for the same thing. It dumps the whole table into bunch of insert statements. It takes some time to process dabase output, and maybe there is a better way to this, but I didn't find any. Actually it works in two steps a) does "select * from table_name" using sqlcli, and b) translates the output into insert statements using streaming editor sed.
I am running the script in cygwin under windows, it should be easily portable into any unix like system. Best regards. Alexei --- Donatas Ciuksys <[EMAIL PROTECTED]> wrote: > Hello, > > I would like to know whether there is some way to > export table data (not > catalog) as SQL insert statements (not as PAGES or > CSV). > > Regards, > > Donatas Ciuksys > Vilnius University, > Department of Informatics > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! Search - Find what you�re looking for faster http://search.yahoo.com
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
