How can i customize the export personal data file?
How can i customize the export personal data file?
Database
Why does importing copies of the database dump and the document root make WordPress data inconsistent?
Why does importing copies of the database dump and the document root make WordPress data inconsistent?
Is there a smart way to obtain a list of only some selected user meta data?
I think you should stick to WP_User_Query. There you can simply specify the fields you want to use to select certain users. Also meta fields. WP_User_Query is a class, defined in wp-includes/user.php, that allows querying WordPress database tables wp_users and wp_usermeta. But yes(!), this will not return you user meta values. Even when setting ‘fields’ … Read more
wp search-replace (not executing)
Have a look at your PHP errors. I’ve seen WP CLI fail like that because PHP fatals out.
I am switching laptops. I host my WP server through MAMP. I want to transfer [closed]
You can backup your WordPress website using UpdraftPlus plugin. Make sure you also backup database. After setup the WP on other laptop just upload the backup.
WordPress Relational Database
The data within the database has functionals relationships. For example, user_meta and user. In that regard, it would be considered relational data. On the other hand, if you mean, that referential integrity is strictly enforced, no it is not. This is mostly a product of MyISAM which is faster but does not support foreign key … Read more
Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
As Pat J says, you shouldn’t have define( ‘WP_USE_EXT_MYSQL’, true); unless you need the old mysql functions, which you do not if you’re using PHP 7x and WordPress 5x. You do need to restart Apache after modifying php.ini. What do you have in your mysqli section of your phpinfo? Make sure extension_dir is set in … Read more
Error: MySQL shutdown unexpectedly [closed]
Error: MySQL shutdown unexpectedly [closed]
Merging two databases without borking it
This is a notoriously difficult thing to solve in WordPress because of how the database is constructed. I have since long given up on being able to merge dev -> staging -> prod. Instead, I track any and all changes I make to the database in my dev environment, manually apply those to the production … Read more
Slow queries constantly getting stuck on WordPress database of ~100,000 posts
Slow queries constantly getting stuck on WordPress database of ~100,000 posts