Database Size

{{ $this->getDatabaseSize() }}

Total Tables

{{ $this->getTotalTables() }}

Last Modified

{{ $this->getLastModified() }}

Database Type

{{ $this->getDatabaseType() }}

Database Statistics

Record counts for main tables

@foreach($this->getTableStats() as $table => $count)

{{ $table }}

{{ number_format($count) }}

@endforeach

Backup Information

Complete Database Backup

The backup includes all tables, data, and structure of your SQLite database.

Admin Only Access

Only users with admin privileges can access and download database backups.

Download Format

@if($this->getDatabaseType() === 'SQLITE') Backup is saved as: zhmary_inventory_backup_YYYY-MM-DD_HHMMSS.sqlite @elseif($this->getDatabaseType() === 'MYSQL') Backup is saved as: zhmary_inventory_backup_YYYY-MM-DD_HHMMSS.sql @else Backup format depends on your database type @endif

Restore Instructions

@if($this->getDatabaseType() === 'SQLITE') To restore, replace database/database.sqlite with your backup file. @elseif($this->getDatabaseType() === 'MYSQL') To restore, run: mysql -u username -p database_name < backup.sql @else Contact your system administrator for restore instructions. @endif

Important: Store backups securely. The backup file contains all your sensitive data including user information and business records.