• First and foremost, you need to fully permission to access Network Admin by using WP Engine account. After that, navigate to Plugins » Add New.
• Carry out of activating All-in-One WP Migration plugin and move to subsite to observe.
In reality, that plugin doesn't share from Network Admin to multiple sites. Let try with All in One SEO plugin then the result as below:
Hence, we will back normally WordPress Import/Export content to migrate between website.
• Before moving forward, we will need to look at structure in phpmyadmin where WP Engine arrange content between major domain and subdomains.
As you can see here, we have two table. One for wp_posts and another for wp_2_posts. That point out we must be carefully overriding content to subdomain to avoid effectiveness to major domain.
(*) wp_2_posts (Got 6 records)
SELECT COUNT(*) FROM `wp_2_posts` WHERE 1
(*) wp_2_posts (After using WordPress importer)
SELECT COUNT(*) FROM `wp_2_posts` WHERE 1
We have totally 15 records. Hence, you have changes after using WordPress Run Importer. Now, let try all contents.
• Manually override advanced custom via tables in phpmyadmin to ensure WordPress website work well.
(*) wp_options - You need to export and change database name and table name to fit with https://phpmyadmin.wpengine.com site.
(*) Version
{
"type": "header",
"version": "5.2.0",
"comment": "Export to JSON plugin for PHPMyAdmin"
},
(*) Database name
{
"type": "database",
"name": "sample_db"
},
{
"type": "table",
"name": "wp_options",
"database": "sample_db",
"data": [
// TODO
]
}
// TODO
}
(*) Website URL, Website Name and Website Blog Name
{
"option_id": "1",
"option_name": "siteurl",
"option_value": "http://flagtick.com/fkagtickblog",
"autoload": "yes"
},
{
"option_id": "2",
"option_name": "home",
"option_value": "http://flagtick.com/fkagtickblog",
"autoload": "yes"
},
{
"option_id": "3",
"option_name": "blogname",
"option_value": "Flagtick Blog",
"autoload": "yes"
},
// TODO
}
(*) Administrator Email (ignore and no need override)
{
"option_id": "6",
"option_name": "admin_email",
"option_value": "[email protected]",
"autoload": "yes"
},
(*) Activated Plugins
/** Detech from JSON format */
akismet/akismet.php
easy-wp-smtp/easy-wp-smtp.php
Note: Do a quick search with keyword = '.php' and get 16 installed plugin.
(*) Widget Categories (ignore and no need override)
How can we migrate all wp_options to WP Engine step by step across multiple sites? Let's discuss it here:
» Install theme WordPress and setup theme WordPress for sub site here.
» The next step is to move to Plugins and install all the necessary plugins for the multiple sites. Once you have successfully completed this step, you can activate the plugins from the sub-website.
For example, you can install the Elementor Page Builder and Elementor Pro package in the Network Admin. To activate them, go to the sub-website and enable them.
» After that, take advantage of using Tools » Import/Export to synch all contents from custom domain to subdomain in WPEngine.
» To ensure that you can access the database from phpMyAdmin on WP Engine, follow these steps if you have multiple sites that use the same database:
For the main domain (http://flagtick.com), use the wp_options table.
For a subdomain (http://blog.flagtick.com), use the wp_2_options table.
The number '2' indicates the index of the sub site, which in this case is named blog.flagtick.com.
Note: Sometimes, you may encounter errors, such as the duplicated error shown above. If this occurs, you can skip it and continue with the INSERT INTO statement. To monitor whether the query is successful or not, you can separate the query into smaller parts and paste them into the SQL Editor in phpMyAdmin to run.