IMHO that would depend on the hosting company and what resources you are limited to. Let’s say you pick Amazon’s MySQL RDS. There are seven server models permitted. Each model allows a maximum value for the number of connections. I wrote a post about this last month in the DBA StackExchanage : Should I increase … Read more
I’m no SQL expert, but I think it would look something like this: SELECT * FROM mydatabase.wp_users INNER JOIN mydatabase.wp_usermeta ON (wp_users.ID = wp_usermeta.user_id) WHERE 1=1 AND wp_users.user_registered > ‘2014-03-15 00:00:00’ AND wp_users.user_registered < ‘2014-03-16 00:00:00’ AND ( (wp_usermeta.meta_key = ‘wp_capabilities’ AND CAST(wp_usermeta.meta_value AS CHAR) LIKE ‘%\”subscriber\”%’) ) ORDER BY user_registered ASC ;
Why not use get_comments(), instead of trying to roll your own with $wpdb? function display_sitewide_comments() { $sites = wp_get_sites(); $network_comments = array(); $max = 20; foreach( $sites as $site ) { switch_to_blog( $site->blog_id ); $args = array( ‘number’ => $max, ‘status’ => ‘approved’, ); $network_comments[$site->blog_id] = get_comments( $args ); restore_current_blog(); } // inspect the comments … Read more
My first thought is that your site is using a wp-config.php file that’s located in the parent directory of your WordPress install. NOTE: Since Version 2.6, wp-config.php can be moved to the directory directly above the WordPress application directory. src Some admins like to use this feature in an attempt to make their setup more … Read more
Database with mixed collation (utf8mb4 & utf8_general_ci)
Is the usage of ON DELETE CASCADE wrong or not allowed on wordpress?
I was shocked to see that such a simple thing is not readily supported. I was even more shocked to see that no one had a good answer here on StackExchange! Happily, I found this post: https://wordpress.org/support/topic/updating-current-page-with-new-built-page/ …and am grateful for the answer provided by Joy (@joyously on WordPress.org and Slack) “If you need to … Read more
You can use plugins such as BackupBuddy, but I prefer to script this and use wp-cli, which reads wp-config.php and means you don’t have to worry about mysql credentials. wp-cli allows you to: export the db: wp db export <filename> import the db: wp db import <filename> safe search and replace (including serialised data): wp … Read more
you can export tables of your database that you want to transfer, and Import to another database, then you should change Prefixes of those .
Down- and uploading CSVs is a tough one that forces you to make a bunch of steps manually which is prone to human error (and typos). My suggestion would be to do something that you can battletest locally in a local copy of your DB. Steps to follow: Make a database dump using the mysqldump … Read more