MariaDB failed to start because both Aria and InnoDB

Brian Ayienda — Fri, 10 Oct 2025 06:51:20 +0000

🧭 Step-by-Step Fix (XAMPP Safe Method)
⚠️ First, Backup Everything

Before any recovery attempt:

Stop MySQL in XAMPP.

Go to:

C:\xampp\mysql\data

Copy the entire data folder to somewhere safe, e.g.:

C:\backup_mysql_data_2025_10_10

🧰 Step 1: Delete Corrupted Aria Logs

In C:\xampp\mysql\data, delete all files starting with:

aria_log.

Also delete:

aria_log_control

🧰 Step 2: Remove InnoDB Log Files

Still inside C:\xampp\mysql\data, delete:

ib_logfile0
ib_logfile1

(These will be recreated automatically on restart.)

🧰 Step 3: Force Recovery Mode (to extract data safely)

If it still won’t start, edit:

C:\xampp\mysql\bin\my.ini

Under [mysqld], add:

innodb_force_recovery = 1

Then try starting MySQL from XAMPP again.

If it still fails, increase the value gradually up to 6:

innodb_force_recovery = 6

⚠️ Warning:

You can only dump/export data in recovery mode.

Do not write or modify data.

Once MySQL starts:

Use phpMyAdmin or mysqldump to export all your databases.

Stop MySQL again.

Remove the innodb_force_recovery line from my.ini.

🧰 Step 4: Rebuild the Data Directory (if nothing works)

If MySQL still won’t start:

Stop XAMPP.

Rename:

C:\xampp\mysql\data → C:\xampp\mysql\data_old

Create a new empty folder:

C:\xampp\mysql\data

Copy the backup from:

C:\xampp\mysql\backup

(This contains default system tables: mysql, performance_schema, etc.)

Start MySQL.

Reimport your .sql database exports.

How can I solve "Error: MySQL shutdown unexpectedly"?

Brian Ayienda — Mon, 08 Sep 2025 10:27:13 +0000

Go to xampp
Go to mysql
Rename data into data_old
Create a new folder name data
Go to backup and copy everything
Go to data and paste everything
Go to data_old and copy everything
Go to data and paste everything and click skip these files
Go to data_old and copy ibdata1
Go to data and past ibdata1 and click replace the file destination
Now restart xampp and see without losing any data we fixed the problem

DEV Community: Brian Ayienda

MariaDB failed to start because both Aria and InnoDB

How can I solve "Error: MySQL shutdown unexpectedly"?