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 <discuss@lists.mariadb.org> 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 -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org