mysql - Recover Magento Static Block content from backup? -

-

With my work in progress, I had big problems with the Magento site so decided to start from scratch again.

I have rebuilt static blocks, HTML & amp; Text) Before recovering, is the file system recoverable from backup?

I have taken a look through the file system but it does not seem to be archived.

I also have a database backup, but due to problems before it is installed again it has not to be restored.

Can anyone tell me if it is possible to get static block content from your backup and if so, how?

Thanks in advance!

Yes, all CMS pages and block contents are stored in the database and easily Can be recovered from. I had to do this before

  • To get an idea of ​​structure and column contents, check the following tables in phpMyAdmin:

    • CMS block cms_block
    • CMS Pages cms_page

    for both content Column found in the layout, layout_update_xml and custom_layout_update_xml columns found in the CMS page layout .

    Take a look at other pillars to decide and what you need to remove.

    Now, if you use a 7-zip on Windows, or basic command line tools, unplug your database dump and use a programming text editor that will allow large text files like See table name (in this case, cms_block ) which can handle TextPad .

    There will be two SQL code class (similar to the sample given below), first the cms_block table, adds the second content. 

      - - Table structure for table 'cms_block` - If empty table `cms_block`; / *! 40101 SET @saved_cs_client = @@ character_set_client * /; / *! 40101 SET character_set_client = utf8 * /; Table `cms_block` (create` block_id`) SMALLINT (6) No NULL AUTO_INCREMENT,` title` varchar (255) No NULL default ', `identifier` varchar (255) No NULL default',` content` mediumtext, `CREATION_TIME` datetime Default zero, `update_time` datetime default zero,` is_active` tinyint (1) No NULL default '1', primary key (`block_id`) engine = InnoDB AUTO_INCREMENT = 134 default charset = UTF8 comment = 'CMS blocks'; / *! 40101 SET character_set_client = @saved_cs_client * /; - - Dumping data for table `cms_block` - type lock tab` cms_block '; / *! 40000 Optional Table `cms_block` Disabled Keys * /; Insert in `Cms_block` values ​​(LongUglyContentStringHere); / *! 40000 optional table `cms_block` enabled key * /; Unblock Tables;

    We are interested in the INSERT cms_block VALUES line, which may be for a long time that your text editor might be able to assimilate it. Could. Cut that line, paste it into another document, turn on word wrap and search for identifier or search for some unique content in the block. Records in this block are surrounded by brackets and commas (record x), (record), (records) .

    In the sample, we have the record contained in the brackets: value-match and here: 

      (40, 'value matching', 'value- Match ',' & lt ;! - Match Entry Form - & gt; \ r \ n & lt; h3 & gt; We will match or beat any competitors price; / h3 & gt; \ r \ n & lt; p & gt; you must be an authorized dealer to get a better price for an item of Nanother \ r \, price adjustments may be made to \ r \ n similar items apply. items new product lead time Can vary A. You will \ "price match \" tab will \ value adjustment r \ n product page with a submission form. & Lt; / p & gt; ',' 2012-01-27 06:11:04 ' , '2012-01-31 05: 28: 16', 1)

    from phpMyAdmin that you collect for help in retrieving column form and content, but its originally block_id, title, id is surrounded by Entifier, content and brackets with single quotation string boundaries and comma separator.


Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

java - Gradle dependencies: compile project by relative path -

-
Is it possible to specify a dependency on another gradeal project in the granular (in android studios) outside the current project limits? For example, with a relative path like this: dependence {collection project ('../../ stdlib / dagger'}} MyApp (path / user / foo / workspace / mypad) The app (Path / User / Foo / Workspace / MyPass / App) And I have an Android Library Project with 3 subdomules: stdlib (path is / user / foo / Utilities (Path / User / Foo / Workspace / Stadlib / Utilis) http (Path / User / Foo / Workspace / Stadlib / HT) / Li> What I have to do is compile the Dagger, Util, http module in the MyApp project. The Stidelib Library module under heavy development And MyApp will grow in the form of Growth, so I do not want to push them into a Mewen repository. I am a little change. is likely to add another Gredle projects in some way? I will push the study library into the Maven repository after the source is in search of a temp...
Read more

ruby on rails - Object doesn't support #inspect when used with .include -

-
So I have participated in a glitch error that I do not even know how to debug. I am very new to the railing, so it has kicked my ass well when I use the .includes (school) seen by the student, it gives a blue box error, But when I look at any other model and .includes (school) , the school works just fine. class student & lt; ActiveRecord :: Base has has_many: relationships, foreign_key: "liker_id", dependent :: has_many: matches, foreign_key: "student_1_id", dependent :: deleted belong_to: school belong_to: conference belong_to: would_you_rather belong_to: home city belong_to: year is_to: Major and class school & lt; on the console activatecord :: Affiliate for the base: conference includes: respondent, class: "school", foreign_key: "rival_id" (e.g. For: School) Select SQL generated Select "School". * "School" from "school" "ID" IN (1) error message back NoMethodError: u...
Read more