DevHints

MySQL Administrator: Backup Error: Cannot set ANSI quotes

Posted on: December 7, 2008

Posting this here because I just ran into the problem and couldn’t find a solution on the interwebs.

If you’re using Mysql Administrator on a Mac and you try to schedule an automated backup only to find your SQL backups only a few lines long. You probably won’t see an error anywhere, either. Here’s your fix:

Go to Preferences and to the General section. Change the password storage type from Keychain to Obscured. The problem is that Mac OS won’t let the automated program have access to the Keychain, so it can’t connect to your database and get to work.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: