How to fix ERROR 1030: Got error from storage engine in MySQL

# Check overall disk usage
df -h

# Check MySQL data directory specifically
du -sh /var/lib/mysql/

-- Check a specific table
CHECK TABLE your_table_name;

-- Check multiple tables in a database
CHECK TABLE table1, table2, table3;

REPAIR TABLE your_table_name;

-- First, check the error log
SHOW ENGINE INNODB STATUS;

-- If corruption is detected, set recovery mode and restart
-- Add to my.cnf or my.ini:
-- innodb_force_recovery=1
-- Then restart MySQL

-- After restart, dump the table data
mysqldump -u root -p database_name table_name > backup.sql

-- Drop the corrupted table
DROP TABLE table_name;

-- Restart MySQL normally (remove innodb_force_recovery)
-- Restore the table
mysql -u root -p database_name < backup.sql

SHOW VARIABLES LIKE 'innodb_buffer_pool_size';

[mysqld]
innodb_buffer_pool_size=2G

sudo systemctl restart mysql

# Verify MySQL owns the data directory
sudo chown -R mysql:mysql /var/lib/mysql

# Check file permissions
sudo chmod 750 /var/lib/mysql
sudo chmod 640 /var/lib/mysql/*

sudo restorecon -Rv /var/lib/mysql

sudo systemctl restart mysql

-- First, check your current InnoDB file format
SHOW VARIABLES LIKE 'innodb_file_format';

-- Set to Barracuda to support DYNAMIC format
SET GLOBAL innodb_file_format=Barracuda;

-- Update my.cnf to persist the change
-- innodb_file_format=Barracuda

-- Alter your table
ALTER TABLE your_table_name ROW_FORMAT=DYNAMIC;

sudo systemctl restart mysql

# Check filesystem for errors (run during maintenance window)
# WARNING: This requires stopping MySQL and unmounting the filesystem
sudo systemctl stop mysql
sudo fsck -n /dev/sda1  # use -n for read-only check first

# Check for bad sectors
sudo badblocks -v /dev/sda1

# Review system logs for I/O errors
sudo tail -f /var/log/syslog | grep -i error