Database with mixed collation (utf8mb4 & utf8_general_ci)
Database with mixed collation (utf8mb4 & utf8_general_ci)
Database
Insert custom data to custom table on wordpress database
Insert custom data to custom table on wordpress database
WordPress and automated MySQL backups to a different host
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
When and why should I use $wpdb different return types?
With everything moving towards OOP programming with classes and the use of objects increasing and favored above the use of arrays as such, I would definitely go with returning results as an object. This just makes everything easier for future use But at the end of the day, you should always use what you are … Read more
How to use user table of a different database for WordPress users?
It might work to use a view as essentially a table alias, by doing the something like the following with the WordPress instance mysql database DROP TABLE wp_users CREATE VIEW wp_users AS SELECT * FROM CI.users; However will probably need to tweak the view creation to map the columns the password encoding may well be … Read more
Can I transfer a mysql database to another site?
you can export tables of your database that you want to transfer, and Import to another database, then you should change Prefixes of those .
How to bulk edit canonical url’s in SQL?
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
wp_options table has duplicate rows and primary key / autoincrement has been removed
Well after a lot of digging, I think I uncovered what happened. The clue came from the fact that I noticed it was wp_options and all alphabetically subsequent tables that lost their primary keys. On import, first the tables are created. Next it goes through all those tables in alphabetical order and applies the primary … Read more
Importing MariaDB into Mysql in WordPress
While at the current point in time there is very little difference, and maybe no difference at all, this is a bad practice if your development environment supposed to replicate the server your code will run on. There is just no point in forking a product without having the intention to change it, and the … Read more
Does thumbnail regeneration edit the database?
Are the new image dimensions registered in the database in any way or does the resizing just occur in the uploads directory? No, the image size system is similar to the post type system, sizes are registered at runtime, not in the database. The size of some sizes are stored in the database as they’re … Read more