Navigable PDF Presentation of WordPress Migration Tutorial
โœ‚๐Ÿƒ๐Ÿพโ€โ™€๏ธ๐Ÿƒ๐Ÿผโ€โ™‚๏ธ
๐Ÿ“–

Navigable PDF Presentation of WordPress Migration Tutorial

Navigable PDF Presentation of WordPress Migration Tutorial

Thereโ€™s a bit of a dual purpose tutorial going on today, the dual purposes being โ€ฆ

  • Showing you some WordPress Migration tactics, again, but this time involving Windows (local Apache/PHP/MySQL web server) MAMP, as distinct from the conditions during the previously discussed WordPress Upgrade Crontab Curl Tutorial โ€ฆ and โ€ฆ
  • Navigable PDF, via hashtagging, in an HTML iframe approaches to presentation

That latter purpose was a bit of a doh! moment for us, as weโ€™d neglected to use this useful hashtagging technique of defining a URL like โ€ฆ

//www.rjmprogramming.com.au/MAMP/wordpress_populate.pdf#page14 ... or ... //www.rjmprogramming.com.au/MAMP/wordpress_populate.pdf#page=14

โ€ฆ ever in the past โ€ฆ as the src= value in an HTML iframe element (but weโ€™ve found cross-browser issues, so weโ€™ll also be supplying an HTML a link equivalent to show PDF in new window) to show (how we made HTML blog posting editing mode be the default over the installed default setting of Visual edit mode, via a change to the Twenty Seventeen themeโ€™s function.php as mentioned in that previous Tablet Run Web Server Blog PHP Tutorial as shown below โ€ฆ thanks to this useful link for the advice here) โ€ฆ

//www.rjmprogramming.com.au/MAMP/wordpress_populate.pdf#page14 or //www.rjmprogramming.com.au/MAMP/wordpress_populate.pdf#page=14

โ€ฆ as an alternative to just displaying that (in) image(s) as per โ€ฆ

Page 14
Page 15

