=== Debug Restore Process ===

Database: gyannewsoftware_rms1
Host: localhost:3306

1. Checking Available Backup Files...
Found 0 files in backup directory:

2. Checking for Extracted Files...
SQL files in project root:
Compressed SQL files:
Database backup files:

3. Checking Temporary Directory...
Temporary SQL files:
Temporary config files:

4. Testing Database Connection...
✓ Database connection successful
✓ Current users count: 3

5. Testing SQL Execution...
✓ SQL execution test successful
✓ Test table cleaned up

6. Checking Error Logs...

7. Checking PHP Error Log...
Recent PHP errors:
[18-Aug-2026 19:49:09 UTC] PHP Warning:  session_name(): Session name cannot be changed after headers have already been sent in /home/gyannewsoftware/public_html/rms1_TableTrackRestaurantManagementSolution/Modules/Backup/Restore/restore-backup.php on line 525
[18-Aug-2026 19:49:09 UTC] PHP Warning:  session_start(): Session cannot be started after headers have already been sent in /home/gyannewsoftware/public_html/rms1_TableTrackRestaurantManagementSolution/Modules/Backup/Restore/restore-backup.php on line 526
[19-Aug-2026 04:23:14 UTC] PHP Warning:  Undefined variable $dbTest in /home/gyannewsoftware/public_html/rms1_TableTrackRestaurantManagementSolution/Modules/Backup/Restore/main-interface.php on line 114
[19-Aug-2026 04:23:14 UTC] PHP Warning:  Trying to access array offset on value of type null in /home/gyannewsoftware/public_html/rms1_TableTrackRestaurantManagementSolution/Modules/Backup/Restore/main-interface.php on line 114
[19-Aug-2026 04:23:14 UTC] PHP Fatal error:  Uncaught Error: Call to undefined function findMysql() in /home/gyannewsoftware/public_html/rms1_TableTrackRestaurantManagementSolution/Modules/Backup/Restore/main-interface.php:133
Stack trace:
#0 {main}
  thrown in /home/gyannewsoftware/public_html/rms1_TableTrackRestaurantManagementSolution/Modules/Backup/Restore/main-interface.php on line 133
[19-Aug-2026 04:53:17 UTC] PHP Warning:  session_name(): Session name cannot be changed after headers have already been sent in /home/gyannewsoftware/public_html/rms1_TableTrackRestaurantManagementSolution/Modules/Backup/Restore/restore-backup.php on line 525
[19-Aug-2026 04:53:17 UTC] PHP Warning:  session_start(): Session cannot be started after headers have already been sent in /home/gyannewsoftware/public_html/rms1_TableTrackRestaurantManagementSolution/Modules/Backup/Restore/restore-backup.php on line 526


=== Debug Complete ===
This information will help identify why the restore is not working.
Look for:
1. Missing SQL files after extraction
2. SQL execution errors
3. File permission issues
4. Database connection problems