WHAT IS DATABASE FILE FOR CQRLOG?

2 posts / 0 new
Last post
K5KV
WHAT IS DATABASE FILE FOR CQRLOG?

FOR THE SECOND TIME THIS MONTH, MY COMPUTER LOCKED UP AND I HAD TO KILL POWER TO RESTART..  NOW CQRLOG DOES NOT LOAD.  IT CAN NOT FIND THE SERVER.  NEVER HAD A SERVER BUT SOME FILE IS NEEDS TO BE REPLACED TO ALLOW IT TO LOAD.  IS THERE ANY IDEA OF WHAT FILE IS CORRUPTED THAT PREVENTS CQRLOG FROM LOADING?
 
IT WOULD BE EASY TO BACKUP THE DATABASE FILE OR FILES IF I KNEW WHAT THEY WERE.
 
IT IS A MAJOR PAIN TO GO THE COMPLETE INSTALL WITH ALL THE SETTINGS.  PLEASE SOMEONE HELP!!!!!!!

K5KV
UNTIL A BETTER ANSWER IS

UNTIL A BETTER ANSWER IS GIVEN, THIS WORKS FOR ME.  YOU MUST HAVE A UP TO DATE ADIF FILE(S) OF YOUR LOG FIRST!  MULTIPLE LOG FILES REQUIRE MULTIPLE ADIF FILES.  MAKE A BACKUP COPY OF mysql.cnf FOUND IN .config/cqrlog/database AND STORE ELSEWHERE.
 
IF YOU ONLY HAVE ONE LOG FILE IN CQRLOG, CLOSE CQRLOG AND DELETE ALL FILES IN .config/cqrlog/database EXCEPT mysql.cnf.
IF YOU HAVE MULTIPLE FILES, YOU ONLY NEED TO DELETE THE LOGFILE THAT WAS IN USE AT THE TIME OF LOCKUP OR CRASH.  THIS MAY BE cqrlog001.  THE NUMBER IS THE SAME AS THE LOG NUMBER IN CQRLOG.
 
AFTER THE FILES ARE DELTED, RESTART CQRLOG AND LET IT RECREATE THEM.  AFTER IT IS UP AND RUNNING IMPORT YOUR LOG DATA FROM THE ADIF FILES MENTIONED ABOVE.
 
THIS SOUNDS LIKE A LOT OF WORK BUT IS MUCH EASIER THAN RECONFIGURING A TOTAL INSTALL OF CQRLOG.  I NOW HAVE A DAILY BACKUP OF THESE FILES MADE AUTOMATICALLY.  EVERY NORMAL SHUTDOWN IS EXPORTED TO A FLASH DRIVE AS AN ADIF.
HOPEFULLY BETTER METHODS WILL BE POSTED.
 
73
BENNY K5KV