• Support

  • MySQLd service failed to start (after restarting server)

lutfifuadi
Hello, what have you done? Try the server to do a snapshot backup and then operate
please use the root authority to execute the command
Is it normal to try to move the file away?
cd /www/server/data/
mv ibdata1 /tmp/ibdata1.bak
mv ib_logfile0 /tmp/ib_logfile0.bak
mv ib_logfile1 /tmp/ib_logfile1.bak
/etc/init.d/mysqld restart

    19 days later

    Hi, please describe your problem in detail.
    If you delete the prompted directory by mistake, please find a professional company to help you restore important data
    If there is no database, you can reinstall mysql

    aaP_olaniyi

      Please check whether the mysql configuration file has changed the database storage directory?

      aaP_olaniyi

        Hello, please check if there are any files in this directory?
        ls -l /www/server/data

        aaP_olaniyi

          5 days later

          i have reintsall aapanel

          pls how can i stop this its genereting itself and its eating up my storage

            aaP_olaniyi
            mysql8 close binary log
            Added in the configuration：
            skip-log-bin=1
            #log-bin=mysql-bin
            #binlog_format=mixed
            expire_logs_days=3
            binlog_expire_logs_seconds = 600000