Hi, sorry if this has been covered before but I’ve been looking for some walk-though guide on how to move my digikam databases & 300k images from my soon to be retired Synology NAS to the new Terramaster unit (2 weeks so far..). Both NAS have MariaDB & PHPMyAdmin and we access the database from two laptops and a PC.
A little background - I’m an industrial software engineer familiar with packages that use SQL databases but I rarely need to work directly on the database itself (all the tools are object orientated so SQL skills are almost never needed - when I do need to do anything on the database there are copy-paste guides on what to do). In short I can work my way around general scripting for multiple applications, but I’m lost on SQL command line or supporting tools.
The problem:
Following various posts relating to MariaDB/MySQL I’ve tried using the PHPMyAdmin export/import method which generates an error message on import to the effect that the database is too large (about 1000x too large).
So I then tried using various dump commands in the PHPMyAdmin SQL tab which also seem to fail - it appears that the dump commands aren’t usable from the SQL interface in PHPMyAdmin. I know I’m doing something wrong here but I think the posts that I’m reading are probably really helpful to anybody who isn’t starting at ground level but there is an assumed level of knowledge that I don’t have and no easy way to acquire quickly.
I see that there is a migration tool in Digikam, but this seems to be to change database from one version to another version, and that the photos will stay in the same location (which would somewhat defeat the objective of moving the database). I have a concern that I might end up corrupting the database(s) or that the migration tool moves the database but I’m then unable to move the photos without losing the link that associated the database entries with the individual images.
So, hopefully I’m missing something really obvious that somebody can point me towards that will help me get my Digikam system up and running again, will all my photos, and existing data moved from one NAS to another.
Thanks in advance. Phil