The number you refer to is the blog/site ID, so you have multiple methods of finding out which site it is: Look in the sites table, the number should match the ID, providing you with a URL and title Go to example.com/wp-admin/network/site-info.php?id=insert-number-here and you’ll be shown the network admin UI for that site Consider a … Read more
Firstly, the GUID is not the URL. It is a “globally unique identifier”. WordPress uses the URL for this purpose, but accessing it is not a reliable way to get the URL for anything (this was a bad idea, but is kept this way for backwards compatibility). It’s not possible to query the image URL … Read more
I would just modify Q Studio example to: global $wpdb; $table = $wpdb->prefix . ‘table_name’; $delete = $wpdb->query(“TRUNCATE TABLE $table”);
I’m sorry can’t comment here but i’ll try to help. wp_handle_comment_submission function handing comments posting contains exact check for post_id: $post = get_post( $comment_post_ID ); if ( empty( $post->comment_status ) ) { … return error_happened; } i.e. (1) it passes through , or (2) comment was added other than default way of posting comments. For … Read more
I will answer question 2, be aware that some values in the database are stored in serialised arrays. For example, if the length of your URL string changes and it’s in a serialised array, then you need to update the index for it. You can use this PHP script to update all the values in … Read more
Your specific questions: 1) There is no strict limit to the “number of entries” a DB may contain before performance is affected. Performance depends just as much on your hardware and configuration as it does on the size and structure of the DB. 2) If you’re worried about the scalability of your DB layer, you … Read more
So, it turns out that those three changes were all that were needed. It also turns out that if any of the serialized arrays are modified incorrectly (which is easy to do when modifying them by hand), the system will just assume you are not a network administrator. Correcting the serialized array for the site_admins … Read more
Using the defines the user sets in wp-config: mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); EDIT: Since your script is outside the WordPress environment, what you want to do is initiate it before using the defines in wp-config. require_once(‘./path/to/the/wp-config.php’); mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
You can paste this block of code in your currently active WordPress theme functions.php file: function wpse_footer_db_queries(){ echo ‘<!– ‘.get_num_queries().’ queries in ‘.timer_stop(0).’ seconds. –>’.PHP_EOL; } add_action(‘wp_footer’, ‘wpse_footer_db_queries’); The above block of code, will render an HTML comment in the footer of your theme (before </body> and </html>, containing the number of database queries and … Read more
I had a similar issue, I solved it and since this comes up high on Google for what I was looking for it may help others. I migrated several WordPress databases from AWS RDS MySQL to MySQL running on an EC2 instance, using the database migration service. What I didn’t know is it doesn’t copy … Read more