If the language collation of your production and staging site database server is different you can use the MySQL query below to create a new query that allows you to change the language collation of all database tables at once. SELECT CONCAT(“ALTER TABLE “, TABLE_SCHEMA, ‘.’, TABLE_NAME,” COLLATE latin1_general_ci;”) AS ExecuteTheString FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=”DATABASE_NAME” AND … Continue reading “Change Language Collation of all mySQL Database Tables”
Tag: database
MySQL Query – Delete all WooCommerce Bookings
If you need to delete all WooCommerce bookings that have the custom post type wc_booking you can use the MySQL query below:
Serialized Data, What Does That Mean And Why is it so Important?
Note: This article is for people interested in how WordPress technically stores its data. If you just like to use WP Staging, you do not need to read or understand the article below. WordPress core and most of its plugins are storing data in the database in a particular format, so-called serialized data representation. That … Continue reading “Serialized Data, What Does That Mean And Why is it so Important?”