Learn about Centmin Mod LEMP Stack today
Register Now

Xenforo Dumb Question - How will i know MySQL db got corrupt

Discussion in 'Forum software usage' started by Dnyan, Aug 5, 2019.

  1. Dnyan

    Dnyan Member

    55
    9
    8
    Sep 16, 2017
    Ratings:
    +11
    Local Time:
    11:55 PM
    1.17.2
    10.1.41
    Hello,

    I have a dumb question on my mind, if we shift the files to another host or do backup and restore for xenforo.

    once the setup is done and web is accessible, if there is corruption of data in MySQL tables at any location. do xenforo will report it as server errors in admin panel?

    Or will i come to know about it when its almost getting dead due to corruption if i am not looking at var logs for mysql.

    I think xenforo will inform about all corrupted tables once it get on like Chappie and will display it in ACP.

    Is this correct or will come to know only if i keep looking at mysql server logs on daily basis.

    Thanks
     
  2. eva2000

    eva2000 Administrator Staff Member

    41,080
    9,188
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,097
    Local Time:
    4:25 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Depends of definition of corrupt. In terms of MySQL data being corrupt, commonly this can mean missing/incomplete data or incorrect data stored. Which means only time you'd know is when a web app like Xenforo goes to use or rely on that data and it doesn't get what it expects returned from MySQL querying. In which case, Xenforo may report the error if it results in unexpected data it relies on.

    In more severe cases i.e. mixing actual /var/lib/mysql data files from different servers via physical data file manipulation/moving, the corruption can mean MySQL server doesn't start up at all. You'll definitely know in that case from MySQL log files.

    Only real safe guard is frequent and regular MySQL backups