Untested, but I believe you can do something like this: add_action( ‘init’, function() { // since were editing content, we want to be very very careful // well do a dry run output first to make sure were doing what we want $dryrun = true; // Regex pattern finds anything between the X and Y … Read more
InnoDB is insanely picky about it’s config; if something’s not right, it’ll just give up and go home. To make a change to the log file size without data loss: Revert any config changes you’ve made to the log file size and start MySQL again. In your running MySQL: SET GLOBAL innodb_fast_shutdown=0; Stop MySQL Make … Read more
An understanding of how WP stores content is important. Pages/posts’ content is stored in the database. Media files are stored in the uploads folder, and the pointers to the media (their URLs) are stored in the database. (Media files are just another type of post/page.) The base URL for your site is stored in the … Read more
The command SHOW GRANTS [FOR user] is what you’re looking for. See here for more detail.
When localhost parameter given, MySQL uses sockets. Use 127.0.0.1 instead.
That’s why I’m wondering why is WordPress stuck to this pre-PHP-5.3 limitation. Because WordPress has made the decision to support PHP 5.2 due to the large number of hosts that continue to use it. This is an ongoing debate and there’s no point rehashing it all here. But this means that I have to know … Read more
Encrypting the DB-Password in the wp-config.php is of no use, neither in your use-case nor in any other. What is encrypted, has to be decryptable by the system in order to access the database, which means if an attacker is able to get your wp-config.php, he can get everything he needs to decrypt the encrypted … Read more
Instead of adding new columns to the WordPress database, you might want to use the wp_usermeta table. It is used to store any kind of data about your users (just like the wp_postmeta for your posts and pages). To add fields on the registration form you can use the user_new_form action which is triggered by … Read more
In versions of WordPress prior to 4.2 terms could belong to multiple taxonomies. This is no longer the case and in WordPress 4.2 or newer new terms cannot belong to multiple taxonomies and any existing terms that belong to multiple taxonomies are split into multiple terms whenever they are updated. You can read this post … Read more
You can try to trace in the PostgreSQL log file what pg_dump –table table –schema-only really does. Then you can use the same method to write your own sql function.