Skip to content

Add an example to avoid error on MySQL 8#103

Closed
miya0001 wants to merge 1 commit intomasterfrom
add-example-for-mysql8
Closed

Add an example to avoid error on MySQL 8#103
miya0001 wants to merge 1 commit intomasterfrom
add-example-for-mysql8

Conversation

@miya0001
Copy link
Member

@miya0001 miya0001 commented Jul 14, 2018

We will have an error with MySQL client 8.x like following.

$ wp db export 
mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'wordpress' AND TABLE_NAME = 'wp_commentmeta';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)
[miya@mac kankou-kushimoto.test (master)]$ wp db export --column-statistics=0

This pull request will add an example to avoid this error.
Feel free to update my English. 😊

@miya0001 miya0001 requested a review from a team July 14, 2018 18:33
@schlessera
Copy link
Member

schlessera commented Jul 16, 2018

Thanks for the pull-request, @miya0001 !

However, I think we should rather check the mysqldump version and add the --column-statistics=0 by default to mysqldump version 8+. This will probably break for everyone, so to avoid lots of support requests, just fixing the issue automatically seems preferable to me.

@miya0001 miya0001 mentioned this pull request Jul 20, 2018
Merged
@miya0001 miya0001 closed this Jul 20, 2018
@miya0001 miya0001 deleted the add-example-for-mysql8 branch July 20, 2018 15:58
@miya0001
Copy link
Member Author

miya0001 commented Jul 20, 2018

I am working for it on #105

@jacklowrie jacklowrie mentioned this pull request Nov 3, 2019
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

command:db-export

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

2 participants

@miya0001 @schlessera