Backup from SQL files
Posted: Sat Dec 02, 2023 8:27 pm
Hello,
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
done
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
Chrs...
Ps The Media Library issue is solved.. {2 dec}
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
done
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
Chrs...
Ps The Media Library issue is solved.. {2 dec}