Corrup file en copia de respaldo

Corrup file en copia de respaldo

Postby horacio » Fri Aug 25, 2023 4:46 pm

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
horacio
 
Posts: 1358
Joined: Wed Jun 21, 2006 12:39 am
Location: Capital Federal Argentina

Re: Corrup file en copia de respaldo

Postby nageswaragunupudi » Sat Aug 26, 2023 8:41 am

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 view
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 view
oCn:BackUp( nil, "c:\mybackups\" )


Backups will be stored like this:
Code: Select all  Expand view
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
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10248
Joined: Sun Nov 19, 2006 5:22 am
Location: India


Return to FiveWin para Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 80 guests