How to fix ERROR 1033: Incorrect information in file in MySQL

sudo systemctl stop mysql
# OR
sudo systemctl stop mariadb
# OR on older systems
sudo /etc/init.d/mysql stop

# Check /tmp permissions (should be 777)
ls -ld /tmp
ls -ld /var/tmp

# Fix permissions if needed
sudo chmod 777 /tmp
sudo chmod 777 /var/tmp

grep tmpdir /etc/mysql/my.cnf
# or
grep tmpdir /etc/my.cnf

# Check current ownership and permissions
ls -ld /var/lib/mysql

# Fix ownership (should be mysql:mysql)
sudo chown -R mysql:mysql /var/lib/mysql

# Fix permissions (typically 755)
sudo chmod -R 755 /var/lib/mysql

# Start MySQL
sudo systemctl start mysql

# Check and repair all tables (auto-repair mode)
mysqlcheck -u root -p --auto-repair --check --all-databases

# For a specific database only
mysqlcheck -u root -p --auto-repair --check database_name

# For a specific table
mysqlcheck -u root -p --auto-repair --check database_name table_name

-- Connect to MySQL
mysql -u root -p

-- Attempt quick repair
REPAIR TABLE table_name QUICK;

-- If quick repair fails, try medium repair (rebuilds index)
REPAIR TABLE table_name MEDIUM;

-- Extended repair (rebuilds index from scratch)
REPAIR TABLE table_name EXTENDED;

-- Check table status after repair
CHECK TABLE table_name;

# Check actual file size
ls -lh /var/lib/mysql/ibdata1

# View configuration
grep innodb_data_file_path /etc/mysql/my.cnf

# Edit my.cnf
sudo nano /etc/mysql/my.cnf

# Add this line to the [mysqld] section
innodb_force_recovery = 3

# Restart MySQL
sudo systemctl restart mysql

# Once you can start MySQL, dump the database
mysqldump -u root -p --all-databases > backup.sql

# Then stop MySQL, remove the InnoDB configuration line, and restart

# Check if you have a recent mysqldump backup
ls -lt /path/to/backups/ | head -5

# Restore from backup
mysql -u root -p < backup.sql

# Or restore a specific database
mysql -u root -p database_name < database_backup.sql