{"id":36815,"date":"2015-07-26T07:38:24","date_gmt":"2015-07-26T07:38:24","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/pitta-migration\/"},"modified":"2015-08-24T21:27:04","modified_gmt":"2015-08-24T21:27:04","slug":"pitta-migration","status":"publish","type":"plugin","link":"https:\/\/ca-valencia.wordpress.org\/plugins\/pitta-migration\/","author":419671,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"0.4.2","stable_tag":"0.4.2","tested":"4.3.34","requires":"2.2","requires_php":"","requires_plugins":"","header_name":"Pitta Migration","header_author":"Ian Channing @ VSN International","header_description":"","assets_banners_color":"7d7d7d","last_updated":"2015-08-24 21:27:04","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/www.vsni.co.uk","header_author_uri":"https:\/\/www.vsni.co.uk","rating":5,"author_block_rating":0,"active_installs":10,"downloads":1767,"num_ratings":1,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":[],"ratings":{"1":0,"2":0,"3":0,"4":0,"5":"1"},"assets_icons":[],"assets_banners":{"banner-1554x500.png":{"filename":"banner-1554x500.png","revision":"1207265","resolution":"1554x500","location":"assets"},"banner-772x250.png":{"filename":"banner-772x250.png","revision":"1207265","resolution":"772x250","location":"assets"}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["0.4.2"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1573839","resolution":"1","location":"plugin"}},"screenshots":{"1":"A successful migration message"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[151,153,2275,4151,1627],"plugin_category":[59],"plugin_contributors":[97491,97492],"plugin_business_model":[],"class_list":["post-36815","plugin","type-plugin","status-publish","hentry","plugin_tags-backup","plugin_tags-database","plugin_tags-developer","plugin_tags-migrate","plugin_tags-mysql","plugin_category-utilities-and-tools","plugin_contributors-icc97","plugin_contributors-theantichris","plugin_committers-icc97"],"banners":{"banner":"https:\/\/ps.w.org\/pitta-migration\/assets\/banner-772x250.png?rev=1207265","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/pitta-migration_7d7d7d.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/pitta-migration\/trunk\/screenshot-1.png?rev=1573839","caption":"A successful migration message"}],"raw_content":"\n

This plugin is aimed at developers that need to migrate their databases from\nproduction to test or local domains.<\/p>\n\n

This is the simplest way I've found to migrate databases quickly.<\/p>\n\n

You only have to set the WP_HOME<\/code>\n(WordPress address URL<\/a>)\nand WP_SITEURL<\/code>\n(Blog address URL<\/a>)\nconstants once for each environment and then the database is automatically\nupgraded when you import a database and login to the admin area.<\/p>\n\n

This stands on the shoulders of the constants and fills the hole for when\nplugins don't follow the rules and use the database directly.<\/p>\n\n

This plugin is designed to be the most lightweight way to migrate your database\nand stay out the way of your own processes.<\/p>\n\n

It works with WordPress to use WordPress' own constants to update the database\nusing the\nWordPress Database Object<\/a>.\nIt avoids search and replaces in text files. It uses database queries to update\nthe database as should be done.<\/p>\n\n

Most developers have their own methods for exporting\/importing the database -\nif you can use mysqldump<\/code> then you probably don't want a WordPress plugin to\ndo it for you.<\/p>\n\n

It makes no assumptions about your database and it's cross platform.<\/p>\n\n

P.S. Pitta is taken from the start of an answer from WordPress SE<\/a>:<\/p>\n\n

\n

Deployment of a WordPress site from one box to another has been a PITA since\n day one I started working with WordPress. (Truth-be-told it was a PITA with\n Drupal for 2 years before I started with WordPress so the problem is\n certainly not exclusively with WordPress.)<\/p>\n<\/blockquote>\n\n

So this plugin aims to make things less PITA and more yummy Pitta (pedants will\nmention that Pitta can also be spelled pita).<\/p>\n\n

Its inspiration actually comes from the second answer<\/a>\nfrom the same WordPress SE question<\/a>.<\/p>\n\n

Coincidentally there is a migratory bird called a Pitta<\/a>:<\/p>\n\n

\n

The fairy pitta migrates from Korea, Japan, Taiwan and coastal China to Borneo.<\/p>\n<\/blockquote>\n\n

P.P.S. This plugin is based off the excellent WordPress Plugin Boilerplate<\/a> from antichris on Github<\/p>\n\n\n

    \n
  1. Upload pitta-migration<\/code> directory to the \/wp-content\/plugins\/<\/code> directory<\/li>\n
  2. Insert the WP_HOME<\/code> and WP_SITEURL<\/code> constants into your wp-config.php<\/code> file<\/li>\n
  3. Activate the plugin through the 'Plugins' menu in WordPress<\/li>\n
  4. As soon as you activate the plugin it will try to migrate the database to match the constants<\/li>\n<\/ol>\n\n\n
    \n
    I've imported my database to migrate and set WP_HOME and WP_SITEURL but nothing happens<\/dt>\n

    Check the the plugin is active. If you're just restored a production database the plugin might have been deactivated there.<\/p>\n\n

    As soon as you activate the plugin it will try to do the migration.<\/p><\/dd>\n

    It's active too...<\/dt>\n

    Check if it has run, by looking in the wp_options<\/code> table for home and siteurl, as the session might have had problems and not displayed the message.<\/p><\/dd>\n\n<\/dl>\n\n\n

    0.4.2<\/h4>\n\n