MARIADB Export Rowset

[Adolfo]

Hi fivewinners

Is there a metod in Mariadb to export a row set to a txt file.
Just like Tdolphin with...

oQry:=cSvr:Query("select * from datos")
oExp:=oQry:Export( EXP_TEXT, "C:\XXXXX\EXPORT" )
oExp:Start()
oExp:Close()

or something like that.

Thanks in advance

[nageswaragunupudi]

Please try

Code: Select all | Expand

cText := oCn:SqlToText( cSql )
MEMOWRIT( cFile, cText )
 

[Adolfo]

Thanks..
Works great...

[MOISES]

Mr. Rao,

Can we please have this SqlToText for ADO?

Thank you

[nageswaragunupudi]

Please try

Code: Select all | Expand

cText := ""
AEval( RsGetRows( oRs ), { |a| cText += ( FW_ArrayAsList( a, Chr(9) ) + CRLF ) } )
MEMOWRIT( cFile, cText )
 

[MOISES]

Yes, it works correctly, it exports the rows.

But what I would really need would be the backup() method for ADO, to save in a txt file the content of the database in SQL mode INSERT INTO CITIES( CODE, CITY ) VALUES ( "1", "Madrid") ...

Would it be possible please?

[MOISES]

Hi,

Is there any progress?

Thank you. Best regards

[nageswaragunupudi]

For small and medium size tables, please try:

Code: Select all | Expand

   //BACKUP
   MEMOWRIT( cBackupFile, FW_ValToExp( RsGetRows( oRs ) ) )


   // RESTORE

   //1. Create the new table with same column specs and same column order

   aData := &( MEMOREAD( cBackUpFile ) )
   for each aRow in aData
      oCn:Execute( "INSERT INTO NEWTABLE VALUES " + FW_ValToSql( aRow ) )
   next
 

[MOISES]

Thank you very much, I have replaced memwrite and memoread by hb_, which are supposed to be faster.

But there is a problem: if the order of the fields in the table is not the same, then it fails, because the INSERT does not indicate the field.

Is it possible to include the field in the INSERT? Thank you.

[MOISES]

Up!

[MOISES]

Up! Thnks