Move CQRLOG log file to new PC

17 posts / 0 new
Last post
WG9L
Move CQRLOG log file to new PC

Hi everyone,

I'm still a noob when it comes to Linux. I have been using CQRLOG on a Linux Mint 17.2 Cinnamon PC for about 2 months. In my set up, I have a dual boot PC. Windoze 7 and Linux Mint, as I'm sure MANY others have the exact same set up too.

This was basically a test set up to see if I could make use of Linux and find a good logging program. CQRLOG is absolutely fantastic and so far, Mint has been great as well. But I have come to the realization that the test machine is just too old and slow to get good performance and now I would like to take my native CQRLOG log file(s) and move it to another PC that also has dual boot W7 / Mint. I still need to have W7 because of N1MM contest logging program. This would then become my primary machine and Mint, my primary OS.

I have discovered that my existing log file is kept in the following hidden folder location-
/home/bob/.config/cqrlog/database.

Inside the /database folder, I see two other folders (cqrlog001) and (cqrlog_common) and a whole LOT of files in this directory. In order to move the log correctly, do I need to copy the entire contents of the /database folder over to a new, fresh install of CQRLOG on the new PC? What about just exporting an ADIF file from CQRLOG and then importing that ADIF file back into the new PC using a fresh install of CRQLOG? Will I lose any information from my CQRLOG log file, or will "EVERYTHING" carry over without any loss on information?

TNX,

Bob, WG9L

PA1SBM
PA1SBM's picture
Hi Bob,

Hi Bob,

