1.Enable System Maintenance Mode:

To prevent active users from writing data during database operations:

1. Log into Lynx PMIS with Administrator credentials.

2. Navigate to Administration → Replacing Database (or System Settings).

3. Toggle Maintenance Mode to ON.

4. Provide a maintenance notice message (e.g., "Lynx PMIS is undergoing scheduled database maintenance. Service will resume in 30 minutes."). Active users will see a read-only maintenance banner.

[IMAGE PLACEHOLDER: Maintenance Mode toggle switch and custom broadcast message input box]

2.Export a Local Safety Backup:

ALWAYS generate a current backup before replacing the active database.

1. On the Replacing Database panel, locate the Backup & Export section.

2. Click Generate Full System Backup.

3. Save the timestamped backup file (e.g., LynxPMIS_Backup_2026-08-24.bak) to a secure local or encrypted cloud storage location.

[IMAGE PLACEHOLDER: Backup export panel displaying backup generation button and download confirmation]

3.Upload & Validate New Database File:

1. Under the Database Replacement section, click Browse File and select the validated replacement file.

2. Click Validate Schema.

3. Lynx PMIS will run a pre-check verification:

   • ✅ Schema Structure Compatibility

   • ✅ License Allocation Mapping

   • ✅ File Integrity Checksum

4. 
   

[IMAGE PLACEHOLDER: Database upload dialog with validation progress indicators and status checks]

4.Execute Replacement & Confirm:

1. Once schema validation passes, type the security confirmation phrase into the verification field:

REPLACE-DATABASE-CONFIRM

2. Enter your Admin Security PIN / Password.

3. Click Execute Database Replacement.

4. Wait for the progress indicator to reach 100%. Do not refresh or close your browser during this step.

[IMAGE PLACEHOLDER: Security confirmation modal requiring text entry and Admin credentials]

5.Verify System Integrity & Disable Maintenance Mode:

1. After completion, check the automated Migration Log for any warnings or error codes.

2. Spot-check key modules (Workspace, Projects, and S-Curves) to verify record restoration.

3. Navigate back to Replacing Database and toggle Maintenance Mode to OFF to restore standard user access.

[IMAGE PLACEHOLDER: Migration Log summary table displaying green success status]

⚠️ Safeguards & Emergency Recovery Procedure

In the event of an unexpected server disruption, internet disconnection, or validation error during database replacement:

🛡️ Automated Fail-Safe: Lynx PMIS creates an automated Rollback Point immediately before initiating replacement operations. If the import process is interrupted, the system automatically restores the last stable rollback point.

Emergency Restoration Steps

1. If the application becomes unresponsive, access the server recovery portal at [https://your-domain.com/admin/recovery](https://your-domain.com/admin/recovery).

2. Select Restore Last Rollback Point.

3. Upload the manual backup file generated in Step 2 if auto-rollback fails.

4. Contact technical enterprise support immediately.

💡 Best Practices for Technical Maintenance

💡 Schedule Operations Off-Peak: Always schedule database replacement or schema updates outside standard operating hours (e.g., weekends or late evenings) to minimize impact on site teams.

💡 Maintain Retainage History: Keep at least three consecutive monthly database backup snapshots stored in isolated offline storage for audit compliance and disaster recovery.

📞 Enterprise Technical Support

Database replacement queries and disaster recovery assistance:

• 📧 Emergency Support Email: lynxpmis.support@gmail.com

• 📞 Urgent Technical Desk: 019-3304704

• ⏰ 24/7 Admin Emergency Line: Contact your assigned enterprise support engineer directly.