=== Debug Restore Process ===

Database: hellopos_hellopos
Host: localhost:3306

1. Checking Available Backup Files...
Found 13 files in backup directory:
- backup_v1.2.56_2025-12-11_05-40-07.sql (1015880 bytes, modified: 2025-12-11 05:40:07)
- backup_v1.2.59_2025-12-19_21-05-49.sql (1538307 bytes, modified: 2025-12-19 21:05:50)
- backup_v1.2.61_2026-04-24_02-00-02.sql.gz (294484 bytes, modified: 2026-04-24 02:00:03)
- backup_v1.2.61_2026-04-25_02-00-03.sql.gz (294496 bytes, modified: 2026-04-25 02:00:03)
- backup_v1.2.61_2026-04-26_02-00-02.sql.gz (294498 bytes, modified: 2026-04-26 02:00:02)
- backup_v1.2.61_2026-04-27_02-00-02.sql.gz (294485 bytes, modified: 2026-04-27 02:00:02)
- backup_v1.2.61_2026-04-28_02-00-02.sql.gz (294497 bytes, modified: 2026-04-28 02:00:02)
- backup_v1.2.61_2026-04-29_02-00-02.sql.gz (294490 bytes, modified: 2026-04-29 02:00:02)
- backup_v1.2.61_2026-05-01_02-00-02.sql.gz (294486 bytes, modified: 2026-05-01 02:00:03)
- backup_v1.2.61_2026-05-02_02-00-02.sql.gz (294496 bytes, modified: 2026-05-02 02:00:02)
- backup_v1.2.61_2026-05-03_02-00-03.sql.gz (294496 bytes, modified: 2026-05-03 02:00:03)
- backup_v1.2.61_2026-05-04_02-00-03.sql.gz (294499 bytes, modified: 2026-05-04 02:00:03)
- backup_v1.2.61_2026-06-02_19-30-59.sql (2178163 bytes, modified: 2026-06-02 19:30:59)

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: 12

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

6. Checking Error Logs...

7. Checking PHP Error Log...
PHP error log not found or not configured

=== 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