Joe_Fitz

This plugins was designed to speed up and manage the process of creating a running migrations scripts. Migrations scripts are used to edit content on a blog to blog basis by running php files which manipulate your WordPress database. This could be adding or removing a page or post to certain blogs. Strategery Migrations also provides an interface to manage your migrations scripts. You can view a list of all migrations files and see a timestamp indicating when a migration file was created. You can see individual blogs’ migration state so that you can tell what files have been run or if a certain blog has been migrated. You can look at a list of all your blogs and see what their migration states are compared to each other.
This plugin was made for WordPress implementations using a multisite network with sub-directories.
<h3>Usage Instructions</h3>
<h4>Creating a Migration Script</h4>
<ol>
<li>Click on the Add New link in the Migrations admin options tab</li>
<li>Enter a the script’s filename using underscores instead of spaces (file_name)</li>
<li>Click Create File</li>
</ol>
You are then redirected to the list or migration files.
At this point the file has been generated and exists in the ‘/strategery-migrations/migrations/’ folder in your ‘plugins’ directory.
The filename is broken up into 2 parts. The first part before the dash(-) is the timestamp in YYYYMMDDHHMMSS format. This number is used to compare the sate of a blog compared to when this file was created. When a migration is run and completed, it will update the blog that ran the migration to reflect its new state. The sate for a blog is the same timestamp of the most recent migrations run on it. Only migrations with a later timestamp than the blog’s state timestamp will be run. The second part of the filename is the actual name of the migration script file. The format uses underscores as spaces and will be read by the plugin to create the classname in the file using camel case. 
Open the file that was created and start coding the migration script. You will notice that the file contains a class that extends the main migration class. Each migration script defines a new class with two methods. The up method is used for creating pages or posts. It is the creation method. The down method is used for undoing the up method. It Is a way to revert the migration. This method is optional. 
The methods are run on a blog to blog basis and work within the context of each blog. To get the ID of the current blog, for example, you can use the get_current_blog_id() function.
<h4>Models</h4>
Models are abstracts that are used to query your database. Models are used to save or delete that model type into your database. A model could be a post or a page, etc. To use models you need to make use of the getModel function.
$this->getModel( $type , $data );
$type – A string that picks wether the model is a page or a post, etc.
$data – An array that contains information related to the model type.
Example
$data = array(‘post_type’ => ‘page’ , ‘post_name’ => ‘menu-add’ , ‘post_title’ => ‘Add Menu Item’ );
$post = $this->getModel(‘Post’, $data );
You can also use the shortcut getPost($data).
The commands above query your database for existing posts that match the given data in the current blog and return an object of the post. You can then access that post’s information using the object. For example $post->ID will return the id of the post.
To create a page you use the same function call and add ->save() to the end.
$post = $this->getModel(‘Post’, array(‘post_type’ => ‘page’ , ‘post_name’ => ‘menu-add’ , ‘post_title’ => ‘Add Menu Item’ ))->save();
The command above queries your database for existing posts that match the given data in the current blog. If there is no match in the database it will create that post in the database and return an object of it. The save() command will not create duplicates.
If you want to delete a given post you simply need to replace save() with delete().
<h4>Your Database</h4>
To run queries on your database without using models you have to use $this->db(). It will return the WordPress database. To run an insert for example you would use the following code.
Example
$this->db()->insert($table, $data);
If you want to insert into each blog’s post table you would set the $table as $this->db()->posts
The command would then look like this
$this->db()->insert( $this->db()->posts , $data );
<h4>Excluding Pages</h4>
This migration plugin comes with a helper class that allows you to remove a page from the navigation menu. Pages that should not appear in your navigation menu can easily be excluded with one line of code. These pages are still reachable and still exist but they will not be seen by users with all your other navigation links.
This exclude functionality requires having another <a href="https://wordpress.org/extend/plugins/exclude-pages/" rel="ugc">plugin</a> active.
To use the helper function you need to pass it a path to helper class you are looking for.
$this->getHelper($path);
The getHelper function takes a string that contains the path to the specific helper class you are looking for.
$this->getHelper($path)->method($args);
This is the full call to a helper class method which has the helper function that takes the path to the class you are hooking into. getHelper returns an instance of that class and can be used to execute methods. All helper classes are contained in the ‘/lib/Helpers/Plugins/’ directory. It contains .php files with names in camel case. The class that is defined in each file is named the same as the file name except with underscores separating each word. For the exclude from navigation class, it is contained in the ExcludeFromNav.php file, but the class name is exclude_from_nav. This name is the one you need for the helper function.
Below is an example of how to call the exclude from navigation helper class.
Example
$this->getHelper(‘plugins/exclude_from_nav’)->exclude($post->ID);
exclude() takes the id of the page being excluded as an argument.
<h4>Logging</h4>
While the migration is running, there will be output in the migrations report showing you the progress of your migration. It will let you know if there was an error finding a specific post or if the migration was already done and it is already up to date.
You can add your own logging information inside your up and down methods for each migration script. This could be a simple message saying you did whatever you were trying to do. You do this by using the log() function. It simply echos the string passed to it.
$this->log($message , $nl);
Above is how it is called. It doesn’t format the string, so newlines and tabs must be added in as usual. $nl is an optional parameter that is of type bool which indicates whether to add a newline to the end of the $message string.
<h4>Running Migrations Scripts</h4>
There are several ways to run migrations scripts depending on how you want the migrations to be done.
The options are:
<ul>
<li>Run a single migration file a certain blog</li>
<li>Run all migration files for a single blog</li>
<li>Run all migration files for all blogs</li>
</ul>
To run a single migration file for a certain blog you can go to that blog in the WordPress backend and click on the Migrations link in the Migrations admin menu tab. Once you are at the migrations list there is a run button with to each list item on the right. Clicking this will run that script for the current blog.
To run all migration files for a certain blog you can either click the run all button at the top of that blog’s migrations list or click the migrate button that is in the blog list page. To get to this page you must be in the network administration panel and click on the Blog List link in the
Migrations admin menu tab. There is a migrate button for each blog in the list on the right side or the table.
To run all migrations for all blogs click the Migrate All button at the top of the Blog List page.

