Comments - some Records are deleted from two tables ...which way is best to restore these deletes records?
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Do you have the binary log enabled? See this answer for details.
You probably don't have it enabled, but this is something that system-versioned-tables would be ideal for. You could just query the table at the point in time before the records were deleted.