HeadRandom
Back to Main Site

PolyCMS Database Backup & Restore

Last updated on May 15, 2026 11:20 PM

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:

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

What Gets Backed Up

The backup includes all CMS-specific tables:

Table GroupTables
Contentblog_posts, blog_pages, blog_page_meta
Taxonomyblog_categories, blog_tags, blog_post_categories, blog_post_tags, blog_post_meta
Engagementblog_comments
Navigationblog_menus, blog_menu_items, blog_widgets
Extensionsblog_plugins, blog_plugin_options, blog_themes, blog_theme_options
Configurationblog_settings, blog_permalink_settings

Restoring from Backup

  1. Navigate to Blog > Tools > Backup.
  2. Select a backup file from the list.
  3. Click Restore.
  4. 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.

Related Documentation