[peterlaursen]

Quote:

i have already looking for sugestions but without any result

Did you look in the FAQ ?

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

[peterlaursen]

You cannot have a and a in one jobfile. Only one job per jobfile! So you will have to create a batch file running first the and then the from each their files.

simply a textfile like

Code:

sja mysync.xml ..and possibly a l and s parameter as well
sja mynotify.xml .. same

On windows that file must be named a .bat. On LINUX name can be anything.

Multible jobs in more jobfiles is on the TODO. So is also SMTP-functionality in DATA SYNC (like BACKUP and MIGRATION has allready). Some of those details that there never was time to finish.

BTW: your SJA is a little old! Latest version is 5.01 (also for LINUX)

[peterlaursen]

Issue confirmed (with 5.0x and direct connections from Windows client to Linux server).

Also DATA SYNC is affected

Quote:

Sync started at Mon Feb 20 13:05:03 2006

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted

=========================  =======  =======  ========  =======  =======

Could not get FIELD information for '`testTable1`' in the TARGET database

But this

Quote:

MySQL is case sensitive, SqlYog is not

is somewhat an exageration – not true everywhere in the program. Attached picture show the CREATE TABLE can handle 'cases'. And common SQL processing from the GUI can. Also 'rename table' handles it. So it could be a workaround to rename one of the tables before running the STRUCTURE SYNC. 'rename table' is fast as it does not involve copying of data.

But all 'powertools' in particular should be checked! A trivial thing as a wrong operator for compare may cause this!

But when I wrote this: http://webyog.com/faq/index.php?action=art…ase%20sensitive is thought it was fixed!

Quote:

This is a major functional issue

aahhh .. MAJOR ??? excuse me major ??? 😀

It is just a silly bug!

EDIT: I replaced the image – first one was wrong.

[peterlaursen]

You did not experience that with 5.01 either? That is pretty strange then!

But you have a PM!

[peterlaursen]

Not my experience! I don't think 5.02 has crashed a single time here since it was released. This is true for two Windows XP-SP2 installations and one WINE installation. I use it probably around 3-4 hours per day in average.

Looks like the SQLyog process is being killed suddenly on your system since even the Windows standard popup *SQLyog(Ent).exe has caused an error and will be shut down* (or whatever it is exactly in English) does not occur. Any idea how this could happen?

Do you have a chance to test on other systems?

[peterlaursen]

Added your solution (and a previous one too) to the FAQ:

http://webyog.com/faq/23_36_en.html

[peterlaursen]

@ritesh:

After thinking a little I think the solution to this is to add a SPECIAL wizard for migration of more ODBC-tables into one. Mostly relevant for text-files but not only that.

It will only need one row of fields/buttons in the import-settings windows of the wizard!

[peterlaursen]

I produced a cartoon for you. Usually that is no good when Danish people do this, but hopefully this one won't offend anyone! 🙁

Destination: I think the easiest will be to select from GUI

Map: are fetched from table imported to

Advanced: can be searched and replaced from an editor

Where: left empty

@ritesh: GUI issue: For import of more SOURCE tables into ONE DETINATION table with identical maping like here there could be an option to fill in only one row and 'apply to all'.

…. hmmm .. but HOW precisely ?!

[peterlaursen]

First .. I am sorry, it seems to be the wrong XML file! This one should be better

Second .. you are right. We need a GUI improvement for 'multible csv/txt import'

Third: I think the easiest will be

1) create an empty table in advance to import to

2) now the Wizard will use the mapping of this table. Choose import into it (not delete for each table!) for first table only

3) generate an XML file using defaults for TARGET for rest 499 of tables

4) Use 'search and replace' in an editor to correct those 499 entries

[peterlaursen]

Well thanks then.

I think I will be able to improve the FAQ.

[peterlaursen]

well .. yes this is true.

Maybe we should improve the wizard in this respect.

I don't thin the wizard was designed with this special case (multible CSV/text) in mind.

Couldn't you possible just use the defaults/driver proposal and ALTER TABLE after import?

Find a sample XML attached (the 196 table thing). But 500 is quite a deal.

But hold on .. I am in the proces of unzipping my test data .. 🙂

[peterlaursen]

BTW: is this

QUOTE

1) make sure your '/etc/hosts' file reads as follows:

CODE

127.0.0.1 localhost                //localhost *MUST* be first (notice separate entries)

127.0.0.1 localhost.localdomain

127.0.0.1 . . .

2) make sure you reference the local server in the SJA.XML file as:

CODE

127.0.0.1

or

localhost.localdomain

This will then allow the sync to occur.

your own discovery? Quite valuable actually if it is true and complete!

[peterlaursen]

Are MySQL versions identical?

http://webyog.com/faq/11_68_en.html.

Is the SJA recent? It should display an error essage.

Unless there is a simple 'NULL definition mismatch'.

Read in detail about data sync:

http://webyog.com/articles/Using_SQLyog_En…L_Databases.pdf

[peterlaursen]

QUOTE

and even the output misleads you to think that a sync occurred

Wrong! All data were sync'ed. SJA did not even have to create tables to do it! 😀

[peterlaursen]

hmmm ..

1) localhost.localdomain. Now again!

actually we wrote about it here:

http://webyog.com/faq/23_36_en.html

But you are welcome to propose an improvement of this FAQ. Actually I am not satisfied with it!

2) SJA data sync is a tool for DATA SYNC, not STRUCTURE SYNC. However I think this could be fixed, as long it is only dublicating a structure to an empty DB! Let Ritesh comment on it. Can you put a single row on 'dummy' row of data in each table on the source? Fixing this will not be high priority right now. We are busy with this:

http://webyog.com/faq/33_20_en.html . And a little bit late actually!

SQLyog Enterprise runs on Wine. http://webyog.com/faq/31_71_en.html . It has a true STRUCTURE SYNC tool, that will be TOTALLY COMPLETE with ver. 5.1 /BETA1 probably next week).

[Author]

Posts