68 lines
2.9 KiB
Markdown
68 lines
2.9 KiB
Markdown
# utf8mb4 database upgrader for WP-CLI
|
|
|
|
Force upgrade your WordPress database to `utf8mb4` via WP-CLI.
|
|
|
|
## Description
|
|
|
|
This WordPress plugin is designed to upgrade your WordPress database to `utf8mb4` via WP-CLI. The plugin will go through each table in your database and upgrade its collation to `utf8mb4_unicode_ci`.
|
|
|
|
Why would you do this? Maybe your WordPress install missed running this conversion when WordPress 4.2 first shipped. If it did, you may be [affecting your site's performance](https://www.percona.com/blog/charset-and-collation-settings-impact-on-mysql-performance/) — so upgrading your database is a good idea.
|
|
|
|
## Installation
|
|
|
|
1. Upload the plugin files to the `/wp-content/plugins/utf8mb4-cli-upgrader` directory, or install the plugin through the WordPress plugins screen directly.
|
|
2. The plugin can be run via WP-CLI with the following command: `wp upgrade_utf8mb4`.
|
|
|
|
## Requirements
|
|
|
|
- WordPress 4.2 or higher
|
|
- PHP 5.6 or higher
|
|
|
|
## Usage
|
|
|
|
To run the `utf8mb4` upgrade on your WordPress database, use the WP-CLI command:
|
|
|
|
```
|
|
wp upgrade_utf8mb4
|
|
```
|
|
|
|
The output will look like this:
|
|
|
|
```
|
|
Table wp_commentmeta current collation: utf8_general_ci
|
|
Table wp_commentmeta converted. New collation: utf8mb4_unicode_ci
|
|
Table wp_comments current collation: utf8_general_ci
|
|
Table wp_comments converted. New collation: utf8mb4_unicode_ci
|
|
Table wp_links current collation: utf8_general_ci
|
|
Table wp_links converted. New collation: utf8mb4_unicode_ci
|
|
Table wp_options current collation: utf8_general_ci
|
|
Table wp_options converted. New collation: utf8mb4_unicode_ci
|
|
Table wp_postmeta current collation: utf8_general_ci
|
|
Table wp_postmeta converted. New collation: utf8mb4_unicode_ci
|
|
Table wp_posts current collation: utf8_general_ci
|
|
Table wp_posts converted. New collation: utf8mb4_unicode_ci
|
|
Table wp_term_relationships current collation: utf8_general_ci
|
|
Table wp_term_relationships converted. New collation: utf8mb4_unicode_ci
|
|
Table wp_term_taxonomy current collation: utf8_general_ci
|
|
Table wp_term_taxonomy converted. New collation: utf8mb4_unicode_ci
|
|
Table wp_termmeta current collation: utf8_general_ci
|
|
Table wp_termmeta converted. New collation: utf8mb4_unicode_ci
|
|
Table wp_terms current collation: utf8_general_ci
|
|
Table wp_terms converted. New collation: utf8mb4_unicode_ci
|
|
Table wp_usermeta current collation: utf8_general_ci
|
|
Table wp_usermeta converted. New collation: utf8mb4_unicode_ci
|
|
Table wp_users current collation: utf8_general_ci
|
|
Table wp_users converted. New collation: utf8mb4_unicode_ci
|
|
```
|
|
|
|
## Notes
|
|
|
|
**Please** run a backup of your database before running this plugin's CLI command on your site. It's as straightforward as running `wp db export` before running the `wp upgrade_utf8mb4` command.
|
|
|
|
Once this plugin has been run, you *do not* need to keep it active or installed on your site. Please get rid of the plugin by deleting it once you're done using it!
|
|
|
|
## Changelog
|
|
|
|
### 1.0.0
|
|
- Initial Release
|