Strategery Migrations

Easily run and manage migration scripts to assist in updating blogs on your site.

Amrit Anandh

WPTimeCapsule

<a href="https://wptimecapsule.com/" title="Incremental Backup for WordPress" rel="nofollow ugc">WP Time Capsule</a> was created to ensure peace of mind with WP updates and put the fun back into WordPress. It uses the cloud apps’ native file versioning system to detect changes and backs up just the changed files and db entries to your account.
You need to sign up for an account on our website https://service.wptimecapsule.com to get a 30 days full featured trial.
 
With WP Time Capsule you can
Backup in real-time 
You can backup your site in real-time which means you will now be able to revert your site to how it was just an hour ago. Also, you can change the backup interval to every 6 hours or 12 hours or daily. 
Staging 
With a single click staging it’s a breeze to test any change you are planning to do on your site. Test your updates on staging with a single click
Auto backup and update 
We automatically backup before each update, if an update causes any undesired change. You are a click away from restoring.
Encrypted DB backups & GDPR Compatible 
You can encrypt your DB backups to add an extra layer of security and makes your backup GDPR compatible. 
Clone/Migrate 
You can now use the WPTC backup to clone or migrate your site to a new location at ease.
How is WP Time Capsule different than other backup plugins? 
 
WPTC is unique in 4 ways – 
1. It backs up and restores only the changed files & DB and not the entire site every time. 
2. The files & DB are stored in your cloud storage app – Amazon S3, Wasabi, Backblaze, Dropbox or Google Drive. 
3. We have used the cloud apps’ native file versioning system to detect changes and maintain file versions. So backups and restores are as reliable as they get. 
4. Most importantly, you can backup your site in real-time which means you will now be able to revert your site to how it was just an hour ago. Also, you can change the backup interval to every 6 hours or 12 hours or daily. 
How does it work? 
 
1. Sign up an account on our website https://wptimecapsule.com and you will get a 30 days full featured trial. 
2. Install the plugin and login with your wptimecapsule.com account. 
3. Next, connect the cloud app where you want to store the backup files. You can use Amazon S3, Wasabi, Dropbox or Google Drive. 
4. Once you connect the cloud app, we will automatically begin backing up your complete website to your cloud app account.
After the first full backup is taken, you can schedule a time for WPTC to backup your websites. We will take care of your backups from here on. 
This being done you will officially be disaster-ready. 🙂
Backup: Looks for files & DB changes since the last backup and uploads only the changes. The data is then stored securely in your cloud app account. 
 
Restore: Checks revision history and displays the same. You can restore the site to any point in time or restore specific files & DB.
How is it better? 
BACKUP METHOD 
Traditionally – Backups are compressed and zipped. The Bad: Heavy server resource consumption. 
WPTC – No zipping. Changed files are directly dropped into your cloud account. The Good: Uses considerably less server resources
BACKUP FILE 
Traditionally – Multiple zip files are created every time you backup. The Bad: Precious storage space is wasted. 
WPTC – Backs up incrementally. No multiple copies of files. The Good: Uses far less disk space
RESTORE 
Traditionally – Unzip backup and restore the whole site. The Bad: Consumes time and server resource. 
WPTC – Restores only selected files. The Good: Faster restore and you can restore even if you don’t have access to your site or plugin.
Check out our <a href="https://docs.wptimecapsule.com/" rel="nofollow ugc">Knowledge Base</a> 
Visit us at <a href="https://wptimecapsule.com/" title="Incremental Backup for WordPress" rel="nofollow ugc">wptimecapsule.com</a>
Credits: Michael De Wildt for his WordPress Backup to Dropbox plugin based on which this plugin is being developed.

Backup and Staging by WP Time Capsule

Backup and Staging by WP Time Capsule is an automated incremental backup plugin that backs up your website changes as per your schedule to Dropbox, Go …

Strategery Migrations vs Backup and Staging by WP Time Capsule