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
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
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
zcat /path/to/file.sql.gz | mysql -u ‘root’ -p your_database > will write the output of the mysql command on stdout into the file myfile.sql.gz which is most probably not what you want. Additionally, this command will prompt you for the password of the MySQL user “root”.
For wp-content folder you need to add WP_CONTENT_DIR with path to this folder to each wp-config.php file of each your sites. All of these WP_CONTENT_DIR constants should have the same path to one folder. Read more about it here: http://codex.wordpress.org/Editing_wp-config.php#Moving_wp-content To share the same database, you just need to setup the same database settings in … Read more
Old versions of mysqlnd worked with legacy database passwords. I had to update the database to use more secure password format before the mysqlnd plugin would connect from WordPress 5.0.3 to php 7.3 PHP Warning: mysqli::__construct(): (HY000/2000): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset … Read more
You have typing mistake. You are using the double quotation mark instead of single quotation mark at the end of the code post_status = “publish” Please use post_status=”publish” instead of post_status=”publish” and then use double quotation mark at the end of query. And also make sure that dynamic values are correctly entered in the query … Read more
I have solved my problem and want to share it with anyone who has problems like me. First, you should find out about a few simple SQL commands to make it easier to manipulate the database. I learned them at https://www.w3schools.com/sql/ My idea is that I will export all the data I need into a … Read more
Preface It would be best to see what kind of caching options are available through your host. If you can use an object cache, CDN, or anything like that, you could decrease the load on your server. If your database and webserver are the same host, then storing this in the database won’t necessarily mean … Read more
You shouldn’t be using mysql_num_rows() or mysql_error() when dealing with $wpdb. Even if you weren’t, mysql_error() is for database errors, and an empty result set is not a database error. If you want to know if results were returned, simply check the count() of the results: $duplicateEmail = $wpdb->get_results($emailTest, OBJECT); if ( count( $duplicateEmail ) … Read more