| I don't remember seeing this thread before, but it was "2 new of 3" so maybe I was just half asleep before.
Anyhow, I've only had limited exposure to database master/slave stuff in the past, and that wasn't with MySQL, so no guarantees this is accurate, but I think for the master/slave scenario to work then you'd need to have had the main DB running as a master before the difference started, so that it was recording transaction logs (of inserts/updates/deletes) and it could then re-play these on top of the old dumped data to get the slave in sync.
Without that, you would need some other way to identify what the new data is and generate the queries just for that new data. (If it's an insert-only database with timestamps on all records, it would be simple, but if data is being modified/deleted and doesn't have an audit trail, it might equate to doing a full backup anyway.)
However, if your issue with creating a new full backup is running the process itself, you don't need to worry - assuming you have access to the data files (FRM/IBD/etc) and are in a position to shutdown the MySQL server, I'm fairly sure you can basically just copy the relevant files and clone the entire database with them.
Yep, see the "Cold Backup" section here: https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html - that's for InnoDB tables - if you're using MyISAM and/or other storage engines there may be other steps involved, so worth checking around the docs for more information - searching there reveals a bunch of other relevant pages, and some seem to include example commands (also if you're not on v8 you'll want to alter the version dropdown in case anything has changed).
|