Timeline for MySQL incremental backups per database (not global)
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| May 29, 2014 at 13:31 | comment | added | yurisum | Yes, almost all tables are InnoDB | |
| May 16, 2014 at 16:15 | comment | added | James Anderson | Are you using the innodb engine? | |
| May 16, 2014 at 15:52 | comment | added | yurisum | I already use mysqldump, the problem is that it supports increments based on LSN which is global for MySQL instance (as far as I understand) so if I dump only one database and then rotate binlog to make increments I'll have a lot of queries in binlog which has nothing to do with my particular database (since it contains all changes happened to all databases on that particular server), it's wasting of disk space and I'm not sure that applying such increments to full backup will work. | |
| May 16, 2014 at 14:15 | history | answered | James Anderson | CC BY-SA 3.0 |