Magento – CMS data is lost but database backup

We have just created a new template is placed on our multi-store, which has a great installer…a very ambitious Installer. This has all the unasked “Home” CMS pages and overwrite the entire content was lost. Unfortunately, neither the manual nor anywhere else was a reference to this “Triviality”. So our total 5 Home pages have been lost CMS.

But since we, as befits- have made a database backup, nor was there a glimmer of hope to get back the original data and do not have anything new to.
Das Backup, which we had created on the Magento backend, is well known, a file.
This we have thus pulled to the local memory, Once unpacked and then e.g.. opened with PsPad.

Because here are just not enough data are included, must be sought for the right place.

In our case, we wanted

INSERT INTO `cms_page` VALUES

In this line, which can be extremely long- CMS are ALL information contained, who were in the shop. There are now quite sure that opportunities to import data quickly to the database. But since we needed only a certain area, We have sought the appropriate place. In our case we needed a CMS content and design of the XML.

Man kann, to create some order, a row into a new file copy and then sort. A CMS site starts with

(NUMBER, So e.g.. (1, or (2,

After we have taken is a certain structure in a row, falls on, here that all relevant information are relatively clearly structured. What is important to know:

The database dump are some characters, in the original file – it is a DB or export directly to the CMS content- are not included. Thus, e.g.. from a

\r\n a Line break
\” a
\’ a

This notice must be, if one takes the data from the dump and want to use again. The individual values ​​divided by a ‘,’ .

So it is looking for a bit and find, Select Area, move into a new file (I did it), sort by o.g. Features, o.g. Characters look and o.g. Characters, and then replace the contents again into the CMS.

Danke Backup!

Published by Covos

Since 2009 I have been working intensively with Magento. I started with the creation and operation of B2C stores. This was extended through my work in the logistics sector. This resulted first specialized B2E systems. Today I work day-a day with exciting B2C, B2B- and B2E projects and reports in this blog about challenges and give insider tips.

Leave a Reply

Your email address will not be published. Required fields are marked *