jamiechong

Export 2 Multisite exports your standalone database SQL for import into a WP multisite installation. It handles duplicate users (based on email) and will copy over all site settings including Widgets and Menus. You still need to copy the files for your themes, plugins and uploads.
<ul>
<li>This plugin has been minimally tested, but has been used to successfully migrate a handful of standalone sites to a multisite installation.</li>
<li>There is a good possibility it won’t work for sites that make use of a multitude of plugins – especially plugins that have their own database tables.</li>
</ul>
Installation
<ol>
<li>Create a new site on the Multisite.</li>
<li>Copy the plugins and themes from this standalone site to the Multisite.</li>
<li>Copy the files from wp-content/uploads/ on this site to wp-content/uploads/sites// on the multisite.</li>
<li>Backup the database on the Multisite.</li>
<li>Provide the Site ID of the Multisite. This can be found by hovering the mouse over the new site on Network Admin->Sites.</li>
<li>Provide the New URL. Example: //mysite.my-wp-multisite.com</li>
<li>Provide the New file path (The file path of the Multisite installation).</li>
<li>Export the database dump.</li>
<li>Import the SQL into your Multisite installation.</li>
</ol>
<ul>
<li>Important: The exported SQL will DROP the tables that were created for the Site ID you provided. So only perform this migration on new empty Sites.</li>
<li>Note that the you may need to review the exported SQL to ensure that plugin database tables have been exported correctly.</li>
<li>The site admin (username and password) is the user you created while creating the new Site, NOT the site admin of this standalone site.</li>
<li>The guts of this export plugin were inspired by <a href="https://iandunn.name/comprehensive-wordpress-multisite-migrations/" rel="nofollow ugc">this blog post</a></li>
<li>The code for this plugin has been modified from the <a href="https://wordpress.org/plugins/wp-migrate-db" rel="ugc">WP Migrate DB</a> plugin, but should not conflict with it in any way.</li>
</ul>

Export 2 Multisite

Exports your standalone database SQL for import into a WP Multisite installation.

Peter Lawrenson

ryo0inoue

Simple Table Manager enables editing table records and exporting them to CSV files through a minimal database interface from your dashboard.
<ul>
<li>Simply CRUD table contents on your wp-admin screen</li>
<li>Search and sort table records</li>
<li>No knowledge of MySQL or PHP required</li>
<li>Export table records to a CSV file</li>
<li>Does not allow users to create tables or change the structure of the table</li>
</ul>
Simple Table Manager is a tool suited for the initial development phase of a website. It is ideal when you want to ask someone else with no database expertise to keep track of table records on your website. This was the motivation for developing this plugin.
Note that to comply with wordpress.org plugin security guidelines, edited and added record fields are filtered through wp_kses_post() to prevent sql injection attacks. In some cases, wanted tags may be filtered out leading to field corruption.

Simple Table Manager

As advertised, this plugin is great for a non-techy admin to create and edit data, and I recommended the plugin for this purpose.
I used phpMyAdmin to setup the table and then used the plugin to create the initial set of records. There are no display facilities with the plugin so I a used a bit of custom code. Only 2 lines are needed to fetch the data into a php function:
global $wpdb;
$results = $wpdb->get_results( 'SELECT * FROM wp_mytable', ARRAY_N );
The plugin will allow access to only one table at a time, but its easy to switch between tables.
Thanks for sharing.



Great for non-techy admin to maintain data.

Enables viewing and editing table records and exporting them to CSV files through a minimal database interface from your dashboard.

Export 2 Multisite vs Simple Table Manager