79645395

Date: 2025-05-30 11:47:08
Score: 0.5
Natty:
Report link

You can try as per below-

#full dump backup except files table

mysqldump -R -A --ignore-table=mh_website_db.files > full_backup.sql

#data only from files table based on condition like only last 1 day entries as you should have all data before this via previous day job.

mysqldump -t mh_website_db files -w"timestamp > subdate(curdate(), interval 1 day)" > files_difference.sql

note: you can also use "--insert-ignore" parameter with dump command, if this table has primary key/unique key to avoid duplicate issue.

#First import full dump except files table

mysql < full_backup.sql

#then import new entries from files table.

mysql < files_difference.sql

If you need something else then please elaborate it.

Reasons:
  • RegEx Blacklisted phrase (2.5): please elaborate
  • Long answer (-0.5):
  • Has code block (-0.5):
  • High reputation (-1):
Posted by: Zafar Malik