Verifying integrity before making backups sounds like a side effect. You should probably monitor your logs (they’ll tell you when tables are corrupt) and/or have a SOP in place to run mysqlcheck after a crash.
William Edwards > Op 20 apr 2024 om 15:44 heeft Felix Natter via discuss > <[email protected]> het volgende geschreven: > > Dear mariadb experts, > > I would like to do this to verify my dbs (to detect hardware errors so > that I can replay a backup timely): > > mysqlcheck -u root -pX --check --all-databases --extended > > Is it definitely read-only? Can I rely on the return code (0=success)? > > Or do I not need this because "mysqldump" does consistency checks? > > Many Thanks and Best Regards! > Felix > -- > Felix Natter > > _______________________________________________ > discuss mailing list -- [email protected] > To unsubscribe send an email to [email protected] > _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
