[maxhugen]

Thanks Mahesh!

[maxhugen]

Hi Peter, Mahesh

I suspect the problem was my fault. After rebooting my workstation, I no longer had any issues. I think I may have had a second instance of the frontend application open, and halted in the middle of a transaction for debugging purposes. Thus my dev db was in a locked state, not the production db.

Many thanks for your responses.

Cheers

[maxhugen]

Thanks for the fix. Great product. Continue to recommend it 🙂

[maxhugen]

Great, thanks very much Navya.

[maxhugen]

Quote:

Usually the status 'Compare Unsuccessful' will be displayed situations like MySQL server has gone away or any network problem if use remote connection.

This may perhaps have been the problem! I have been experiencing a strange problem, which Peter and Navya have tried very hard to figure out, that seems related to a connection issue. (See http://www.webyog.com/forums//index.php?showtopic=4066).

Today, I had to modify some fields in a third db, and when I sync'd it to the copy on my pc, it worked AOK (as it 'usually' does!).

As I've run the Sync Tool twice since, without any further problems, let's say this issue has 'gone away'. I'll add to this post if it re-appears.

[maxhugen]

Tried the Sync Tool with a different db – no problems!

[maxhugen]

Well, I've upgraded to Enterprise v7.0, but it didn't help.

I'd left SQLyog open, after clicking a table and then Table Data. (Response time was less than 1 second.)

Later, after maybe an hour of inactivity, I clicked on another table (to view its Table Data), and I timed it at approx 2m 25s before it displayed. Clicking on other tables after that, it was back to its normal response time of less than a second.

Any ideas on what I could try? Is there a setting for a 'persistent connection' or anything like that?

[maxhugen]

Sure. I'll try out v7. Thanks

[maxhugen]

Hi Peter, Navya

I'm using SQLyog Enterprise v6.16 and MySQL v5.0.

I'm using a direct connection I think – I enter mysql.[mydomain].com, specify port 3306, the db name, user and password. This is in the 'MySQL' tab on the Connection screen.

As I mainly connect to the web database, I'm not actually sure if the same problem exists with my localhost database.

wait_timeout=14400

interactive_timeout=28800

I haven't noticed any slowness in operations that do not involve server communication – like switching between TABS and operating menus in the interface.

Navya, what I tend to do is a sequence such as:

– run a simple query like “SELECT * FROM activity WHERE activity_name='PayPal IPN' ORDER BY activity_id DESC”

– click on a table, and then the 'Table Data' tab

– click on another table (to again view Table Data)

Then I'll resume coding and testing my web app, for maybe half an hour, then retry the same kind of sequence in SQLyog again. Whatever action I do first (run a simple query, or view Table Data) is very slow; then the subsequent actions run OK.

Peter, I'm not eligible any more for upgrades as I purchased on 2007-06-06, so I'd have to pay for v7.0…. do you think it would fix this?

[maxhugen]

As per my previous posts, I wasn't trying to import any queries, only the tables themselves.

When I was having issues, I tried rebooting, everything I could think of. But now I can't recreate the problem, no matter what I try!

[maxhugen]

Hi Peter,

Well, this has got me stumped! I tried the Migration with some other mdbs to test if it was a common problem – and now it works!

I tried an A2003 mdb first, no prob.

Then an A97 mdb, again OK.

Then I went back to the A2000 mdb I've been having issues with, and tried it again – it worked!!!

I haven't done anything to the A2000 mdb, nor the ODBC DSN, so I'm quite at a loss to explain the previous problem behaviour.

Cheers, Max

[maxhugen]

I've given up trying the migration with SQLyog Enterprise. I used Graycode's suggestion of the Bullzip 'Access To MySQL' product at http://www.bullzip.com/products/a2m/info.php. It worked AOK.

[maxhugen]

Hi Mahesh,

I am selecting 'Copy table(s) from data source' – not using queries. As per the link you provided, I have given the default Admin user and the Admins group full administration permissions to the 5 system tables, but it hasn't made any difference.

During the migration, the status window shows each table schema being successfully imported, but at the end the msg '[Microsoft][ODBC Microsoft Access Driver] Query support unavailable.' is repeated.

[maxhugen]

Back again, I'm sorry, with the same sort of problem. Since my previous posts, I've bought a new workstation, software details are:

Windows: XP SP2

SQLyog: 6.16

Access ODBC driver: 4.00.6304.00

MDB version: Access 2000

ODBC DSN type: User

Symptoms:

Using the Migration Toolkit, after selecting 'Copy table(s) from data source', I first get a msg 'The underlying database seems to be Microsoft Access. To correctly import…'

I click to continue.

Next, another msg pops up '[Microsoft][ODBC Microsoft Access Driver] Query support unavailable.' Click . The same msg appears for second time, click again.

All table schemas are successfully imported, but no data.

This is driving me nuts, can anyone suggest what I might try?

[maxhugen]

Thanks for the explanation, Peter.

[Author]

Posts