Containerized WordPress/WooCommerce Database Restore
An e-commerce / retail brand
Overview
A reproducible local build that stands up an existing WordPress/WooCommerce store’s database for inspection and migration work. A Docker Compose stack restores a full SQL dump into MariaDB and exposes it through phpMyAdmin for browsing and verification.
Why It Exists
To safely recreate a production WordPress storefront’s data layer in an isolated local environment, useful for auditing, content/locale migration, and troubleshooting without touching the live site.
What We Built
A docker-compose.yml defining two services: a MariaDB 11.8 instance that auto-imports cooltoralia.sql via the container init directory, and a phpMyAdmin 5.2 console for inspection. The dump itself is a complete WordPress schema, wp_* core tables plus WooCommerce, the full WPML multilingual stack (wp_icl_* translations, string packages, language tables), Elementor submissions (wp_e_*), and Action Scheduler, indicating a multilingual e-commerce/marketing site.
Technologies & Approach
Docker Compose for one-command provisioning, MariaDB for the data layer, and phpMyAdmin for ergonomic inspection. Restoring from a SQL dump keeps the reproduction faithful to production state.
Outcome / Impact
Proved that the client’s multilingual WooCommerce store could be reliably reconstituted locally for analysis and migration planning, with the WPML translation data intact and queryable.
Capabilities Demonstrated
- One-command local reproduction of production WordPress/WooCommerce stores
- Database restore and inspection workflows (MariaDB + phpMyAdmin)
- Working knowledge of WPML multilingual and Elementor data models
- Docker Compose-based dev environments