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

Forum Replies Created

Viewing 15 posts - 3,256 through 3,270 (of 7,398 total)
  • Author
    Posts
  • in reply to: #25904
    peterlaursen
    Participant

    The DATA SYNC feature will not do this. The purpose of this feature is to bring databases/tables 'in sync' (make them identical). For the same reason STRUCTURE of tables involved must be 100% identical (including column names and columns order). In particular note: the option with this tool does not specify which columns to be sync'ed but only which columns are checked for differences. Complete row will always be synced.

    However you could have a look at the MIGRATION tool. With this one you can specify individual columns onand map to any column on . Be careful to understand all the 'advanced' options! Using those options the MIGRATION TOLL will let you sync fromto with INSERTS AND UPDATES. If you have the option to modify theschema use the TRIGGER (refer to FAQ) functionality for efficiency. But the MIGRATION tool will not DELETE rows on – not if they are deleted oneither. That will have to be done manually

    But please also note that if the two helpdesk systems use references to other tables in different ways or the applications use some kind of 'trigger code' (for instance for counters like 'no. of times opened') you may mess it completely up. We cannot tell this. Be careful to understand how they both work and ensure good backups!

    in reply to: #25901
    peterlaursen
    Participant

    There is (to my best knowledge) no approved or 'de-facto' standard for how to define/represent a database schema in XML.

    Do you have knowledge or ideas of any such standard or convention? Or just good ideas of your own?

    Also the (Enterprise) Schema Desingner stores XML already. This .schemaxml contains both information about canvas settings and table definitions. Did you check if the 2nd part of that fullfills your needs?

    in reply to: #25868
    peterlaursen
    Participant

    Sorry we did not realize this!

    We will provide an updated SJA for Linux ASAP (tomorrow probably – today is not possible now)!

    in reply to: #25900
    peterlaursen
    Participant

    Yes you can!

    Use the Migration Tool (and not the Data Sync tool) when schemas are different and you only want to transfer a subset of the available columns.

    The TRIAL is fully functional in this respect with the single limitation that only 2 tables can be handled per job.

    Link to MyODBC drivers:

    http://dev.mysql.com/downloads/connector/odbc/3.51.html

    http://dev.mysql.com/downloads/connector/odbc/5.1.html

    in reply to: #25894
    peterlaursen
    Participant

    btw: if you do not click the 'reply' button but the 'add reply' button a little longer down the page the will be a facility to upload files. Images will be displayed as a thumbnail.

    in reply to: #25893
    peterlaursen
    Participant

    I tried this (using a log file name that was never used before) with 6.16 RC and a simple sync job. The file 'saj2.log' is created and contains:

    Quote:
    Sync started at Thu Feb 07 13:42:53 2008

    `aa` 7 0 7 0 0

    Could you try this version?

    Also please tell:

    Are you changing the file name only or also the folder?

    What is the windows version?

    in reply to: #25898
    peterlaursen
    Participant

    .. and spreadsheets program like MS Excel, Open Office Calc etc. :huh:

    We have already this registered:

    http://code.google.com/p/sqlyog/issues/detail?id=29

    We will decide on priorities for 'next shot' after releasing version 6.2 (that enhances the Schema Designer, improves speed, adds support for transactions, makes export/copy operations more flexible + LOTS of minor fixes and request implemented).

    in reply to: #25835
    peterlaursen
    Participant

    “scrolling right to left works fine. Scrolling the other way does not work on large tables”

    We know this. We are currently discussing if it is possible to 'promote' this as well as other GRID realated issues into the 6.2 tree. I think we can have the conclusion i about 1 week.

    in reply to: #25896
    peterlaursen
    Participant

    It is designed like that!

    Please refer to:

    http://webyog.com/faq/content/8/99/en/does…l-keywords.html

    You can turn off the feature in 'preferences' .. smart keywords handling, or enclose in `backticks` (like `default`).

    in reply to: #25865
    peterlaursen
    Participant

    I create a 10K copy from the 20K file like

    create table newone as select * from dspam_token_data order by token limit 10000;

    .. next copy to anotehr database and rename. Run sync

    and get

    Copyright©Webyog Softworks Pvt. Ltd.. All Rights Reserved.

    Sync started at Wed Feb 06 17:37:19 2008

    Table SrcRows TgtRows Inserted Updated Deleted

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

    `dspam_token_data` 20000 10000 3504 0 3

    Total time taken – 139 sec(s)

    Added: After this “select count(*) from dspam_token_data” returns '13501'

    SQLyog 6.16RC – MySQL 5.051a (two databases on the same server on my local).

    A can add that I tried copying the 3 first rows toand the first row alone to . They synced correctly (I noticed that `token`had the same value for the three rows.)

    We will debug this 2row morning systematically.

    in reply to: #25864
    peterlaursen
    Participant

    thanks .. that unpacked and imported!

    probably an issue with the .gz format in the Forums software. It *should* refuse to accept unsupported formats!

    in reply to: #25861
    peterlaursen
    Participant

    What format are those files?

    unpacking with 'winrar' and 'filzip' only gives garbage like

    Code:
    ‹š¢©G table10k.sql œýÛÒn¹qˆÞë)Ö]K%5Î;úBÝf·-Ën‰vD_‰”Åmq[¢bi;üö{¾˜H̉)‹UküX9qHd&2Gþñÿø§¿û§ÿð?ÿôoÿá·¿ûñWÿÏŸÿøwÿòÿôüÇ?þ¿ùçßÿö÷ÃüIþý'úÿÝoþæ·¿þÝ›ù›ùÝÏÿ‚_!èï~þùŸþÍÿú¿þÿñ?þÃüÃÿü5‡ù“ßýægþ&ÿþ÷ÿøûŸÿ͏¿ÿÇÿúë¿ÿ;ü+éÿúÍï~óÏ¿þ™cÿò·ÿð›óãÿüÍßüPá§F©ôã×?ÿÐæßøôã?ý‚ÿê7ÿAº0ÿæ‡ÿõ'6ñwþÓ¿ÿO?þË÷—Mˆÿ»_ÿüë¿ùõï1ò¯~ÿÿýõÏ¿ù‡úUù-þÏÿ+ÿó}ð_þúoþþ7?~ÿó?ÿËýù_þù7?þ?ÿøÏ?~.¿ö«¿ýý?ýúþúçüï¿ùÝ_ÿ-dhêÿñ—¿øÓ_þâÇ/ÿôÿó_ ø?~üê_~û·¿úñûøõßÿýo÷óú?úñ/¿ûýoÿÛï~ó·?þâ?þòÇ_üç?ÿóŸ+?÷«óÛÿF˜Q;ùCþî·?ÿþW?Ôúæßÿíï~÷ÿõ7¿ûùó÷¿þ}ùý_ý€œ¿™~ï?ýåŸý‡?ýËÿ÷Çÿý‹ÿ÷Ǐ?,ÂÿÔdû£?ø£¿ø‹ÿëÏþâÿÛøŸöWú~ü»_üŸúŸÿü—?þÿ§ùW¿øåÿö÷Xûßéû™Qn¸ßþî¿ñOùõÁtþÙ_üÕ/þò—?þì/~ùÅÙ¬Òô©úiœ‹Ÿ®þÓð•ôã¿üéŸÿç_üՏ?øCÒO?´ŠÚېrјŸ~(üÒO?þnÒ?VúMþ_þè'@³;…ÚhŽ¡Êâ8x›£N!;e”¿@Í+_ˆ„†¨3IYg]^¡n€æ“‹!zgŒ^°_¨Õ:im£ÍY¥« €º šµÍ·ìu¼‡š”³N
    ŸåÓVÖ2Öd•mÒ.ÅÜFµã¨~ušŠ™üé¦Uù€?@;›CùÓ•0£ç
    &,Øä¼UÔê
    åg³w.zc#˜ ø,ýÝÉX›‚s˜ÔàÒ*€ùBñ-Ñ9RHÙ§u^;`&éŒ50*Q›^çµ  Ï¡Ér¿b¦°µ”6W²ûÙ¢p:(]°Ö:ßM—ÄFìÁŒÍ¢fÌíW¿ŽAà1„à£ö¬Î×¶°Ì£€màsôÉíýVgð[’(l‚¼ÉÙ¬ØÐ6XÁƨp­OVga/ô}ËMjRÐ1±{³^Ǎßo{ÄÖosü-,—Ó1+
    -c¹•¯óàÛ<8k¤u3ã6µè=±ÜâJyüÉØi°²{±&„óqµ~1®z1îy½y!Cz1geh𥗽Õ^PÐM;äLµ¯¡õÐRF{Ý
    {zC*t®g~Ю`C†4ÙD½Ž›¾×¤ÕP*¸4åû½¦¨”-ð)(¯¼Þ_”E¡[PçW@Œ:ïdpºa1kgß@ïÎ|™_k¯¨¢&l¾Í|רºè¬:%•¶;ê¸Oئ£(žõYã³”Ò¸àýöfµÎc
    uß)6°Ââ£ô~-å…y#Àà–çr,X«š¼ø-Ëõ
    0X²
    ZÒÕ~ÄZc•Á £°×ÃwŸAaãì8íµÏånL7|»Ú¨v«Ñ¯xÚw¼Ëп
    ¶“_ÇíXÞ….B­áë<¾ó±=C4s0ª†¸æUŽq?.Ï&¾zMCÇkÛ;6EbcÆß{Í«x5µ>sVöä#6u”K8ú)ã†Å1J×ý€o×âkiBáæÆ<`ð“É ç"Œ2ànÅ
    o
    X7Ž›bÀVWΆ”yý‹¥Åd¹Ç”é~Ëã¸GØbÖ{¨E{=ÒVNâ9vt¥¬V”¸NðéÀêki/œbËD`¹èŽùH—p;Áë o,U”¥Üaë”ÃÃÕ™&Gˆef6{ûûõS×ãR„im¡³ ¤ºQËù
    * Žû¾d,Ú=v6ü C€
    ½.ÎÁ¨=ÆpiRGbžµQ;c®ð+`tyÌ—…wvw0b⬑±F:De\Ý0¡ Ø•ña½8Õ0g‡Ø*ÊìkŸÖúD£÷÷ ÛCüb€
    _
    Þ^DÅy‚&Ñð#T”­†µ‘7p†ÀØeÊ@Uæ˜aB¤ïÇE­àš*Ø×ð½­àû·÷#6Ü=ök…w€õ_O ÂC†k£éiTî9œ‡ØrsR+ð~ƒºZGßù-óàéÜÐJ¦¸›£ŒS’á*ƒQ³Ý́€È?ós6Äg³{bS +’pŒd”1E'NÁôÔî~/X'KXl`†x QâÕ
    ÿ®›*ØlqB{¯—ØÝ<„ã¯`m`݂ǷÖ2AØ {%T+uÝœ´wrÁf.f´Òœ¥¯U›”ÂX((k#åÔw~“2FS¡1j¢öaAÞ}VºJïiÜ<Êëi̸”¯ØÙëM˜e‡+£)ºÒ÷Y×yçì"Ü^òÒ‡½“èßÀˁkf³äíµ‹ž÷/·'Üc½ÞFÛŠ.aÄ5c3*º#n{q–ó,TˆI.lÍzÁùup¿ËIðEŒŽ¼×“EK␰yòbÄç8‹‹ÚUCY'É+³_C
    ;2fãxèp¢×ÈççÒb@5CS:(ª”h«n硱ʇsP{ iÁ2

    etc.

    How do we import those? zipped SQL-DUMPS are preferred!

    in reply to: #25859
    peterlaursen
    Participant

    thanks …

    So basically we should be able to reproduce by using the attached 20K table asand the 10K table as .

    in reply to: #25830
    peterlaursen
    Participant

    Your request was added here:

    http://code.google.com/p/sqlyog/issues/detail?id=540

    At the moment I cannot guarantee when we will consider this in details.

    in reply to: #25857
    peterlaursen
    Participant

    OK

    I agree that with a 'static' `dspam_token_data` table 4971754 – 4783407 +1637 -715 should be ZERO .. and it is not!

    This might be a data-specific issue.

    I am afraid we will need some data to reproduce with! Could you try create a small subset of one table like

    CREATE TABLE `newone`SELECT * from `dspam_token_data` LIMIT 20000; (or whatever limit).

    Once you have a small subset where it is reproducable please zip and attach (or create a ticket if you want privacy)

Viewing 15 posts - 3,256 through 3,270 (of 7,398 total)