Common update problems: patcher [unknown database 'nelsoft_retail']

Error encountered: 

The cause:

Solution:

Set the environment variable to the path where the mysql.exe can be found.  It's usually under program files\mysql\mysql server 5.5\bin (remember to put semicolon (;) after every directory

Result