WordPress Upgrade Follow Up Tutorial

WordPress Upgrade Follow Up Tutorial

WordPress Upgrade Follow Up Tutorial

WordPress has a great Export and Import plugin to help migrate data after you upgrade your WordPress version, perhaps.

This came to the fore yesterday when we started (there is a lot more to do) on that migration path going from WordPress version 3.0.3 to version 4.1.1 as you can read a bit about with WordPress Upgrade Primer Tutorial as shown below.

So the two parts to the Export and Import equation are …

  1. Export from WordPress 3.0.3
  2. Import into WordPress 4.1.1

… now you may naively think that you will be able to export once and import once, but various things may get in your way achieving that …

  1. the small settings for max_execution_time (eg. 30 should be temporarily 360) and max_input_time (eg. 60 should be temporarily 120) and memory_limit (eg. 70M should be temporarily 128M) in php.ini need to suit the memory requirements needed to create the Export file you upload to the live server
  2. even fixing requirement for step 1 you may (or the symptom of needing to do something as advised in step 1), as you Export, get the PHP error message “Fatal error: Maximum execution time of ? seconds exceeded in …” … where ? was 30 for us here … this error message will appear in the last line of the Export file so
    tail -2 wordpress.2014-04-01.2014-07-01.xml
    would have been a Linux programmatical way of checking for the scenario shown a bit below
  3. the small settings for upload_max_filesize (eg. 2M should be temporarily 32M) and post_max_size (eg. 8M should be temporarily 32M) in php.ini need to suit the size of the Import file you upload to the live server
  4. even fixing requirement for step 3 you may (or the symptom of needing to do something as advised in step 3), as you Import, get the PHP error message “Fatal Error: Allowed Memory Size of ? Bytes Exhausted” … where ? is a fairly big number … and this error message may show on your web page window

So it is probably better to do this job in chunks. We think if there is a blog posting each day a three month span (or perhaps one month span) of Export could be good if comments are included as well. And how to exclude the comments? Supposing your Start Date is April 2014 and End Date is June 2014 then, at Linux …


$ cat wordpress.2014-04-01.2014-07-01.xml | sed '/^[ \t]*<wp:comment>/s//<wp:comment>/g' | sed '/^[ \t]*<\/wp:comment>/s//<\/wp:comment>/g' > xwordpress.2014-04-01.2014-07-01.xml
$ cat xwordpress.2014-04-01.2014-07-01.xml | awk '/<wp:comment>/,/<\/wp:comment>/' > comment_2014_4.xml
$ comm -23 xwordpress.2014-04-01.2014-07-01.xml comment_2014_4.xml > no_comment_2014_4.xml

… would result in a suitable no_comment_2014_4.xml to Import into the WordPress MySql database. We thank this link and this link and this link.

More WordPress upgrade information tomorrow. Thanks for reading.


Previous relevant WordPress Upgrade Primer Tutorial is shown below.

WordPress Upgrade Primer Tutorial

WordPress Upgrade Primer Tutorial

It’s early days, and there is more to be done, but here at this WordPress blog we’re transitioning to version 4.1.1 from 3.0.3

Three major decisions involved …

  1. Do I keep the same theme?
    • This one depends a bit, and we feel the answer stems from how you go piecing together on a local MAMP web server, for the MacBook Pro example, and how long you think it would take to transition in a change of theme. With this upgrade we tinkered with themes Twenty Fourteen, Twenty Thirteen and Twenty Fifteen with degrading success, and plumped instead to reinstall our previous theme Twenty Ten. Think it was a good decision, as if you are sticking with WordPress default themes, Twenty Ten is still a good theme in my opinion. Of course, you may have your own theme you like in mind and then you should invest the hours it will take to transition all the styling changes inherent in a shift of theme.
  2. Do I change the permalink arrangement?
    • In our previous WordPress blog we were using the default “?p=[postId]” arrangement which the search engines do not like … and you can understand why, in that to glean the best categorization of a webpage’s content gist, the search engines have to parse the whole page, whereas a permalink arrangement such as …

      /%postname%/

      teamed up with a meaningful title, can tell a search engine so much about the webpage content just from its URL. So we went ahead and tried for the best option we’d read about, as above, and it all worked well at MAMP but getting to the live server we needed the great advice of this link from a WordPress forum, and it panned out for us that the WordPress install was doing everything right as far as its “.htaccess” file was concerned, but in our “httpd.conf” Apache configuration file we needed to specify …

      <Directory [path to new WordPress document root directory]>
      # ... other directives...
      AllowOverride All
      </Directory>

      to make things better
  3. Do I filter comments more?
    • Definitely that would be good, and the great choice is between the Akismet plugin and Captcha option, or both, and as we suspected, we think more people like Akismet here, and I’ve always liked it more too, because Captcha excludes some users from ever accessing your blog. Akismet was already installed with WordPress, and activation for a personal blog like this one just involves getting an API_KEY from Akismet … so thanks a lot.