We want to point out an advantage here of there being less files needing to go over to the web server to achieve any sequence of display items you care to think of. Versus a disadvantage is that it involves a more resource hungry set of circumstances for the web browser. However, this resource hungriness is offset by caching you have going, because hashtag (#) navigation can use whatever is in the (web browser) cache from a previous hashtag (#) URL mentioning that one โ€œcollectiveโ€ PDF โ€œviewโ€ of all the โ€œimageryโ€ the once. Come to think of it in this way, and perhaps the โ€œnavigable PDFโ€ approach is less resource hungry?!

Now what about the WordPress migration today? Whatโ€™s new with the approaches? Because we are talking WordPress posts and pages to WordPress (on MAMP) posts and pages, we think just stick with the โ€ฆ

โ€ฆ though โ€ฆ

  • it says for the WordPress Importer it has not been tested for this recent WordPress release โ€ฆ and โ€ฆ
  • there are quite a few third party plugins that might do a good job, but finding a pairing of Exporters and Importers that had been tested for both the โ€œdata fromโ€ and โ€œdata toโ€ WordPress versions seemed difficult to find

โ€ฆ and thatโ€™s where the configuration of php.ini regarding POST_MAX_SIZE and UPLOAD_MAX_FILESIZE settings (being far too low by default, just for this migration task) only on the Importer side, becomes important, and therefore weโ€™d like to direct you to this slide โ€ฆ

//www.rjmprogramming.com.au/MAMP/wordpress_populate.pdf#page9 or //www.rjmprogramming.com.au/MAMP/wordpress_populate.pdf#page=9

โ€ฆ to see some of the โ€ฆ

  • use of MAMP โ€œPropertiesโ€ to determine a PHP version
  • stop MAMP servers
  • edit the appropriate MAMP php.ini
  • start MAMP servers
  • proceed with WordPress (migration) import of Exported XML data via WordPress Importer plugin

Here is a PDF slideshow showing some of this. Bear in mind, this export then import migration task relates only to the transfer of category, tag, post and page MySQL data information from one rjmprogramming.com.au domain WordPress MySQL database to MAMPโ€™s WordPress MySQL database. So, yes, this job might be undertaken at a MySQL database migration level (perhaps involving the โ€œgive us a Pโ€ โ€ฆ P โ€ฆ โ€œgive us an โ€œHโ€ โ€ฆ H โ€ฆ you know what we mean โ€ฆ phpMyAdmin), but that is not how we have โ€œrolledโ€ today. Again, like yesterday, and the day before it comes via the use of HP PhotoSmart Premier software suite via the creation of a project and then shaping to Print this, and picking the Microsoft XPS Writer printer (and once again thanks to Free online XPS to PDF converter).



Previous relevant Tablet Run Web Server Blog PHP Tutorial is shown below.

WordPress Twenty Seventeen Theme on MAMP on Windows Install Tutorial

WordPress Twenty Seventeen Theme on MAMP on Windows Install Tutorial

Today, we follow up on yesterdayโ€™s MAMP on Windows Primer Tutorial as shown below, by installing a WordPress.org (as distinct from the WordPress hosted WordPress.com) blog onto Windows via a local MAMP local web server, and using the current default WordPress theme called โ€ฆ you guessed it โ€œTwenty Seventeenโ€.

This Twenty Seventeen theme, by default, we notice, constructs blog postings in non-HTML mode, which could please those users wanting to ease their way into learning HTML as they start blogging. But we noticed changing the โ€œFind Usโ€ Contact Page details, there the HTML was, so am still strongly advocating that you learn some HTML anyway.

Roughly speaking, the steps involved were โ€ฆ

  1. Download from WordPress.org the blog installer in the form of a zip file, which you can decide to Open directly, or save to your Windowโ€™s user Downloads folder, and then double click โ€ฆ to โ€ฆ
  2. Open your default unzipper (WinZip here) via right click and Open Withโ€ฆ WinZip โ€ฆ
  3. Click Extract โ€ฆ
  4. Type in โ€œC:\MAMP\htdocs\โ€ ( ie. MAMP document root, equates to //localhost:8888/ ) as the place to extract to โ€ฆ
  5. In Windows Explorer, to rename the C:\MAMP\htdocs\wordpress directory now would affect the URL we talk about below โ€ฆ but we assume in all that follows that you stuck with โ€œwordpressโ€ here โ€ฆ
  6. In your web browser (we have Google Chrome today) type in URL of //localhost:8888/wordpress โ€ฆ
  7. Choose main language (and we choose English) โ€ฆ
  8. That being the case we opened //localhost:8888/MAMP/index.php?page=phpmyadmin&language=English to start up the incomparable, the never before seen in this country at this time and in these weather conditions, โ€œphpMyAdminโ€ to, if you havenโ€™t already done so โ€ฆ
  9. Click the โ€œNewโ€ (database) link โ€ฆ
  10. Fill in the new name for a database (and we use โ€œwordpressโ€ here) โ€ฆ
  11. Click the โ€œCreateโ€ button โ€ฆ which creates a shell of a MySQL database ready for the WordPress install to โ€œinfillโ€ with data โ€ฆ
  12. Meanwhile back at the //localhost:8888/wordpress install webpage (assuming you clicked the button after the Language selection) you fill in a form, primarily detailing the blog โ€ฆ
    • Database name (for us, โ€œwordpressโ€)
    • Database username (default, for MAMPโ€™s MySQL is โ€œrootโ€, so we are showing that)
    • Database password (default, for MAMPโ€™s MySQL is โ€œrootโ€, so we are showing that, but, obviously, it is good to change default passwords)
    • Database host (default, for our MAMP, but not necessarily for yours is localhost:8899 โ€ฆ as we explained yesterday โ€ฆ install default is โ€œlocalhostโ€)
    • Database table prefix (their โ€œwp_โ€ prefix we are happy with โ€ฆ which would infer, for example that post data would reside in localhost:8899โ€™s database called โ€œwordpressโ€ in table โ€œwp_postsโ€)

    โ€ฆ and when filled out click button to proceed

  13. Click the โ€œRun the installโ€ button โ€ฆ
  14. Then you get to a form about an administrator username and password and website title and email address โ€ฆ please do not have easy passwords except those suggested by WordPress for internal use only โ€ฆ MAMP is a good place to sort all these issues out before going live โ€ฆ after which you click the button to proceed
  15. And so you get to a WordPress administrator login screen where those details above come into play, and from then on, you are more or less on your own administering this //localhost:8888/wordpress/ blog โ€ฆ and for a few slides โ€ฆ
  16. We skim the surface of administering the WordPress blog where we โ€ฆ
    • show you some theme alternatives to the default Twenty Seventeen theme we plump for โ€ฆ
    • change the โ€œFind Usโ€ address at the Contact Us menu webpage โ€ฆ
    • create a small inhouse posting, when we discovered the default mode of (blog post) creation appears to be no longer HTML (as it is for good olโ€™ Twenty Ten theme โ€ฆ cough, cough) โ€ฆ but โ€ฆ
    • Everything was there via the Add Media button and a Paragraph button for us to construct a short diatribe about Beethovenโ€™s Fifth posting involving some words and an image (added during the โ€œAdd Mediaโ€ button press)

And so there you have some โ€ฆ

  1. Blog
  2. CMS
  3. WordPress install
  4. MySQL database management via phpMyAdmin
  5. WordPress Blog Post creation
  6. Local web hosting

โ€ฆ but if you are web hosting yourself, with a live blog, on Apache/PHP/MySQL at least, you need to know bits and pieces (all talked about at this blog in varying degrees of detail), in addition to bit more above โ€ฆ

  • (s)ftp
  • ssh
  • cPanel
  • phpMyAdmin

โ€ฆ and then, the nice to haves, or develop, are โ€ฆ

  • HTML
  • Javascript
  • CSS
  • Linux (or Unix)
  • Apache configuration (eg. .htaccess usage and robot.txt)
  • crontab
  • MySQL off the command line
  • Google Webmaster
  • get better at SEO than we are
  • PHP
  • Python
  • Perl
  • ImageMagick
  • GD in PHP

Constructing our PDF presentation of the steps above weโ€™d like to thank โ€ฆ

Enjoy todayโ€™s slideshow.


Previous relevant MAMP on Windows Primer Tutorial is shown below.

MAMP on Windows Primer Tutorial

MAMP on Windows Primer Tutorial

Have you noticed when you revisit websites from long ago lots of times functionality regarding platform flexibility has moved on. Web server products in particular are of more benefit to us all if they support multiple platforms.

In that regard we are happy to break a โ€œmythโ€ that had developed in my mind that the wonderful MAMP local Apache/PHP/MySQL web server was just for use with Mac OS X. It might have been me dreaming, but in any case, it can be used on Windows, currently version 3.2.2.

It behoves us, though, to take a step back and explain why this interest? Letโ€™s just take the concept of a local web server first. We think โ€ฆ

Local web servers are the best way to test code destined for a real and live web server open to the public to test web applications both for the logic and coding within them, and to get close to testing for similar environmental circumstances

โ€ฆ and sorry to break it to you, but short of Ansible type of deployment thinking it is not good to be more definitive about โ€œenvironmentalโ€ simulation, than the sentence above. Think itโ€™s not worth this โ€œlocal web serverโ€ bother? For all else, but totally trivial coding, like you may be able to achieve via Javascript, within a blog posting itself (and this is not really advised by the big players anyway), it is just not a good idea not to have tested a web application locally first, especially if it is a serverside language like PHP or ASP.Net โ€ฆ and yes, noticed with the MAMP on Windows install, that .Net Framework comes into the equation.

Now letโ€™s โ€œplonkโ€ on top of that in our thinking, and this is the motivation for a lot of user interest out there, what about โ€œhow to go about developing a WordPress blog from go to wo (hopefully not woe โ€ฆ chortle, chortle)โ€? The same goes here in our mind โ€ฆ

Local web servers are the best way to test products you install from third parties, such as blogs and forums and chatrooms and CRM and CMS websites, destined for a real and live web server open to the public to test web applications both for the logic and coding within them, and to get close to testing for similar environmental circumstances

โ€ฆ to which it would be legitimate to question, given web server interfacings like cPanel (hosting platform) to go with managing an Apache/PHP/MySQL web server, that that sounds like โ€œoverkillโ€ given cPanel has options to install blog products like WordPress within its menus. We would say to that, that, yes, it has a good chance of working if you use cPanel, that is true, but we would see that it is not going backwards, nor costing any money, with a lot of the products, to โ€œtest runโ€ them on a local web server, and when satisfied, or not, use cPanel, or some other (s)ftp file transfer approach to get that product up live and running.

Add to that for us, is that weโ€™ve had only the smallest of working problems with MAMP on Mac OS X for many years now, and so weโ€™d have to describe it as โ€œrobustโ€, and it has an associated MySQL database interface product called phpMyAdmin which is so good itโ€™s thinking of inventing a โ€œphpMyAdmin soupโ€.

So that leaves, for us, why move off the EasyPHP (local (WAMP) Apache/PHP/MySQL web server) for Windows product. After all, we readily admit to no issues with EasyPHP here, but we feel that to progress with knowledge, and not let โ€œplatform confusionโ€ overcome you, you should learn as much as possible about what is out there as an alternative. After all, even though it may not work with your Windows, it did for me, to have the following MAMP ports hold true โ€ฆ

  • Apache listener on port 8888
  • MySQL listener had a clash on our preferred port 8889 (like it is for Mac OS X), but we had no problem with using port 8899

โ€ฆ which, to many many intents and purposes makes your work coming off Mac OS X local web server work, look heaps (โ€œexactlyโ€, if no MySQL connections involved in the code) like your work, perhaps, moving over to, or even integrating with a Windows local web server with the same โ€œMAMPโ€ (robust) product name.

In short, if you โ€œwant to learnโ€ WordPress Iโ€™d recommend, strongly, the use of a local Apache/PHP/MySQL web server product like MAMP, whether you are using Mac OS X or Windows.

In long trousers, now, if you โ€œwant to learnโ€ WordPress Iโ€™d recommend, strongly, to learn some HTML. If you have a local web server, and install WordPress to a local web server, and you are only starting out with PHP, there is a double whammy advantage that you will see PHP WordPress code they talk about at WordPress Codex, the online manual for WordPress code.

But to today, and also with WordPress 4.1.1โ€™s MAMP on Windows Primer Tutorial, and all we did, was โ€ฆ

  • Visited the MAMP website โ€ฆ noticed its Windows interface โ€ฆ new to us โ€ฆ so โ€ฆ
  • Got on Windows โ€ฆ and installed โ€ฆ
    MAMP on Windows install 1 of 2
    MAMP on Windows install 2 of 2
  • Started it up and realized Apache started but MySQL didnโ€™t โ€ฆ so did a bit of research at this useful link, thanks โ€ฆand so โ€ฆ
  • Changed MAMP Properties so that MySQL listener port would be changed from the 8889 we had to 8899 โ€ฆ restarted โ€ฆ success

Below is another way to summarize the work above โ€ฆ in pictures โ€ฆ yes, an animated GIF, so popular on websites like Tumblr โ€ฆ and able to be constructed quite well on Gifpal, but, today, we are showing you having been constructed inhouse via the techniques that feature PHP writing PHP of Animated GIF via PHP Writing PHP Primer Tutorial โ€ฆ for your perusal โ€ฆ

MAMP on Windows Animated GIF style


Previous relevant Animated GIF via PHP Writing PHP Primer Tutorial is shown below.

Animated GIF via PHP Writing PHP Primer Tutorial

Animated GIF via PHP Writing PHP Primer Tutorial

We find another very useful reason for PHP to write PHP. Today we establish a PHP web application to dynamically create Animated GIF images via some still images, like Gifpal would do.

We have some great open source PHP code to thank for the basis of the functionality we found at Jeroen van Wissenโ€™s very useful link, thanks.

Then we added a more user friendly interface to get the information off the user we need. We present this in an HTML form, which navigates to the same PHP to do the actual assembly of the Animated GIF via techniques where PHP writes PHP โ€ฆ and really needs to, to be useful.

Do you remember, last, when we did some PHP writing PHP functionality โ€ฆ PHP Writes PHP Vertical TextBoxes Primer Tutorial?

And inside the PHP it makes big use of the GD and Image Functions to read and write the image data we assemble via the user information.

This Animated GIF form of animation is the easiest to implement, as it consists of just the one GIF image file, but the user has very little control over the animation settings, such as the delay between stills, one of the settings we ask about in our web application.

Our PHP source code today you could call tutorial_to_animated_gifโšซphp and we redirect you to some live run ideas โ€ฆ

  • normal run with HTML form which posts back to itself โ€ฆ liveโœ‚run
  • example GET parameters run (like our tutorial picture)

Hope you find this tutorial useful.

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


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


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 Database, eLearning, Tutorials and tagged , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink.

Comments are closed.