Database backup

[Art Zemon]

Steve,

When you use a database like MariaDB, you need to export the data in a
format that can be re-imported. Saving all 720 files is one option but a
poor one. Should you miss a single file, or try to restore it to a
different machine or a different version of MariaDB then the restore might
fail.

I use the mysqldump tool to export all of the tables. Check that out and
test restoring it before you trust that your backups are valid.

The command that I use is: mysqldump -hlocalhost --opt digikam > digikam.sql

I then back up the digikam.sql file to my NAS box.

To restore the database, I would first create it and then reload the data
with: mysql < digikam.sql

I am running on Linux and I named my database "digikam" so you may need to
tweak this command to suit your own situation.

    -- Art Z.


On Sun, Mar 30, 2025 at 6:32 AM Steve Franks <stevef48 at gmail.com> wrote:

> The internal sql database consists of 4 files, but the Mariadb database on
> my Windows PC now has 720 files in 7 folders taking up 46.3gb of space.
> Do I need to retain all of these files? 439 of them are named
> mysql-bin.99999 and mysql-bin.99999.idx (99999 means a 5 digit number), are
> these necessary?
> Thanks in advance
> Steve
>
>

-- 
My blog: CheerfulCurmudgeon.com
*​**​In a place where there are no humans, strive to be human. [Pirkei Avot
2:5]*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20250330/c08112e5/attachment.htm>