database maintenance

Need help? - Post here and we will find a solution for you.
Locked
ik2egl
Old Man
Posts: 290
Joined: 11 Feb 2014, 22:00
Location: Milan, Italy

database maintenance

Post by ik2egl »

Hi
are there specific operation to be done for database maintenance ?

The only operation I do from time to time is a coyy of SQLlite database (abt 70.000 qso), using the new one as default.

I am not sure it is the only one

any other suggestion ? :D
73 de Don IK2EGL
User avatar
G4POP
Log4OM Alpha Team
Posts: 11621
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: database maintenance

Post by G4POP »

No need just set the auto backups
73 Terry G4POP
User avatar
DF5WW
Log4OM Alpha Team
Posts: 2035
Joined: 02 May 2013, 09:49
Location: Kraam, Rhineland Palatinate, Germany
Contact:

Re: database maintenance

Post by DF5WW »

I use auto backup to a second folder which is my upload folder to the Telecom Mediacenter where i have 25 GB for free in the cloud. So each day i have also actual data stored in the cloud. The upload folder is on a second HDD at my local machine so if there was a problem i have latest data on a 2nd HDD & in the cloud.

The latest config files and the latest ADI will be uploaded automaitc and the SQLite database i load up manually once a week .... :D :D
73´s .. Juergen ... ALT-512 SDR (10W) , 50 m random wire at SG-211 autotuner, 2 x Xiegu G90 (20W HF TRX) one as portable Radio. Also TS-790E (40 W) for VHF/UHF with X-50 vertical and Duoband 4-Element LPDA.
Locked