BackUp [bCondition]

Post Reply
User avatar
Willi Quintana
Posts: 1023
Joined: Sun Oct 09, 2005 10:41 pm
Location: Cusco - Perú
Contact:

BackUp [bCondition]

Post 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
User avatar
cmsoft
Posts: 1293
Joined: Wed Nov 16, 2005 9:14 pm
Location: Mercedes - Bs As. Argentina

Re: BackUp [bCondition]

Post by cmsoft »

Willy.
Si pruebas extendiendo el tiempo de espera de la sesion de Mysql?

Code: Select all | Expand

oServer:Execute("SET SESSION wait_timeout = 186400")
A mi me ha funcionado con tablas grandes.
Post Reply