mySQL dump corrupted

Projects, Applications, and API development.
Post Reply
fxcollection
Posts: 3
Joined: Wed Nov 10, 2021 1:25 pm

mySQL dump corrupted

Post by fxcollection »

Hi there, it seems that the latest mysqldump (zip md5 : fe94c064af67dd6cb889d72d95dca7d9) is missing several entries on the publishers table.

I've imported this dump replacing an old one I had I noticed that the table now has only 57 entries, a lot of missing entries there.

Is anyone aware of this? Is there a patch by any chance?

Thank you

jennybaso
Posts: 1
Joined: Fri Aug 30, 2024 2:56 am

Re: mySQL dump corrupted

Post by jennybaso »

Check the MD5 hash: Ensure the dump file is not corrupted. Compare the MD5 hash of the dump file you have with the expected hash (fe94c064af67dd6cb889d72d95dca7d9) to confirm that the file was not altered or corrupted during transfer.
Open the dump file: You can manually inspect the SQL dump file by opening it in a text editor to see if the INSERT statements for the missing entries in the publishers table are present.

Vennpaul
Posts: 2
Joined: Wed Aug 14, 2024 10:20 am

Re: mySQL dump corrupted

Post by Vennpaul »

Has anyone else experienced missing entries in the publishers table after importing the latest mysqldump,papa's scooperia and is there a fix or workaround available?

PeteOC
Posts: 60
Joined: Fri Jul 10, 2020 3:05 pm

Re: mySQL dump corrupted

Post by PeteOC »

Unfortunately the db dump hasn't been running daily. I am implementing a fix now for this, it should be working again for the dump at 2am UK time.

PeteOC
Posts: 60
Joined: Fri Jul 10, 2020 3:05 pm

Re: mySQL dump corrupted

Post by PeteOC »

further improvements have been made - we can start to run daily dumps now.

Naitou
Posts: 2
Joined: Thu Feb 15, 2024 1:15 am

Re: mySQL dump corrupted

Post by Naitou »

Excuse me, I’m new here. Where can I get the database dump

Post Reply