I accidentally overwrote CMS pages when I migrated from M1 to M2. I still have the backup of the old M2. So my question is, where can I find the file location of the M2 CMS pages?

  • check under content > pages – Devidas Feb 27 '20 at 11:09
  • No I can't because they are gone. I have the backup. I'm thinking more like in folder file location in public_html. – Daniel Something Feb 27 '20 at 11:12
  • do you have M2 database backup ? – Pawan Feb 27 '20 at 11:14
  • Yes. Currently I'm trying to overwrite all old cms tables with new ones. So I think that should do the trick right? – Daniel Something Feb 27 '20 at 11:20
  • 1
    Yes, just dump table "cms_page" and "cms_page_store" from old database. – Pawan Feb 27 '20 at 11:30

If you have old database backup, You can just copy cms_page and cms_page_store table and import in new database.

just dump table "cms_page" and "cms_page_store" form old database

Hope above will help!

  • if anybody down vote, should take bother to write comment why down voting!..:) – Pawan Feb 28 '20 at 9:01

Just open your database managers like PHPMyAdmin or adminer and search for a table with the name cms_page (in your dumped back-up). And check every page via its name, for example, 404 Not Found. After this, you can see a column with the name "content" - its the content of this page, you can edit it. Screenshot example below. enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.