[peterlaursen]

“Is it possible to schedule that task from the command line using SJA.exe”

Yes.

You can use 'Notifications Services” and the SQL to execute must be a “SELECT … INTO OUTFILE …”

that is exactly what SQLyog CSV-export does: http://webyog.com/faq/28_73_en.html

[peterlaursen]

1) is definitely fixed in beta2, 2) maybe too (I never of exactly this before).

We will release beta3 in a few hours. Plese try this!

[peterlaursen]

In teh first round a quick comment on 5)

We cannot help it! Those systems are controlled by the paymanet processor (RegSoft). It is true that the systems that handle PayPal have been problematic in periods.

You can always go here:

http://webyog.com/en/download_latest_sqlyog.php

We DO NOT WANT to administer payment systems ourselves!

But we are in the process of setting up a true 'customer portal'.

[peterlaursen]

Please answer:

1) Do you use SQLyog GUI or do you execute from SQL-pnae?

2) What does HISTORY tell – what was sent ?

[peterlaursen]

It has not been adressed.

Actually it would be smart if we /* commented out */ such column. However with every column having a DEFAULT you could have similar wishes.

This is not priority!

[peterlaursen]

now ..

contact Manoj about anything you intend to do to avoid overlap.

You can send a PM …

BTW .. adjusted the privlege settings for this category. A unregistered Guest should not be allowed to post!

[peterlaursen]

you can repeat the sync over and over again.

But please understand that synchronisations is not replication!

And understand the use of the Primary Key: source will overwrite target for the rows where the PK is identical!

[peterlaursen]

I cannot be sure!

As long as an issue is not reproduced and fully understodd, every posibilty is open!

But HISTORY compared with SERVER logs ..

[peterlaursen]

= Indexes

Do you import data into an existing table or do you crete teh table with the import?

[peterlaursen]

I have been informed that there was an issue with 5.2 beta1 tht it would sometimes not export the last row.

I did refer to this thread that I thought was yours too:

http://www.webyog.com/forums//index.php?showtopic=2343

Was I mistaken in that assumption?

[peterlaursen]

One more idea.

Try to add a 'silly' statement at the end of the file.

something like “SET @silly = 'this is the last statement';” for instance.

You could even add

SET @silly = 'this is the last statement';

SELECT @silly into outfile 'c:\silly.text';

does the file 'silly.txt' exist in C: after that?

[peterlaursen]

I do not think there is nothing like 'typical time' It depends on teh server configuration, the networks connection (if a lot of data need to be transferred) and more.

“Views” “Stored Procs” and “Functions” (and “Triggers”) are MySQL objects introduced in MySQl version 5.

Almost every Database Server support those (though implementation often is a littele different).

Refer to the MySQL docs:

Views: http://dev.mysql.com/doc/refman/5.0/en/views.html

SP's and SF's http://dev.mysql.com/doc/refman/5.0/en/sto…procedures.html

When these features were introduced with MySQL there were som pretty good articles published. Find them in this archive:

http://dev.mysql.com/tech-resources/articles/

[peterlaursen]

Not reproducable here.

I import your SQL, add a row manually, export, edit the file (change the tablename) and it imports like atached picture.

Please try to check the 'CREATE BULK INSERT' box in teh export dialogue. And set the BULK value very high in preferences. Every row of data will now be int the same INSERT statement. Now what happens?

is EVERYTHING inserted, or are NO DATA inserted?

Please let me see the SQL BEFORE the import. Are all data in there?

Next ensure that 'log batch jobs' is enabled in 'preferences'.

Check HISTORY after the import.

If server 'general log' is enabled compare the server log.

It very much look like (refer to the other discusssion) with your server/network setup that the last line is cached or dropped somewhere and never reaches the server!

[peterlaursen]

“I HAVE used the Itegra DB with this session of sqlyog,…”

It very much then looks like the 'use test_empty' statement sent by SQLyog does not reach the server or is not exeucted or is assigned by the server to a wrong client thread.

I you ever experience that again please check the HISTORY for that use-statement!

[peterlaursen]

“m getting more than one matched result for certain titles”

use GROUP BY

[Author]

Posts