Usually you only have to use mysql.domain.com if connecting to a remote database. If that is what you are doing, then yes. It will be slower than a locally hosted database. Even if the domain resolves to the local server localhost should resolve quicker as it uses the loopback interface which bypasses network hardware.
If you get that Database update message, looks like WordPress may have updated. Probably you want to turn automatic updates off. Simply do: 1 – Restore your db where it works ok 2 – Add this to your wp-config.php: define( ‘AUTOMATIC_UPDATER_DISABLED’, true ); 3 – Enjoy!
Yes You can do it. You use two different prefixes for both sites in database.
Quite a few options you have here but the simplest I suppose would be to change your SQL query like so: SELECT 0 AS id, user_login AS name, display_name AS tag, user_status AS status FROM wp_users; You can see that now we have the needed order and when you will do the $row[‘id’] = $i; … Read more
I would recommend that your do the get the following from theme. There host. It is good to know a persons host before starting work on there website. You should make sure that you have full admin access, or if they have multisite then Super Admin. This way you can have all the freedom to … Read more
posts_join is only a part of the full SQL query, the table you’re joining to is referenced earlier in the query. You can see the full query with the posts_request filter. See the documentation for the rest of the query filters.
The best ways to get content OUTSIDE of WordPress would be (listed in my order of preference): By using the WP REST API plugin (soon to be fully integrated into core) Via RSS feed as mentioned by @AricWatson in the comments above. Direct queries into the MySQL wp_posts and wp_postmeta tables. When content is rendered … Read more
The data is serialized. You can try an online editor like this one (just use JSON), otherwise you can do it with a little PHP: $data = unserialize( $your_serialized_data ); $data[‘this’] = ‘that’; echo serialize( $data );
Instead of replace url directly in mysql db Try with Velvet Blues Update URLs wordpress plugin. It is safe to use this plugin. Because mysql db has some serialize values for post meta key. In that case your solution will not work proper. I had used velvet blue update urls plugin many times while migrating … Read more
Commenting out the line innodb_force_recovery = 1 in /etc/my.cnf thus: # innodb_force_recovery = 1 made the mysql innodb tables in the database accessible. Apparently this setting causes innodb to become read-only. I hope this helps someone in the future. If you don’t have access to /etc/my.cnf on shared hosting, ask your host to fix it … Read more