View Categories

Fixing Database Not Loading error in Saleculator M5

1 min read

(Note: To enable any command remove <!– at the start and –> at the end of the command lines. Disabled commands will be green in color, once enabled the color changes to black and red combination, for commands with at the start just remove the , for single line commands with // at the start remove the // to enable)

Here is how to fix when you get error /var/run/mysqld/mysqld.sock (2
Press CTRL+ALT+F1 and run below command:

mysqld_safe --skip-grant-tables &

Now press CTRL+ALT+F2 and run below commands:

mysql
mysql> use mysql
mysql> repair table host use_frm;
mysql> exit
service mysql restart

If MySQL is restarted without any error, you may reboot the system.
If MySQL still not working, follow the below steps:

nano /etc/mysql/mariadb.conf.d/50-server.cnf

Now add below line after the line, inndob_fast_shutdown = 0

innodb_force_recovery = 1

(If this didn’t work, try replacing = 1 with = 2. You can try til the number 6. It should work on any number between 1 and 6)

Save the file by pressing, CTRL+X, Y, Enter.
Run below command.

service mysql restart

If MySQL is restarted without any error, login to the POS system, take backup, reset system and restore the backup.
Now reboot the system and remove or comment the line ‘innodb_force_recovery = 1’ and reboot the system.

0 Comments

Leave a Reply

Arrow-up