I’ve switched from SQLite to MariaDB on my local DigiKam machine (Windows 10) - it’s much faster now, BTW. Now I’m wondering what is the best way to backup the database. With SQLite it was easy - just copy all the database files to another (safe) location.
With MariaDB I’m doing the following and would like to know if this is good enough.
I use HeidiSQL admin tool for this procedure to copy the DK database to my local Linux server with MySQL installed:
- Tools -> Export database as SQL
- Choose the Output as my MySQL server and same database as on source
- Select to create tables and “Delete + Insert (truncate existing data)”
- Select the digikam DB on my local machine
- Click Export and wait for process to finish.
So my questions are:
- is this procedure OK and will I be able to restore the database the same way so digiKam will use it without problems (hope I won’t need this )?
- what bothers me is the fact that on the destination server the tables’ properties are different after export than on the source (local machine), for example there are different numbers of rows reported. Any ideas why that might happen?
Or does somebody have any other suggestions on how to easily backup the database?