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!