As you may imagine, this is an ongoing story, with more twists and turns to come. Hope you’ll join us for more information into the future, and hope to see you back at the new blog soon.

If this was interesting you may be interested in this too.


If this was interesting you may be interested in this too.

This entry was posted in Data Integration, eLearning, Installers, Tutorials and tagged , , , , , , , , , , , , , , , , , , . Bookmark the permalink.

21 Responses to WordPress Upgrade Follow Up Tutorial

  1. Abigail says:

    Thanks for another magnificent post. Where else could
    anyone get that type of info in such a perfect manner of writing?
    I have a presentation subsequent week, and I am on the search for such information.

  2. Nila says:

    Hi there, its pleasant post about media print, we all understand media is a great source of information.

  3. Erasmo Burm says:

    Hi there very cool web site!! Guy .. Excellent .. Amazing .. I’ll bookmark your website and take the feeds also…I’m glad to find a lot of helpful information here within the post, we need develop extra strategies in this regard, thanks for sharing.

  4. whoah this blog is magnificent i really like studying your articles. Keep up the good work! You already know, many individuals are searching round for this information, you can help them greatly.

  5. Elizabeth says:

    CzeΕ›Δ‡, ciekawy tekst. Dawno nie widziaΕ‚em tak interesujΔ…cego pisarstwa.

  6. quite nice post, i undoubtedly adore this wonderful site, carry on it

  7. Hello.This post was really fascinating, especially since I was looking for thoughts on this matter last Saturday.

  8. Carpet Tiles says:

    Wow! Thank you! I always wanted to write on my website something like that. Can I include a fragment of your post to my website?

  9. Real Estate says:

    I think other site proprietors should take this web site as an model, very clean and excellent user friendly style and design, let alone the content. You’re an expert in this topic!

  10. I simply wanted to construct a note to say thanks to you for all of the unique techniques you are writing at this website. My time consuming internet search has finally been paid with high-quality insight to talk about with my classmates and friends. I would assert that most of us site visitors actually are really endowed to dwell in a perfect network with so many brilliant people with valuable basics. I feel pretty blessed to have discovered your web pages and look forward to plenty of more excellent times reading here. Thanks once more for all the details.

  11. Awsome website! I am loving it!! Will come back again. I am bookmarking your feeds also

  12. Truck says:

    I and my friends were analyzing the excellent tricks located on your web page and then before long got an awful suspicion I never thanked the web site owner for those techniques. All the guys became consequently glad to see all of them and now have in actuality been enjoying those things. Thank you for simply being so considerate as well as for considering this kind of quality ideas millions of individuals are really needing to be informed on. My personal honest apologies for not expressing gratitude to you sooner.

  13. events says:

    Anyways many thanks for your ideas. I value it. Please make more posts related to this

  14. It’s the best time to make some plans for the future and it’s time to be happy. I’ve read this post and if I could I desire to suggest you some interesting things or tips. Perhaps you can write next articles referring to this article. I desire to read even more things about it!

  15. Bonjour ! Que de souvenirs….Le bon vieux temps des pur site

  16. What i don’t understood is in reality how you’re now not really much more smartly-appreciated than you might be now. You’re very intelligent. You realize thus significantly in the case of this topic, made me in my opinion imagine it from numerous numerous angles. Its like men and women don’t seem to be involved until it is one thing to do with Woman gaga! Your own stuffs great. At all times maintain it up!

  17. Wanda Lucken says:

    I as well as my pals were really taking note from the wonderful solutions positioned on the web site then all on the sudden I had an awful feeling I never thanked the blog owner for those secrets. These guys came totally thrilled to study them and currently have honestly been possessing fun with those items. Thanks for turning out to become effectively valuable and after that for opting for some decent subject areas the majority of people are genuinely desirous to discover. My sincere apologies for not expressing gratitude to earlier.

  18. Thanks for the write up! Also, just a heads up, your RSS feeds aren’t working. Could you take a look at that?

  19. experienced says:

    certainly, analysis is paying off. Adoring the posting.. thanks a bunch Enjoying the post.. thank you So happy to have found this submit..

  20. light says:

    My personal searches seem total.. thanks. Enjoy the posting you furnished.. So happy to get identified this article.. Adoring the document.. best wishes

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>