Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantQuote:i have already looking for sugestions but without any resultDid you look in the FAQ ?
peterlaursen
ParticipantYou 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 .. sameOn 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
ParticipantIssue 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 2006Table           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 notis 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 issueaahhh .. MAJOR ??? excuse me major ??? 😀
It is just a silly bug!
EDIT: I replaced the image – first one was wrong.
peterlaursen
ParticipantYou did not experience that with 5.01 either? That is pretty strange then!
But you have a PM!
peterlaursen
ParticipantNot 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
ParticipantAdded your solution (and a previous one too) to the FAQ:
peterlaursen
ParticipantAfter 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
ParticipantI 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
ParticipantFirst .. 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
ParticipantWell thanks then.
I think I will be able to improve the FAQ.
peterlaursen
Participantwell .. 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
ParticipantBTW: is this
QUOTE1) 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
ParticipantAre 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:
peterlaursen
ParticipantQUOTEand even the output misleads you to think that a sync occurredWrong! All data were sync'ed. SJA did not even have to create tables to do it! 😀
peterlaursen
Participanthmmm ..
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).
-
AuthorPosts