ServerTechSupport

Tag: mysql

  • MySQL: Cannot load from mysql.proc. The table is probably corrupted

    —

    by

    Admin
    in

    If you have upgrade the MySQL 5 to a later minor version say 5.1 to 5.5 then you can usually end up getting below error in the logs, or your backup system fails to take database backup giving below error [plain] SHOW FUNCTION STATUS WHERE Db = ‘servertechsupport’: Cannot load from mysql.proc. The table is…

  • Move MySQL to new folder or hard drive

    —

    by

    Admin
    in

    You will ofter comes across time when partition containing MySQL will started to fill up and you need to move it to  a new directory. So to move MySQL to new directory first of all stop the MySQL service [bash] [root@servertechsupport ~]# /etc/init.d/mysql stop [/bash] Note: If you are using cPanel Make sure you disable…