Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Plan replayer requires additional option on connection string when using MySQL #16497

Open
terry1purcell opened this issue Feb 8, 2024 · 0 comments

Comments

@terry1purcell
Copy link
Contributor

Change Request

Please answer the following questions before submitting your issue. Thanks!

  1. Describe what you find is inappropriate or missing in the existing docs.

https://docs.pingcap.com/tidb/dev/sql-plan-replayer

When using plan replayer, import can fail when connecting as MySQL. There is no documented solution or visibility to this issue on the plan replayer page.

  1. Describe your suggestion or addition.

When using plan replayer, it you are using MySQL - you will want to include the recommendation that can be found on this documentation page:
https://docs.pingcap.com/tidbcloud/tidb-cloud-import-local-files

The recommendation from that page is:
If you use mysql and encounter ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access., you can add --local-infile=true in the connection string.

  1. Provide some reference materials (such as documents and websites) if you could.

Reference provided is from an existing PingCAP documentation page.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant