Bug #98278 mysqldump: [ERROR] unknown variable 'prompt=\u@\h [\d]>\_'.
Submitted: 17 Jan 2020 22:47 Modified: 18 Jan 2020 13:11
Reporter: Cody Adams Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:8.0.18 OS:Windows
Assigned to: CPU Architecture:Any

[17 Jan 2020 22:47] Cody Adams
I added a my.ini file to my MySqlServer80 subfolder to modify the cli prompt like so:

prompt=\\u@\\h [\\d]>\\_

When I attempt to dump any databases from the command line i get the following error: [ERROR] unknown variable 'prompt=\u@\h [\d]>\_'.

if I comment out the prompt definition;
#prompt=\\u@\\h [\\d]>\\_

I am able to dump ddatabases.

How to repeat:
add the following to your copy of my.ini:

prompt=\\u@\\h [\\d]>\\_

open windows cmd window and attempt to dump a database

c:\mysqldump -uroot -p my_sample_database > my_sample_database.dump
[18 Jan 2020 13:11] MySQL Verification Team
Hello Cody Adams,

Thank you for the report.
Imho this is duplicate of Bug #74899, please see Bug #74899