how to find cms content in backup file?

[jaysondotph]

lastweek, our website was hacked by someone. and he/she deleted one of page from the cms pages. all content and information was deleted.

 

and my question is, i have a full back-up of the website but how do i find the csm content where so i can restore the file deleted by hacker.

 

please help.

Edited April 30, 2013 by jaysondotph (see edit history)

[tdr170]

The CMS content is in the database not in the Prestashop files.

If you have a backup of the database you will find it there if not check with your provider and see if they have a backup.

In my database there is a tab for backups and you can download a backup from there.

[jaysondotph]

ah okay.. i try it to look up in the DB.. thanks a lot for your informative reply

[jaysondotph]

okay, i found the file. but it is verry crowded, is there other easy way to retrieve it?

[tdr170]

You will need to look through the file and find the following sections.

 

Table structure for table `pr_cms`

Table structure for table `pr_cms_block`

Table structure for table `pr_cms_block_lang`

Table structure for table `pr_cms_block_page`

Table structure for table `pr_cms_category`

Table structure for table `pr_cms_category_lang`

Table structure for table `pr_cms_lang`

 

These are all the tables that contain CMS information related to your site, you will need to copy all the sections and then do an SQL query and paste the code in the text area and run the query.

 

I use Notepad++ for this type of file and it is available for free.

 

If you are totally unsure post the file here and I will pull the tables you need to run the query on for you.

Edited April 30, 2013 by tdr170 (see edit history)