No, they will not. You will need to load those tables into a new clean instance, mysqldump them, and then restore via the mysqldump files instead. MySQL/MariaDB replication works by logging incremental changes, either via queries or rows. Side-loading MYD/MYI files will not generate entries in the replication log. Doing that will be equivalent to loading a mysqldump with sql_log_bin=0, which is not what you want.
On Fri, 12 Sept 2025 at 23:02, Richard Reina via discuss <[email protected]> wrote: > > I have a stable replication environment set up with a MySQL master (that will > be retired next quarter) and Mariadb replicas. I need to restore a mysql > table from a back up. If I stop mysql with 'systemctl stop mysql' replace the > table_name.MYD, table_name.MYI and table_name.frm with their corresponding > backup files and restart mysql will the mariadb replica servers update > correctly? > > _______________________________________________ > discuss mailing list -- [email protected] > To unsubscribe send an email to [email protected] -- Gordan Bobic Database Specialist, Shattered Silicon Ltd. https://shatteredsilicon.net Follow us: LinkedIn: https://www.linkedin.com/company/shatteredsilicon X: https://x.com/ssiliconbg _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
