DWE ADMIN PORTAL
Douche Water Engineering/Database & SQL Export
AD

Database Management & SQL Export

Generate complete MySQL database scripts (`database.sql`), manage persistent collections, and review deployment packages.

Active Data Rows Summary
Products12
Categories8
Enquiries4
Blog Posts3
CMS Pages4
Sliders4

Generate & Download `database.sql`

Export the complete MySQL script containing all DDL CREATE TABLE statements, foreign keys, and DML INSERT records for immediate import into Hostinger phpMyAdmin or standard MySQL 8+.

Reset to Factory Demo Seed

Restores all sample data (SS Hemodialysis RO, DM Plants, Dow 8040 & Hydranautics 4040 membranes, 5000L SS Tanks, sample blog posts, and enquiries).

Hostinger Shared Hosting Quick Deployment Guide
1. Upload Files to Hostinger \`public_html\`Extract the standalone PHP package files directly into your \`public_html\` directory via Hostinger File Manager or FTP.
2. Create MySQL Database in hPanelGo to Hostinger hPanel → Databases → Create Database \`u123456_douchewater\`, username, and password.
3. Import database.sql in phpMyAdminOpen phpMyAdmin → Select your database → Click “Import” tab → Upload the downloaded \`database.sql\`.
4. Configure \`config/database.php\`Update DB_HOST, DB_NAME, DB_USER, and DB_PASS in \`config/database.php\`. The clean URL rewrites in \`.htaccess\` work out-of-the-box.