PolyCMS Database Backup & Restore

Last updated on Jul 10, 2026 4:18 AM

Overview

PolyCMS includes a dedicated Database Backup & Restore tool that creates SQL snapshots of only the CMS tables (all 16 blog_* prefixed tables). Your Perfex CRM client data, invoices, projects, and other module data remain completely untouched.

Creating a Backup

Navigate to Blog > Tools > Backup:

Click Create Backup.
PolyCMS generates a SQL dump file containing all 16 CMS tables.
The backup file is saved and listed on the Backup page with timestamp and file size.
Download the .sql file for off-site storage.

What Gets Backed Up

The backup includes all CMS-specific tables:

Table Group	Tables
Content	`blog_posts`, `blog_pages`, `blog_page_meta`
Taxonomy	`blog_categories`, `blog_tags`, `blog_post_categories`, `blog_post_tags`, `blog_post_meta`
Engagement	`blog_comments`
Navigation	`blog_menus`, `blog_menu_items`, `blog_widgets`
Extensions	`blog_plugins`, `blog_plugin_options`, `blog_themes`, `blog_theme_options`
Configuration	`blog_settings`, `blog_permalink_settings`

Restoring from Backup

Navigate to Blog > Tools > Backup.
Select a backup file from the list.
Click Restore.
Confirm the restoration. Existing CMS data will be replaced with the backup contents.

Warning: Restoring a backup replaces all current CMS data. Create a fresh backup before restoring to preserve the current state.

Best Practices

Create backups before major content changes or theme/plugin updates.
Store backup files off-site (cloud storage, local drive) for disaster recovery.
Test backups periodically by restoring to a staging environment.
Backup files contain only CMS data — CRM data requires separate backup procedures.