Page 1 of 1

Corrup file en copia de respaldo

Posted: Fri Aug 25, 2023 4:46 pm
by horacio
Compañeros, tengo una copia de seguridad hecha con las utilidades de FHWMYSQL que se ha corrompido. Hay alguna manera de poder solucionarlo? Desde ya Muchas gracias

Saludos

Re: Corrup file en copia de respaldo

Posted: Sat Aug 26, 2023 8:41 am
by nageswaragunupudi
May we know why do you think the file is corrupted?
If it is really corrupted by some virus overwriting part of the file with junk, there is no way to fix it.
If you open and find no garbage in the file, it is worth trying again.

For future we have an important advice.
We know the syntax:

Code: Select all | Expand

BackUp( [aTables], cDest, [bProgress], [nMaxRecs], [nMaxBuf] )
If the first parameter is nil and the second parameter is a directory (not a file ), the backups will be stored each day in a separate subfolder named by weekday.
Code Example:

Code: Select all | Expand

oCn:BackUp( nil, "c:\mybackups\" )
Backups will be stored like this:

Code: Select all | Expand

20-04-2022  09:35    <DIR>          .
11-08-2023  00:24    <DIR>          ..
15-04-2022  23:10    <DIR>          FRIDAY
04-04-2022  20:32    <DIR>          MONDAY
17-04-2022  02:19    <DIR>          SATURDAY
03-04-2022  10:06    <DIR>          SUNDAY
07-04-2022  16:26    <DIR>          THURSDAY
19-04-2022  09:47    <DIR>          TUESDAY
20-04-2022  09:35    <DIR>          WEDNESDAY
 
This way, even if the last backup is corrupted, we can use previous day backup