By far imho the easiest thing to do is export an adif file in the QSO list window, then import that on the other pc.
This would mean that you loose all your settings within the program.
To avoid that (if you think it's a problem to do all your settings again) you probably could install the same CQRlog and maria/mySQL version as the old pc, run it once, and then copy over that hidden folder. I never tried this, i just use my adif file.

ok2cqr
ok2cqr's picture
Re: Move CQRLOG log file to new PC

Hi Bob,

compress whole cqrlog directory, move it to another computer, extract cqrlog directory to ~/.config and it will work.

73 Petr, OK2CQR

WG9L
Petr,

Petr,

So does that mean the CQRLOG icon will show up on my desktop and that there will be an icon on the "menu, internet" button?

Bob

WG9L
Oops, I forgot to ask the

Oops, I forgot to ask the question... Should I perform a new, clean install of CQRLOG on the PC and then copy over the files from the old machine, or just make a new directory on the new machine and then copy over all files from the old machine?

Bob

ok2cqr
ok2cqr's picture
Re: Oops, I forgot to ask the

Bob,

copy the .config/cqrlog directory to a new computer, install cqrlog from deb file or use binary files. Run CQRLOG and it should see what you had on old computer.

73 Petr

VA3CME
VA3CME's picture
Moving CQRLog to new computer

i did this a different way, and ran into a problem i can't solve. In CQRLog's initial open log dialog there is a utility option to save CQRLog's config. i did this, moved to the new computer, imported the config and log file, and everything seemed fine. However, new QSOs do not get uploaded to the online Logs. The "status of log upload" window says all QSOs already uploaded. i had previously marked existing QSOs as uploaded to avoid watching the upload status window re-upload all QSOs to the various online logs one QSO at a time :-(

Is there a way to export parts of the log to an ADI file instead of the whole thing?

KX3 w KXPA100 dipole on balcony

ok2cqr
ok2cqr's picture
Re: Moving CQRLog to new computer

Yes, there is. In QSO list window use Filter to choose what QSO you want to export. Then go to File -> Export -> Adif and it will export QSOs that meet the filter criteria.

73 Petr

WG9L
Thanks Petr,

Thanks Petr,
I'll try it and let you know how it went.

73, Bob, WG9L

WG9L
Thank you Petr,

Thank you Petr,
It worked perfectly. All original config settings and log information are now on the new machine. Wonderful!

TNX and 73,

Bob, WG9L

DL7KC
Hello,

Hello,
i have copy the complete folder cqrlog from /.config in this folder from the other pc
But when i start the cqrlog i get the error:
Error during connection to database: TMySQL57Connection : Server connect failed.
What can i do?

oh1kh
Cqrlog move to other PC

Hi !

Are both PCs having same Linux version?
And is the database engine same (Mysql, or MariaDb) in both?
And did you first try to start cqrlog in new PC to see that install does work before install copied cqrlog folder?
Did you check that folder .config/cqrlog has same owner than the user in new PC (that you did not copy folder with root account (or sudo)?

The first two questions are first to check.

If you try to move folder between different Linux OS versions or between different database engines that is going to make problems that may need extra knowledge and work.

--
Saku
OH1KH

DL7KC
Its on both PCs Ubuntu 18

Its on both PCs Ubuntu 18
I hope its the same Database.

This are the Errors:

2020-05-27 8:26:39 140690107931776 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2020-05-27 8:26:39 140690107931776 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-05-27 8:26:39 140690107931776 [Note] InnoDB: The InnoDB memory heap is disabled
2020-05-27 8:26:39 140690107931776 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-27 8:26:39 140690107931776 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-05-27 8:26:39 140690107931776 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-27 8:26:39 140690107931776 [Note] InnoDB: Using Linux native AIO
2020-05-27 8:26:39 140690107931776 [Note] InnoDB: Using SSE crc32 instructions
2020-05-27 8:26:39 140690107931776 [Note] InnoDB: Initializing buffer pool, size = 80.0M
2020-05-27 8:26:39 140690107931776 [Note] InnoDB: Completed initialization of buffer pool
2020-05-27 8:26:39 140690107931776 [Note] InnoDB: Highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: A downgrade from MariaDB 10.2.2 or later is not supported.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html
2020-05-27 8:26:39 140690107931776 [ERROR] Plugin 'InnoDB' init function returned error.
2020-05-27 8:26:39 140690107931776 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-05-27 8:26:39 140690107931776 [Note] Plugin 'FEEDBACK' is disabled.
2020-05-27 8:26:39 140690107931776 [ERROR] Unknown/unsupported storage engine: innodb
2020-05-27 8:26:39 140690107931776 [ERROR] Aborting

oh1kh
Cqrlog move to other PC

Hi!
I'm a bit worried about "A downgrade from MariaDB 10.2.2 or later is not supported"

Open command console, do it with both PCs, and give command:

mysql --version

You should get something like:
[saku@hamtpad ~]$ mysql --version
mysql Ver 15.1 Distrib 10.3.22-MariaDB, for Linux (x86_64) using readline 5.1

Does both PCs have same version? If not new PC should have the version that is in PC where cqrlog was running before, no matter if the version is not same that I have.

--
Saku
OH1KH

do2hg
TMySQL57Connection : Server connect failed.

Just ran into this problem.
I have two machines with Ubuntu 20.04 and run CQRLOG 2.4.0 (with mariadb).

What worked for me was:
- purge and re-install mariadb-server before launching cqrlog after copying the log-directory (~/.config/cqrlog) in place, only then launch cqrlog.

Means (as root or alternatively with a preceeding "sudo"):
# service mariadb stop
# apt-get purge mariadb-server
# apt-get install mariadb-server
# service mariadb start

And then:
myself@machine:/home/myself.config$ tar xvjf cqrlog-tree-compressed.tbz2

... then fire up cqrlog and all should be fine ...

73
Stefan.

--
Stefan
DB4ST (ex DO2HG) --- German Ham Radio Station
D-32584 Löhne ----- Locator JO42IE

DL7KC
When i get the command on the

When i get the command on the old PC:
mysql --version
The output is:
mysql Ver 14.14 Distrib 5.7.30, for Linux (x86_64) using EditLine wrapper

On the new PC its like yours.

How can i upgrade this?

oh1kh
Cqrlog move to other PC

Hi!

Either you must uninstall Maridb from new PC and install mysql to it, but that is not recommended as it seems that MariDB is slowly taking room in every Linux version.

There are few possibilities:

Take full adif copy of your log and then go NewQSO/File/Open or create new log and at database connection windows select first log that you are moving (if you have several logs) then utils/configuration/export/
At new PC create new log at database connection window, do not open it yet. First go utils/configuration/import and use your exported settings file. After that open log and go NewQSO/Window/QSO list/File/Import/ADIF and import your exported adif file.
You have to do this separate for every log you have. Also some things do not transfer via ADIF export, so it will not be 100% copy.

Other possibility is to use command line and mysqldump command to dump all cqrlog* named databases.
In command console (while cqrlog is running) this command should dump all to file /tmp/logs.sql

$(/usr/bin/mysql --socket /home/MyUsername/.config/cqrlog/database/sock -B -N -e 'show databases like "cqr%"' | /usr/bin/xargs /bin/echo -n mysqldump --socket /home/MyUsername/.config/cqrlog/database/sock --databases) > /tmp/logs.sql

You should replace MyUsername with your real username

Restoring (when new PC cqrlog is running and file logs.sql is coped to /tmp folder) should happen with command:

/usr/bin/mysql -v --socket /home/MyUsername/.config/cqrlog/database/sock < /tmp/logs.sql

This will be 100% cpy but need some command console skills and may cause some questions. How ever dumping old PC should be safe and restoring to new PC does not destroy any valuable information. Deleting ~/.config/cqrlog folder lets always to start from beginning.

--
Saku
OH1KH