Page 1 of 1

BackUp [bCondition]

PostPosted: Mon Mar 04, 2024 5:40 pm
by Willi Quintana
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

Re: BackUp [bCondition]

PostPosted: Tue Mar 05, 2024 1:29 pm
by cmsoft
Willy.
Si pruebas extendiendo el tiempo de espera de la sesion de Mysql?
Code: Select all  Expand view
oServer:Execute("SET SESSION wait_timeout = 186400")

A mi me ha funcionado con tablas grandes.