Your problem is most likely not the size itself but how queries are being done. This could be a result of non optimal code or bad DB structure. As with all optimization you first need to find the actual bottle necks and than to decide if you fix the code, or maybe just scrap the … Read more
2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
Relational / Associate tables using native WordPress functionality
Your verify.php files lives outside WordPress framework, so $wpdb and everything else is not available. Correct way is to use admin_post_ hook. You can read about it here. This goes in functions.php add_action( ‘admin_post_add_foobar’, ‘prefix_admin_add_foobar’ ); function prefix_admin_add_foobar() { //$wpdb->update() } And the form: <form action=”<?php echo esc_url(admin_url(‘admin-post.php’)); ?>” method=”post”> <input type=”hidden” name=”action” value=”add_foobar”> <input … Read more
In general you should always develop under the final URL the site is going to be located in, if you are going to put content or anything else which contains URLs ad part of the development. Not sure what gave you the idea that you can just search replace things in the DB and it … Read more
Search and replace http:// to https:// 10x my database size
Database structure for thousands of posts
It seems like your sites are using same database. If you have time to do it again, you can try moving your website by using plugin All-in-One WP Migration
Thanks everyone, I have fixed the problem. The reason why there was an error was because the data was fetched as an object, not string. All I had to do is use WordPress Helpers instead. I used the $wpdb function to connect to the external database, then used the helper get_var() to fetch the text … Read more
Thanks everyone, I have fixed the problem. The reason why there was an error was because the data was fetched as an object, not string. All I had to do is use WordPress Helpers instead. I used the $wpdb function to connect to the external database, then used the helper get_var() to fetch the text … Read more