Database backup

[Steve Franks]

Thank you for your advice.
I ran the command on my Windows 11 PC and received the following error
message:-
mysqldump: Got error: 2002: "Can't connect to server on 'localhost'
(10061)" when trying to connect
I assumed that it was because digikam wasn't running, but when I tried
again with digikam running the same thing happened.
As you know, I don't know much about MySql/MariaDB, so I don't know how to
fix this.
Regards
Steve

On Sun, 30 Mar 2025 at 13:58, Art Zemon <art at zemon.name> wrote:

> 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/0a970df3/attachment.htm>