Database repair mode

Repair missing ERP tables safely

Use this page when a deployed database is missing tables or columns after migration. It will reconnect with your MySQL credentials, add only missing schema objects, and show a verification report after the repair step.

Adds missing tables from the schema snapshot without deleting existing rows.
Adds only missing columns from the column snapshot and does not remove existing columns.
Ensures compatibility tables like stats, notifications, profiles, attendance, finance helpers, face sync, SMS bridge, and communication settings.
Does not drop tables, truncate data, or clear records during repair.
Returns a structured log so you can confirm what was fixed.

Repair database

Enter the database server details, target database name, and credentials. Repair mode only adds missed tables and missed columns, including newer facial-attendance, SMS Bridge, and communication setup tables.

Database Host

Database Port

Database Name Actual institute data DB.

Master Database Name Registry DB that stores school_code -> institute DB mapping.

Institute Code

Institute Name

Database User

Database Password

Repair master registry also Recommended. This creates/repairs erp_master, ensures erp_schools, and registers this institute DB without deleting data.

Ready to verify database structure.

Waiting

No repair has been run yet.