[peterlaursen]

I think the easiest would be if you attached

1) a small .csv file to reproduce with

2) a screenshot of you settings in the import dialogue

3) the CREATE TABLE statement ofr the table you are importing to.

[peterlaursen]

“last week sometime SQLYog just started refusing to populate”

and

“Now it only ocassionally reports data in tables”

and

“it's happening on all of the two or three connections I use most”

To me all this indicates an issue on the network.  Some kind of termination of the stream of data. A program like SQLyog will not “sometimes” do like this.  But I cannot explain why SQLyog does this and other clients not.

It is not a permission issue.  The server would then send an error message and SQLyog would print that error.

Can you experiment with different types of connection?  Different localities for the client machine?  Could we have remote access to one of those servers?

[peterlaursen]

@Rohit

Ron wants this in DATA tab – not RESULT tab!

I think it is more than a year ago I told theat he could SELECT * FROM … and work from RESULT tab!

[peterlaursen]

and btw: I think your request is extremely dangerous (though of course there will always be situations (users + data) where everything may make sence).  That would very easily become a 'out-of-sync tool' that way!

The only solution I can propose right now is to 'split' the table into two or more tables – one with data that shall sync, another with data that shall not.

[peterlaursen]

No .. you cannot 'filter out' columns.  SQLyog/SJA data sync will always sync complete rows.

The specification is used to select only specific columns for calculation of checksums and not sync.

If for instance you have a unique column (more than the PK) you can speed up things by onlyusing this one for checksums.

Please refer to the article (that still is almost correct):

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

[peterlaursen]

If I understand you correctly, you can do this:

create a batch file that exectues

– a SJA sync job

– a SJA notifications job that does the UPDATE

and you can execute and/or schedule the .bat file

refer to: http://webyog.com/faq/27_35_en.html

[peterlaursen]

I experienced the same first I tried Vista.  But later it (sqlyog.ini) appeared again (after I changed in Vista standard settings) .  I have changed quite a lot in Vista settings and I never researched in depth which of the settings that made the difference, but I think windows Explorer on Vista hides .ini files away in a special folder by default!  

1) try go to control panel .. folder settings .. show and

— uncheck 'hide file extensions for known file types'

— check 'show hidden files and folders

2) Check the user's 'roaming' folder.  (c:users{user}AppDataroamingsqlyog – and note AppData is a hidden folder)

I also have a sqlyog.ini there.  It is zero byte.  (and you may notice that your 'favorites' are also there on Vista!)

But I think before I disabled the Vista (crap) extended user account control feature it had some size differenct from 0 (zero).

So maybe Vista moves .ini files to that folder with that so-called security-feature enabled …

3) you may also try using command line to locate the file.  See attached image! (and I you have a non-English Vista you will also get across the most annoying localisation bug in Vista: command-line has problems with using localized folder names! – but maybe this should be considerd a 'feature'!) (my image shows the traditional position of the file, because the way I have configured Vista it stores configuration data like 2k/XP/2003 does

And if you find out the exact reason for this or can give more details, don't forget to tell!

[peterlaursen]

well ..

1st issue: MySQL 4.1 does not support ” . ” in table names

2nd issue: Mapping from the GUI won't override the text-driver (with 'ordinary' drivers it does work)

good weekend for you too!

[peterlaursen]

@zimmer

We created the table in advance by copying the CREATE statement from you jobfile.

After that data imported without any problems.

[peterlaursen]

thanks manoj .. :huh:

[peterlaursen]

Please ..

1)

COMPLETE MySQL server version (not only 4.1 but 4.1.20 or whatever!)

2)

basically you should always upgrade SQlyog to latest version before reporting an issue

3)

And the error is now what?

[peterlaursen]

I replied in the ticket.

You should of course log on to the Customer Portal!

We have 'polite self service' here! <_<

[peterlaursen]

Any 'transactional behaviour' here is not due to SQLyog.  SQLyog currently does not support transactions at all and does NEVER 'start transaction'!

I cannot comment further as I do not understand the setup spreadsheet >> procedure >> trigger

[peterlaursen]

I am not sure I quite understand!  Except that you seem to have problems with registration details!

I will paste a 'standard reply' from our support ticket system:

***********************************************************'

To retrieve lost regsitration information and to download the latest stable SQLyog ENTERPRISE you should use our Customer Portal.

You can see everything that we have registered about you and maintain your data (such as email adress) yourself.

The Customer Portal is available from

http://webyog.com/CustomerArea/

we have you registered with the email adress '************'. You must use this adress too as the userid for the first lonon to the system. First you must request a password. It will be sent to you. In case the above email adress is no longer available to you, we will need to change it manually for you to get started with the Portal. If so please tell here what the new email adress should be.

Note that download links and display of registration data are only active for users who still have free upgrades.

For details please refer to our upgrade policy at:

http://webyog.com/faq/30_129_en.html

***************************************************************''

If you need more help then please create a ticket at:

http://www.webyog.com/support/ttx.cgi

and give the details so that we can identify you (email, to whom program was regsitered or anything else)

[peterlaursen]

and you still get the error?

SQLyog Program version?? (please update if possible!)

MySQL version ??

Can you attach a .csv file with sample data to reproduce with?

[Author]

Posts