What is the best way to do incremental backups in MySQL?

by

AFAIK the only way of doing incremental backups is by using the binary-log. You have other options if you want to do full backups (InnoDB hotcopy), but incremental means that you need to log all transactions made.

You need to ask yourself why you’re backing up data. Since you have a slave for replication, I assume the backup is primarly for reverting data in case of accidental deletion?

I would probably rotate the logs every 1 hour and take a backup of it. Meaning, restoring would leave the data at most 1 hour old, and you can restore to any point in time since the last full snapshot.

More Related Contents:

  1. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  2. 1052: Column ‘id’ in field list is ambiguous
  3. How to do a batch insert in MySQL
  4. Count the occurrences of DISTINCT values
  5. Codeigniter – multiple database connections
  6. How to do Inheritance Modeling in Relational Databases?
  7. JOIN queries vs multiple queries
  8. Is the primary key automatically indexed in MySQL?
  9. Storing Data in MySQL as JSON
  10. MySql: MyISAM vs. Inno DB! [closed]
  11. MySQL: Cloning a MySQL database on the same MySql instance
  12. DOs and DONTs for Indexes [closed]
  13. How to change the default port of mysql from 3306 to 3360
  14. Meaning of “n:m” and “1:n” in database design
  15. How to insert images from database?
  16. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  17. When to use MyISAM and InnoDB? [duplicate]
  18. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  19. How to insert a file in MySQL database?
  20. How do I rename a MySQL database (change schema name)?
  21. Foreign key to one of many tables?
  22. Find date range overlaps within the same table, for specific user MySQL
  23. Rename a table in MySQL
  24. What’s the recommended way to connect to MySQL from Go? [closed]
  25. How to store Query Result in variable using mysql
  26. How to find all the relations between all mysql tables?
  27. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  28. How to Get True Size of MySQL Database?
  29. MySQL: Computed Column
  30. How to recover just deleted rows in mysql?

Leave a Comment