Skip to content

Instantly share code, notes, and snippets.

@jerrylopez

jerrylopez/clear_cms.sql

Created June 12, 2014 18:42
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jerrylopez/348e3aa8734cc861dc21 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jerrylopez/348e3aa8734cc861dc21 to your computer and use it in GitHub Desktop.
Download ZIP
Clear the CMS Static Blocks and Pages from Magento database in one swoop!
Raw
clear_cms.sql
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `cms_block`;
TRUNCATE TABLE `cms_block_store`;
TRUNCATE TABLE `cms_page`;
TRUNCATE TABLE `cms_page_store`;
SET FOREIGN_KEY_CHECKS = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment