Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 5,881 through 5,895 (of 7,398 total)
  • Author
    Posts
  • in reply to: Syncjob #20592
    peterlaursen
    Participant
    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

    in reply to: Syncjob #20591
    peterlaursen
    Participant

    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)

    in reply to: Syncronization Case Sensitivity #20578
    peterlaursen
    Participant

    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.

    in reply to: Sqlyog Enterprise 5.0.2 Crashout #20574
    peterlaursen
    Participant

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

    But you have a PM!

    in reply to: Sqlyog Enterprise 5.0.2 Crashout #20572
    peterlaursen
    Participant

    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?

    in reply to: Could Not Connect To Source Mysql Server #19800
    peterlaursen
    Participant

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

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

    in reply to: Automate The Import Of .txt Files #20571
    peterlaursen
    Participant

    @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!

    in reply to: Automate The Import Of .txt Files #20570
    peterlaursen
    Participant

    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 ?!

    in reply to: Automate The Import Of .txt Files #20569
    peterlaursen
    Participant

    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

    in reply to: Could Not Connect To Source Mysql Server #19799
    peterlaursen
    Participant

    Well thanks then.

    I think I will be able to improve the FAQ.

    in reply to: Automate The Import Of .txt Files #20568
    peterlaursen
    Participant

    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 .. 🙂

    in reply to: Could Not Connect To Source Mysql Server #19796
    peterlaursen
    Participant

    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!

    in reply to: Could Not Connect To Source Mysql Server #19795
    peterlaursen
    Participant

    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

    in reply to: Could Not Connect To Source Mysql Server #19794
    peterlaursen
    Participant

    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! 😀

    in reply to: Could Not Connect To Source Mysql Server #19792
    peterlaursen
    Participant

    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).

Viewing 15 posts - 5,881 through 5,895 (of 7,398 total)