Backup from SQL files

Having trouble installing serendipity?
Post Reply
Posts: 1
Joined: Sat Dec 02, 2023 7:34 pm

Backup from SQL files

Post by Mysite »


I lost my original MySQL database on my Serendipity 2.3.5 and PHP 7.4.33 system.
So I try to reimport the SQL files:
as example 2023-11-14-18-48_CREATE_serendipity_access.sql
In total 68 sql are imported via a small script:

for filename in *.sql; do
echo $filename
mysql -u serendipity -p -D serendipity < $filename

However now I see some issues:
ERROR 1062 (23000) at line 12: Duplicate entry '1' for key 'serendipity_link_category.PRIMARY'

Also if I perform an integrity check I get:

Who knows howto get that fixed :)


Ps The Media Library issue is solved.. {2 dec}
medias9y1.png (35.92 KiB) Viewed 11583 times
Posts: 2819
Joined: Tue Sep 09, 2008 10:04 pm

Re: Backup from SQL files

Post by onli »

Are you sure the database you fill there with the script is empty? If not that would explain the error -> there could already be a category with id 1.

For the integrity check: This might be a problem, it might not be. It is supposed to mean that the file got changed. Did you change them maybe? If not, have a look at the files, open them in an editor, and see if there is a difference to the originals of the install archive.
Post Reply