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
BackUp [bCondition]
- Willi Quintana
- Posts: 1023
- Joined: Sun Oct 09, 2005 10:41 pm
- Location: Cusco - Perú
- Contact:
Re: BackUp [bCondition]
Willy.
Si pruebas extendiendo el tiempo de espera de la sesion de Mysql?
A mi me ha funcionado con tablas grandes.
Si pruebas extendiendo el tiempo de espera de la sesion de Mysql?
Code: Select all | Expand
oServer:Execute("SET SESSION wait_timeout = 186400")