Toad World® Forums

Data Point 3.5 Error: Incorrect information in file: '.\mysql\proc.frm'


#1

Hi,

Upon attempting to connect to Salesforce, I receive the following Database Error:

MySQL Database Error

Incorrect information in file: ‘.\mysql\proc.frm’

Thanks,

Rick


#2

You need to reinitialize Local Storage.

We use the Local Storage when connecting to Non-Relational data sources like Salesforce, and the error here tells me that it somehow got corrupted. We would need to reset it, but do keep in mind that you may lose whatever data you have stored.

First, start up TDP (DO NOT connect to Salesforce yet!), and go to Tools->Options->Local Storage->General

Find this folder and rename it. Then try connecting to Salesforce.

If something goes wrong, you can clear out whatever folder this generates and rename the former local storage folder to its old name.


#3

Ryan,

Thank You Very Much.

J

That did the trick.

Thanks Again,

Rick

Rick Girardi

Business Intelligence Analyst

Enterprise Risk Management

Wilbur-Ellis Company

345 California Street, 27th Floor

San Francisco, CA 94104

Office: 415-772-4029

Fax: 415-772-4011

rgirardi@wilburellis.com

From: Ryan Johnson [mailto:bounce-RyanJohnson@toadworld.com]

Sent: Tuesday, November 18, 2014 2:08 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Data Point 3.5 Error: Incorrect information in file: ‘.\mysql\proc.frm’

RE: Data Point 3.5 Error: Incorrect information in file: '.\mysql\proc.frm’

Reply by Ryan Johnson

You need to reinitialize Local Storage.

We use the Local Storage when connecting to Non-Relational data sources like Salesforce, and the error here tells me that it somehow got corrupted. We would need to reset it, but do keep in mind
that you may lose whatever data you have stored.

First, start up TDP (DO NOT connect to Salesforce yet!), and go to Tools->Options->Local Storage->General

Find this folder and rename it. Then try connecting to Salesforce.

If something goes wrong, you can clear out whatever folder this generates and rename the former local storage folder to its old name.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.


#4

Are you having difficulties to find AppData folder? Please try show hidden files options in your windows explorer.


#5

Here is my suggestion:

Go to the Local Storage - General tab in options, click on the ‘…’ button, and select a folder to move the Local Storage data into. Restart TDP, and attempt to start local storage again.

Close TDP and see if there are any files in that folder you moved it to. If so, then rename that folder and attempt to start TDP and local storage again.


#6

Hi,

I’m not seeing one of my Salesforce Objects in TDP.

I have tried selecting my Salesforce connect while connected and going to View and selecting Refresh All without positive results.

I tried following these instruction however, I’m unable to rename folder because I’m in the folder.

I can’t see the folder outside of TOAD.

Any suggestions?

Thanks,

Rick

Rick Girardi

Business Intelligence Analyst

Enterprise Risk Management

Wilbur-Ellis Company

345 California Street, 27th Floor

San Francisco, CA 94104

Office: 415-772-4029

Fax: 415-772-4011

rgirardi@wilburellis.com

From: Ryan Johnson [mailto:bounce-RyanJohnson@toadworld.com]

Sent: Tuesday, November 18, 2014 2:08 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Data Point 3.5 Error: Incorrect information in file: ‘.\mysql\proc.frm’

RE: Data Point 3.5 Error: Incorrect information in file: '.\mysql\proc.frm’

Reply by Ryan Johnson

You need to reinitialize Local Storage.

We use the Local Storage when connecting to Non-Relational data sources like Salesforce, and the error here tells me that it somehow got corrupted. We would need to reset it, but do keep in mind that you may lose whatever data you have stored.

First, start up TDP (DO NOT connect to Salesforce yet!), and go to Tools->Options->Local Storage->General

Find this folder and rename it. Then try connecting to Salesforce.

If something goes wrong, you can clear out whatever folder this generates and rename the former local storage folder to its old name.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.


#7

If this does not work. Please open a support ticket and they will help debug this.