You should be able to move WordPress multi-site the same way you would any other WordPress site. Assuming your development environment is similar to production then yes. Moving a WPMU isn’t hard but can be tricky. The Codex has pretty good documentation on how to do this. If you try with the command line and … Read more
I had a similar issue on another site recently, memory usage was through the roof. When I checked the db, wp_options was about 80megabytes. Running this SQL reduced the entire db to 15mb: DELETE FROM `wp_options` WHERE `option_name` LIKE ‘%_transient_%’ Obviously, replace wp_ with your table prefix.
The use of SQL_CALC_FOUND_ROWS is not really a problem, although it incurs an overhead. What happens is, WordPress uses SQL_CALC_FOUND_ROWS in order to determine the total posts that would have been returned, if no LIMIT clause was provided. This is necessary in order to calculate and provide you with correct pagination links. Disabling it unconditionally … Read more
Should I hint table index for search query on wp_post
At first, I think you should sync your database tables via linux rsync command. It is a solid way, more as an script inside your wp install and his dependencies. However you will update the password in the second table after an change of a password. I think you should use the WP hook after … Read more
Exporting revisions
Is it safe to delete from db orphaned posts i.e. whose post_parent no longer exists?
Reset permalinks at Dashboard>>Settings>>Permalinks and be sure WP says it was able to make changes to the .htaccess file, or make the changes yourself it fails to write to .htaccess. Did you change installed directories? I.e., from /wordpress/ to root? If so, see http://codex.wordpress.org/Moving_WordPress And if you moved to a Windows IIS server, be sure … Read more
Sounds like browser prefetching, see WordPress core tickets #12603, #14382, and #20192. Basically, sometimes some browsers see what the next post is, and decide to go ahead and load it while you are reading this one. So when you go to the next post it loads immediately, instead of you having to wait. The downside, … Read more
Whenever I’m trying to link two sites, I find the most efficient and least destructive way is to use the WordPress XMLRPC API. http://codex.wordpress.org/XML-RPC_WordPress_API/Posts In this case, you could pull this info through using the built in IXR_Client library. This saves a ton of time writing code and trying to mix databases. If they wind … Read more