I have a MySQL table that is constantly being fed rows. It’s a big table with more than 40k rows.
I recently deleted aprox 80 rows from this table “accidentally” and I want to recover them. I have a previous phpMyAdmin export/dump from this table that is much much smaller than the current table but it has the deleted rows in it. I want to possibly import this table dump/export and merge it into the original table without losing anything from the current table but including the deleted rows and “ignoring” the other rows in this dump that will be the identical and are not missing.
Is it possible? How do I procede? I only have access to phpMyAdmin on the server where the table is. I already tried to simply import the table but it returns that the table already exists.