Codexonics

Hello Dave, thank you for using the Prime Mover plugin! I’m sorry to hear you have errors on import. We’ve checked that line in the code, and it pertains to querying the database to retrieve the rows for the search-and-replace process. By default, it retrieves 25,000 rows, which would work in most hosting situations.

In your case – you have a huge amount of data in these rows, so it can hit the memory limit. To resolve this – you need to lower the query result in rows as much as possible. Prime Mover has a setting for this. For details – please refer to the detailed solution:

• Reset your target to a fresh WordPress install.
• Install and activate the latest Prime Mover plugin (currently version 2.0.4).
• Once fully activated – go to Prime Mover -> Runtime settings -> Search-replace batch size.
• Currently, this is set to 25,000. Change it to something very low that would fit your server memory. For example, change it from 25000 to 1000 or even 500. This allows Prime Mover to fetch 1000 or 500 rows at a time. Hopefully, this should fit your server memory requirements.
• Save the setting.
• Try restoring the package the way you used to restore it. You should not hit the memory limit settings since you are now fetching a very small number of rows from the database at a time.

This should work – otherwise if you still have the same issue. Please send us a copy of your WPRIME package by uploading it to Google Drive and send us the link to download it by using our developer contact form here.

Thanks again, and please let me know if you still need technical assistance. If the proposed solution works, please mark this ticket as resolved.

Thank you for your interest in using the Prime Mover plugin! Regarding your question – yes, you can use this plugin to convert your multisite main site into a WordPress single-site installation.

We have a complete tutorial on approaching this conversion to a single site. Please note that this conversion process to a single site (from your multisite main site) uses the PRO version of the plugin.

If you have further questions, please contact our official technical support for PRO plugin inquiries. According to ww.wp.xz.cn support policies, we cannot answer PRO plugin-related inquiries in this forum, so I’m closing this ticket.

Thank you again for your question.

This ticket has been closed due to inactivity. Prime Mover 2.0.5-beta1 is now available. It includes controls on the non-writable plugin manager script inside mu-plugins, ensuring you always use the latest mu-script version. It will be released in a few days.

If you still have the same issues, please re-test using the latest beta first. Then, open a separate ticket if you still need technical assistance. Thank you again!

Regarding your other question, Prime Mover does not have custom tables in the database. It only stores settings in the wp_sitemeta table with a prefixed option like “prime_mover.”

You can query it like:
SELECT * from wp_sitemeta WHERE meta_key LIKE '%prime_mover%'

And it also stores user specific preferences in the user meta table; you can also query it like:

SELECT * from wp_usermeta WHERE meta_key LIKE '%prime_mover%'

Please note that if you delete data from your database, you must first perform a manual dump. Thanks and please let me know if you still need any technical assistance.

Hello, thanks for using the Prime Mover plugin! I’m sorry to hear you have experienced performance issues and other issues.

For issue #1:

This is strange since the plugin is not designed to run extensive queries in real-time when not performing backups or migrations. It will only execute queries if needed during maintenance and migration.

Therefore, this issue is strange. Out of curiosity – we tried reproducing your setup in our local test environment with the following configuration to check if indeed the problem is reproducible:

• Latest WordPress multisite setup.
• Install all popular WordPress plugins and activate them on the network. This will simulate a heavy multisite with many plugins.
• Install the query monitor plugin to monitor all database queries that have been executed.
• Install the old version of Prime Mover 1.9.9 and activate the network.
• Check if there are repeated queries that match with UPDATE wp_sitemeta SET meta_value = 'a:12:{s:21:\"id_slug_type_path_map\";

RESULT: No matched queries found.

• Now upgrade the plugin to the latest version, Prime Mover 2.0.4, and check for repeated database queries.

RESULT: Same, no matched queries found.

We cannot reproduce the reported excessive queries in all the above tests.

For issue #2: Regarding your second issue of being unable to export using Prime Mover 2.0.3, we tried reproducing this following the above steps, and after upgrading to Prime Mover 2.0.4 (the latest version), the export still works.

Regarding the database lock, a check was added to ensure that only one export process can transact with the database export. This is to prevent errors and optimize performance. This should not cause any issues on the multisite.

Recommendation solution: To resolve issues #1 and #2, we recommend installing the latest version of the Prime Mover plugin. This will ensure that you start with a fresh state that runs in the newest version. These are steps:

• Login as network administrator.
• Go to Network -> Plugins.
• Delete all old versions of the Prime Mover plugin from the plugins. This will safely uninstall the plugin.
• Clear and reset Freemius data on your site by following this procedure.
• Install the latest Prime Mover version 2.0.4. This is recommended since it’s the most up-to-date with the latest stability and performance fixes.
• Network activate Prime Mover 2.0.4, and in the opt-in screen, click “Skip” – this will simplify the activation.
• When the plugin is successfully network activated – try doing an export and check if it works.

If reported issues persist

If the above recommendation cannot resolve the above-reported issues, we need to debug your site and check what is causing it. We will then know if this problem is related to your server or if an issue with the plugin happens only in a specific environment/set of plugins or setup.

To do this, please provide us the following:

• SQL Database dump of your multisite where the issue happens.
• Zipped off your entire plugin’s directory and themes.
• Go to Prime Mover -> Advanced -> Advanced Settings Panel -> Upload/Download Parameters -> Export site info and click “Export site info “. This will download details of your site info, including your Prime Mover settings data. This is your site information log.
• Put the above-requested files in a folder and zip them. Then, upload them to Google Drive and send us a link to download them by contacting us using this form.

Our technical team will investigate this issue using the provided database, plugins, and themes. This will allow us to determine what is causing these performance issues and resolve them.

If the above assistance and workaround fix the issue, please mark this ticket as resolved; otherwise, please provide us with the requested files so we can check further. Thank you again!

Hello Renzo, thank you for your interest in using the Prime Mover plugin! Regarding your question, I’m sorry, but this is not possible yet with the plugin. It is because during restoration, the existing database tables and data are cleared in preparation for the migrated data.

Once the data from the source site is migrated – the old data no longer exists. However – if you want some “merging” functionality – you can do the following steps (which are not provided by the plugin, but you will use other tools):

1.) In your target site – export the content in advance before the restoration of new site data by the Prime Mover plugin. WordPress has complete documentation on how to export your posts, etc.

2.) Migrate the package to your target site using the Prime Mover plugin. This will overwrite the data on the target site and replace it with data from the source site.

3.) Import and restore the exported XML file from step 1 using WordPress tools (e.g., WordPress importer plugin). This will effectively merge the old content with the target content of your target site.

However, please note that we cannot guarantee that the above steps will work as you expected, as it depends on your data and site functionality. However, you can try them if you need to test a solution. We cannot support the default WordPress exporter/importer; if you need technical assistance, you must request it in the WordPress forum.

Thanks again, and good luck!

Hello Darek, thank you for rating us five stars and sharing your product and support experience with the Prime Mover plugin. Cheers!

Thanks for using the Prime Mover plugin and rating us five stars. We are pleased that you found it easy to use. Cheers!