FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour BackUp [bCondition]
Posts: 1054
Joined: Sun Oct 09, 2005 10:41 PM
BackUp [bCondition]
Posted: Mon Mar 04, 2024 05:40 PM
Mr. Rao

Good morning, I have a database that has 60 tables and 2 of them have more than 400,000 records, when I use MariaDb BackUp, it cannot do the job, sometimes the connection is cut and other times it only loads about 100,000 records, is it possible that the BackUp has a clause (WHEN) to condition the process?, as well as:

BackUp( [source], [dest], [bProgress], [cCondition], [nRecsInBatch], [nMaxBufperSQL] )

where cCondition := "WHERE year(fecha_doc) > 2023", something like that.

Thank you for your time
Posts: 1344
Joined: Wed Nov 16, 2005 09:14 PM
Re: BackUp [bCondition]
Posted: Tue Mar 05, 2024 01:29 PM
Willy.
Si pruebas extendiendo el tiempo de espera de la sesion de Mysql?
Code (fw): Select all Collapse
oServer:Execute("SET SESSION wait_timeout = 186400")
A mi me ha funcionado con tablas grandes.

Continue the discussion