{"id":1380,"date":"2009-03-03T23:28:38","date_gmt":"2009-03-03T23:28:38","guid":{"rendered":"http:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm"},"modified":"2009-03-05T22:07:20","modified_gmt":"2009-03-05T22:07:20","slug":"installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm","title":{"rendered":"Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags)"},"content":{"rendered":"<p>Last week I wrote about <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2009\/02\/installing-wordpress-on-a-mac.htm\">installing WordPress on a Mac<\/a> but I wanted to follow that up with a post on what happened next.<\/p>\n<h3>Installing phpMyAdmin<\/h3>\n<p>Installing WordPress is all very well, but it&#8217;s good to be able to manipulate the database.  The command line mysql tools would have worked but a graphical interface (even an ugly one with bizarre icons) is often easier, so I installed <a href=\"http:\/\/www.phpmyadmin.net\/\">phpMyAdmin<\/a> as described by <a href=\"http:\/\/www.nino-net.org\/2008\/12\/install-mysql-and-phpmyadmin-on-mac-os-x-leopard\/\">Nino M\u00c3\u00bcller<\/a>:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.phpmyadmin.net\/home_page\/downloads.php\">Download the latest version of phpMyAdmin<\/a> (I used v3.1.2).<\/li>\n<li>Extract the files to ~\/Sites\/phpmyadmin.<\/li>\n<li>Copy config.sample.inc.php to config.inc.php and edit the Blowfish secret (the line which reads <code>$cfg['blowfish_secret'] = ''; <\/code>.<\/li>\n<li>Navigate to http:\/\/localhost\/~<em>username<\/em>\/phpmyadmin and login.<\/ul>\n<\/li>\n<p>Unfortunately, after attempting to logon, I was presented with an error message:<\/p>\n<p><em>#2002 &#8211; The server is not responding (or the local MySQL server&#8217;s socket is not correctly configured)<\/em><\/p>\n<p>Following <a href=\"http:\/\/www.hackido.com\/2008\/12\/phpmyadmin-on-os-x-leopard.html\">The Vince Wadhwani&#8217;s advice at his Hackido site<\/a> I typed <code>mysqlconfig --socket<\/code> to verify the socket is in use for MySQL (e.g. \/tmp\/mysql.sock) but I couldn&#8217;t find a config.default.php file (or the equivalent entry in my config.inc.php file) to adjust the socket.  <a href=\"http:\/\/friendsofed.infopop.net\/4\/OpenTopic?a=tpc&#038;s=989094322&#038;f=8033053165&#038;m=1461036951\">A post at Friends of ED suggested creating a symbolic link for the socket<\/a> and it seemed to work for me:<\/p>\n<p><code>sudo mkdir \/var\/mysql<br \/>\nsudo ln -s \/tmp\/mysql.sock \/var\/mysql\/mysql.sock<\/code><\/p>\n<p>Following this I could log into phpMyAdmin (although I still have a warning message that phpMyAdmin cannot load the mcrypt extension &#8211; this doesn&#8217;t seem to be causing any problems though).<\/p>\n<h3>Importing a WordPress database<\/h3>\n<p>Using phpMyAdmin on my web host&#8217;s server, I exported the database from the live copy of markwilson.it and attempted to import it on the Mac.  Unfortunately this didn&#8217;t work as my database was too large for PHP to upload &#8211; as confirmed by creating a file named ~\/Sites\/phpinfo.php containing <code>&lt;?php phpinfo(); ?&gt;<\/code>, then viewing it in a browser (<code>http:\/\/localhost\/~<em>username<\/em>\/phpinfo.php<\/code>) and looking for the upload_max_filesize variable.<\/p>\n<p>Rather than messing around with my PHP configuration, I googled for the necessary commands and typed:<\/p>\n<p><code>\/user\/local\/mysql\/bin\/mysql -u root -p<br \/>\ndrop database <em>wordpressdatabasename<\/em>;<br \/>\nsource .\/Downloads\/<em>wordpressdatabasename<\/em>.sql<br \/>\nquit<\/code><\/p>\n<p>At this point, the local copy of WordPress was running on the live database, but the links were all to the live site, so I used phpMyAdmin to edit the site URL in the wp_options table, changing it from <code>https:\/\/www.markwilson.co.uk\/blog<\/code> to <code>http:\/\/localhost\/~<em>username<\/em>\/blog<\/code>.<\/p>\n<p>Because the live copy of the site is on an old version of WordPress, browsing to <code>http:\/\/localhost\/~<em>username<\/em>\/blog\/wp-admin<\/code> prompted me to upgrade the database, after which I could log in and edit the site settings (e.g. the blog address).<\/p>\n<p><img data-recalc-dims=\"1\" decoding=\"async\" class=\"inline\" alt=\"WordPress database upgrade\" src=\"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/wordpress-database-upgrade.png?w=700&#038;ssl=1\" \/><\/p>\n<p><img data-recalc-dims=\"1\" decoding=\"async\" class=\"inline\" alt=\"WordPress 2.7 Dashboard\" src=\"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/wordpress-dashboard.png?w=700&#038;ssl=1\" \/><\/p>\n<h3>Restoring the theme and plugins<\/h3>\n<p>At this point, although WordPress was running on a local copy of my live database, the normal theme was missing and the plugins were disabled (as they were not present).  I copied them from the live server and, after selecting the theme and enabling the plugins saw something approaching normality, although there were a few plugins that required updating and I still couldn&#8217;t get rid of a particularly annoying database error:<\/p>\n<p><em>WordPress database error: [Table &#8216;<\/em>wordpressdatabasename<em>.wp_categories&#8217; doesn&#8217;t exist]<br \/>\nSELECT cat_name FROM wp_categories ORDER BY cat_name ASC<\/em><\/p>\n<p>By disabling plugins one by one (<a href=\"http:\/\/techie-buzz.com\/wordpress\/getting-rid-of-errors-after-upgrading-to-wordpress-23.html\">I could also have <code>grep<\/code>ped \/~Sites\/blog\/wp-admin\/wp-content\/plugins for <code>wp_categories<\/code><\/a>), I found that the issue was in the <a href=\"http:\/\/www.bad-behavior.ioerror.us\/\">Bad Behavior<\/a> plugin that I use to ban IP addresses known to send spam.<\/p>\n<h3>Moving from categories to tags<\/h3>\n<p><a href=\"https:\/\/www.markwilson.co.uk\/blog\/2007\/08\/marks-weblog-20.htm\">When I first moved this site to WordPress<\/a>, I used Dean Robinson&#8217;s <a href=\"http:\/\/www.deanjrobinson.com\/wordpress\/plugins\">Ultimate Category Cloud<\/a> plugin to provide a tag cloud (at that time WordPress did not support tags).  Over time, that because unmanageable and, although I still need to define a decent taxonomy for the site, the categories still have some value if they are converted to tags.<\/p>\n<p>Over some tapas and drinks in the pub, my friend <a href=\"http:\/\/www.alexcoles.com\/\">Alex Coles<\/a> at <a href=\"http:\/\/www.ascomi.net\/\">ascomi<\/a> and I had a look at the database structure and Alex came up with a quick SQL query to run against my WordPress database:<\/p>\n<p><code>UPDATE wp_term_taxonomy SET taxonomy='post_tag' WHERE taxonomy='category'<\/code><\/p>\n<p>That converted all of my categories to tags, but there were some I manually edited to return to categories (General &#8211; which was once called Uncategorised &#8211; and Site Notices) but for some reason, all the posts were recorded in a category of Uncatagorized.  Some late night PHP coding (reminiscent of many nights at Uni&#8217; &#8211; <a href=\"http:\/\/www.hackinghat.com\/\">as Steve will no doubt remember<\/a> &#8211; although in those days it was Modula-2, C, C++ and COBOL) resulted in a script to run through the database, identify all posts with a category of 17 (which in my database is the default category of &#8220;General&#8221;), put the post numbers into an array and then explicitly set the category as required, taking a note of the ones which have been changed so that they can be ignored from that point on:<\/p>\n<p><code>&lt;html&gt;<br \/>\n&lt;head&gt;<br \/>\n&lt;\/head&gt;<\/p>\n<p>&lt;body&gt;<br \/>\n&lt;?php<\/p>\n<p>\/\/ Connect to the WordPress database<br \/>\n$db_hostname = \"localhost:\/tmp\/mysql.sock\";<br \/>\n$db_username = \"<em>wordpressuser<\/em>\";<br \/>\n$db_password = \"<em>wordpresspassword<\/em>\";<br \/>\n$db_connect = mysql_connect($db_hostname, $db_username, $db_password) or die(\"Unable to connect to server.\");<br \/>\n$db = mysql_select_db(\"<em>wordpressdatabasename<\/em>\",$db_connect);<\/p>\n<p>\/\/ Retrieve all objects including a category with the value of 17 (my default category)<br \/>\n$hascat = mysql_query(\"SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id = '17' ORDER BY object_id\");<br \/>\necho '&lt;p&gt;'.mysql_num_rows($hascat).' rows found with category&lt;\/p&gt;';<\/p>\n<p>$correct_ids = array();<\/p>\n<p>\/\/ Build a PHP array (not a MySQL array) containing the relevant object IDs for later comparison<br \/>\nwhile ($row = mysql_fetch_array($hascat))<br \/>\n{<br \/>\n$correct_ids[] = $row[0];<br \/>\n}<br \/>\necho '&lt;p&gt;Array built. Length is '.count($correct_ids).'. First ID is '.$correct_ids[0].'.&lt;\/p&gt;';<\/p>\n<p>\/\/ Retrieve every object<br \/>\n$result = mysql_query(\"SELECT * FROM wp_term_relationships ORDER BY object_id\");<br \/>\necho '&lt;p&gt;'.mysql_num_rows($result).' rows found total&lt;\/p&gt;';<\/p>\n<p>\/\/ The magic bit!<br \/>\n\/\/ If the object is not in our previous array (i.e. the category is not 17)<br \/>\n\/\/ then add it to category 17 and put it in the array so it won't get added repeatedly<br \/>\nwhile ($row = mysql_fetch_array($result))<br \/>\n{<br \/>\nif (!in_array($row['object_id'],$correct_ids))<br \/>\n{<br \/>\n\/\/ Add to category 17<br \/>\nmysql_query(\"INSERT INTO wp_term_relationships (object_id,term_taxonomy_id,term_order) VALUES ('\".$row['object_id'].\"','17','0')\");<br \/>\necho '&lt;p&gt;Alter database entry for object '.$row['object_id'].'.&lt;\/p&gt;';<br \/>\n\/\/ Add to the array so it is not flagged again<br \/>\n$correct_ids[]=$row['object_id'];<br \/>\n}<br \/>\nelse echo '&lt;p style=\"color:white; background-color:black\"&gt;'.$row['object_id'].' ignored.&lt;\/p&gt;';<br \/>\n}<\/p>\n<p>?&gt;<br \/>\n&lt;\/body&gt;<br \/>\n&lt;\/html&gt;<\/code><\/p>\n<h3>Remaining issues<\/h3>\n<p>Permalinks don&#8217;t seem to work &#8211; <a href=\"http:\/\/warker.com\/2006\/09\/16\/wordpress-os-x-install-tips\/\">it seems that Mac OS X does not support using .htaccess files by default and, whilst it&#8217;s possible to modify for the root folder it doesn&#8217;t seem to work for individual user sites<\/a>.  I&#8217;ll do some more digging and see if I can find a fix for that one.<\/p>\n<p>WordPress also features the ability to automatically update plugins (and itself), but my installation is falling back to FTP access when I try to update it and <a href=\"http:\/\/clifgriffin.com\/2008\/12\/09\/how-to-fix-wordpress-automatic-upgrades-plugins-and-wordpress\/\">making it work appears to be non-trivial<\/a>.  Again, I&#8217;ll take another look when I have more time.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last week I wrote about installing WordPress on a Mac but I wanted to follow that up with a post on what happened next. Installing phpMyAdmin Installing WordPress is all very well, but it&#8217;s good to be able to manipulate the database. The command line mysql tools would have worked but a graphical interface (even &hellip; <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags)<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[],"tags":[35,185,165,82,15],"class_list":["post-1380","post","type-post","status-publish","format-standard","hentry","tag-mac-os-x","tag-mysql","tag-php","tag-scripting","tag-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags) - markwilson.it<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags) - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"Last week I wrote about installing WordPress on a Mac but I wanted to follow that up with a post on what happened next. Installing phpMyAdmin Installing WordPress is all very well, but it&#8217;s good to be able to manipulate the database. The command line mysql tools would have worked but a graphical interface (even &hellip; Continue reading Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2009-03-03T23:28:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2009-03-05T22:07:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.markwilson.co.uk\/blog\/images\/wordpress-database-upgrade.png\" \/>\n<meta name=\"author\" content=\"Mark Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:site\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mark Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags)\",\"datePublished\":\"2009-03-03T23:28:38+00:00\",\"dateModified\":\"2009-03-05T22:07:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm\"},\"wordCount\":911,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/wordpress-database-upgrade.png\",\"keywords\":[\"Apple Mac OS X\",\"MySQL\",\"PHP\",\"Scripting\",\"WordPress\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm\",\"name\":\"Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags) - markwilson.it\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/wordpress-database-upgrade.png\",\"datePublished\":\"2009-03-03T23:28:38+00:00\",\"dateModified\":\"2009-03-05T22:07:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#primaryimage\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/wordpress-database-upgrade.png\",\"contentUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/wordpress-database-upgrade.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2009\\\/03\\\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/\",\"name\":\"markwilson.it\",\"description\":\"get-info -class technology | write-output &gt; \\\/dev\\\/web\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\",\"name\":\"Mark Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"width\":800,\"height\":800,\"caption\":\"Mark Wilson\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\"},\"description\":\"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.\",\"sameAs\":[\"http:\\\/\\\/www.markwilson.co.uk\\\/\",\"https:\\\/\\\/www.instagram.com\\\/markwilsonuk\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/markawilson\\\/\",\"https:\\\/\\\/x.com\\\/markwilsonit\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCWHlZCoHRTocdvtrOJ2IL4A\"],\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/author\\\/mark-wilson\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags) - markwilson.it","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm","og_locale":"en_GB","og_type":"article","og_title":"Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags) - markwilson.it","og_description":"Last week I wrote about installing WordPress on a Mac but I wanted to follow that up with a post on what happened next. Installing phpMyAdmin Installing WordPress is all very well, but it&#8217;s good to be able to manipulate the database. The command line mysql tools would have worked but a graphical interface (even &hellip; Continue reading Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags)","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm","og_site_name":"markwilson.it","article_published_time":"2009-03-03T23:28:38+00:00","article_modified_time":"2009-03-05T22:07:20+00:00","og_image":[{"url":"https:\/\/www.markwilson.co.uk\/blog\/images\/wordpress-database-upgrade.png","type":"","width":"","height":""}],"author":"Mark Wilson","twitter_card":"summary_large_image","twitter_creator":"@markwilsonit","twitter_site":"@markwilsonit","twitter_misc":{"Written by":"Mark Wilson","Estimated reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags)","datePublished":"2009-03-03T23:28:38+00:00","dateModified":"2009-03-05T22:07:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm"},"wordCount":911,"commentCount":0,"publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/wordpress-database-upgrade.png","keywords":["Apple Mac OS X","MySQL","PHP","Scripting","WordPress"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm","name":"Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags) - markwilson.it","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#primaryimage"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/wordpress-database-upgrade.png","datePublished":"2009-03-03T23:28:38+00:00","dateModified":"2009-03-05T22:07:20+00:00","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#primaryimage","url":"https:\/\/www.markwilson.co.uk\/blog\/images\/wordpress-database-upgrade.png","contentUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/wordpress-database-upgrade.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2009\/03\/installing-wordpress-on-a-mac-the-aftermath-phpmyadmin-databases-themes-plugins-and-fixing-the-tags.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.markwilson.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"Installing WordPress on a Mac: the aftermath (phpMyAdmin, databases, themes, plugins and fixing the tags)"}]},{"@type":"WebSite","@id":"https:\/\/www.markwilson.co.uk\/blog\/#website","url":"https:\/\/www.markwilson.co.uk\/blog\/","name":"markwilson.it","description":"get-info -class technology | write-output &gt; \/dev\/web","publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.markwilson.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468","name":"Mark Wilson","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","url":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","width":800,"height":800,"caption":"Mark Wilson"},"logo":{"@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1"},"description":"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.","sameAs":["http:\/\/www.markwilson.co.uk\/","https:\/\/www.instagram.com\/markwilsonuk\/","https:\/\/www.linkedin.com\/in\/markawilson\/","https:\/\/x.com\/markwilsonit","https:\/\/www.youtube.com\/channel\/UCWHlZCoHRTocdvtrOJ2IL4A"],"url":"https:\/\/www.markwilson.co.uk\/blog\/author\/mark-wilson"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":921,"url":"https:\/\/www.markwilson.co.uk\/blog\/2007\/10\/backing-up-and-restoring-a-wordpress-database.htm","url_meta":{"origin":1380,"position":0},"title":"Backing up and restoring a WordPress database","author":"Mark Wilson","date":"Thursday 18 October 2007","format":false,"excerpt":"Last year, Alex and I redeveloped the website for a campaign group close to the town where I live. Even though the design was pretty plain (neither of us are designers), from a web development standpoint the site was pretty good - written in semantically correct XHTML and CSS, using\u2026","rel":"","context":"In \"Website Development\"","block_context":{"text":"Website Development","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/website-development"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1371,"url":"https:\/\/www.markwilson.co.uk\/blog\/2009\/02\/installing-wordpress-on-a-mac.htm","url_meta":{"origin":1380,"position":1},"title":"Installing WordPress on a Mac","author":"Mark Wilson","date":"Monday 23 February 2009","format":false,"excerpt":"The software platform which markwilson.it runs on is in desperate need of an updated but there is only me to make it happen (supported by ascomi) and if I make a mistake then it may take some time for me to get the site back online (time which I don't\u2026","rel":"","context":"In \"Apache\"","block_context":{"text":"Apache","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/apache"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4377,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/09\/reducing-website-errors-http-301-redirects.htm","url_meta":{"origin":1380,"position":2},"title":"Reducing website errors with HTTP 301 redirects","author":"Mark Wilson","date":"Wednesday 19 September 2012","format":false,"excerpt":"A couple of weeks ago, I wrote about a WordPress plugin called Redirection. I mentioned that I've been using this to highlight HTTP 404 errors on my site but I've also been using the crawl errors logged by Google's Webmaster Tools to track down a number of issues resulting from\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":738,"url":"https:\/\/www.markwilson.co.uk\/blog\/2007\/08\/marks-weblog-20.htm","url_meta":{"origin":1380,"position":3},"title":"Mark&#8217;s (we)Blog 2.0","author":"Mark Wilson","date":"Wednesday 29 August 2007","format":false,"excerpt":"Just under six months ago, I changed hosting providers and moved this blog from Blogger to WordPress. Ever since then it's been tagged as Mark's (we)Blog [v2.0\u00ce\u00b2] but the time has come to remove the beta tag... after all I'm just one bloke doing this in his (limited) spare time\u2026","rel":"","context":"In &quot;Site notices&quot;","block_context":{"text":"Site notices","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/site-notices"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":59,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/02\/10000-feet-view-of-microsoft-systems.htm","url_meta":{"origin":1380,"position":4},"title":"10,000 feet view of Microsoft Systems Management Server 2003","author":"Mark Wilson","date":"Thursday 10 February 2005","format":false,"excerpt":"Until I started to look at the Microsoft Solution Accelerator for Business Desktop Deployment (Enterprise Edition), which makes use of the Microsoft Systems Management Server (SMS) 2003 Operating System Deployment Feature Pack, I had no experience of using SMS. At my BDD training, Thomas Lee gave a brief overview of\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":379,"url":"https:\/\/www.markwilson.co.uk\/blog\/2006\/07\/installing-windows-on-my-mac.htm","url_meta":{"origin":1380,"position":5},"title":"Installing Windows on my Mac","author":"Mark Wilson","date":"Monday 31 July 2006","format":false,"excerpt":"Tonight, I committed heresy - I installed Windows on my Mac. Ironically (and this is where I need to eat a small amount of humble pie, having previously criticised the OS X interface - although I did also say that I don't like the new Windows Vista Aero interface or\u2026","rel":"","context":"In \"Apple Macintosh\"","block_context":{"text":"Apple Macintosh","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/macintosh"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/1380","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=1380"}],"version-history":[{"count":0,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/1380\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=1380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=1380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=1380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}