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

Forum Replies Created

Viewing 15 posts - 2,491 through 2,505 (of 7,398 total)
  • Author
    Posts
  • in reply to: #27734
    peterlaursen
    Participant

    yes .. we have tried with logs larger than this! But only tomorrow when office opens I can be more exact!

    edit: please paste the result on “uname -a” command. I am not sure we know details about this 'lenny' distro (we mostly use various Ubuntus +Fedoras +OpenSuSE11 for testing on Linux.

    It may be a PECL (regular expressions library), SQLite or C++ library issue with that distro

    in reply to: #27741
    peterlaursen
    Participant

    Issue confirmed!

    The problem is that SHOW FULL FIELDS does not contain information about the 'on update' clause. I am not sure, but I think it was always the situation with SQLyog Structure/Schema Synchronisation!

    I posted this bug report to MySQL http://bugs.mysql.com/bug.php?id=40378

    .. but frankly I do not expect they accept it as a *bug*. They will probably accept it as a *feature request* only! So for TIMESTAMPS we will probably need to parse the SHOW CREATE TABLE for occurrances of 'on update' (and for compability with current server versions that will also be required anyway). I cannnot think of any other way and unfortunately parsing a string (and a SHOW CREATE TABLE can be *very long*!) is inefficient as compared to using the grid-like return from SHOW FULL FIELDS.

    in reply to: #27732
    peterlaursen
    Participant

    Are you retrieving logs over SFTP?

    It really looks like when getting close to 100 MB swapping occurs with MONyog data. Can you verify that somehow?

    in reply to: #27730
    peterlaursen
    Participant

    hmmm .. that looks like an old issue that was fixed before was re-introduced! We will check with priority tomorrow!

    in reply to: #27728
    peterlaursen
    Participant

    Releases notes for 2.71: http://www.webyog.com/blog/2008/09/11/mony…-been-released/

    “Bug fix:

    * Fixed some issues with JSON strings that could prevent objects in the MONyog browser interface to populate with data. Most important ‘Monitors/Advisors’ page would fail to display if a username contained a doublequote character.”

    So please first try upgrade to 2.82. Registered users upgrade from here: http://www.webyog.com/CustomerArea . Trial users from the 'downloads' link on http://www.webyog.com

    If problems persists

    1) tell the exact FireFox version

    2) try another browser (IE, Opera, Google Chrome)

    in reply to: #27726
    peterlaursen
    Participant

    What is the program version you are using?

    in reply to: #27722
    peterlaursen
    Participant

    'print canvas' is an option in the Schema Desinger context (right-click) menu. Also a print preview (using system default printer settings) option is there. Useful so that you can arrange objects so that they will not be split between pages.

    Just right-click in the Schema Designer canvas. If you do not find the option, you are probably using one of the first versions released with Schema Designer.

    However currently there is no ZOOM option for print. But you can print to a 'virtual printer' (like a PDF printer program) having such option. Also quite a lot of printer drivers have a built in such zoom option.

    in reply to: #27717
    peterlaursen
    Participant

    Do you know any other database client for a SQL server (references to Access etc. makes no sense!) capable of doing this?

    in reply to: #27713
    peterlaursen
    Participant

    Unfortunately it is holiday in India tomorrow. But I hope we can push the fix for this into 7.12 tree on Wednesday. How urgent is this for you?

    in reply to: #26468
    peterlaursen
    Participant

    “but I thought you could edit the logging settings of the mysql server from MONyog's Log Analyzer Settings page.” oops .. yes, correct with recent MySQL servers (I think from 5.1.something)

    in reply to: #26466
    peterlaursen
    Participant

    @Ken

    I think you are referring to a *mysql user* – such one you define server-side as you like. What the other guys here have requested is a 'two level authentication model' for MONyog – not for MySQL (because this is implemented in the MySQL server). And btw: currently MONyog does not change anything at all on MySQL (does not even SET a simple server veriable)

    Did I understand correctly?

    in reply to: #27711
    peterlaursen
    Participant

    ok .. if you use ” , ” as the field seperator then we should not escape ” , ” inside a “quoted string”!

    This looks like our bug! This table

    Code:
    DROP TABLE IF EXISTS `tab1`;

    CREATE TABLE `tab1` (
    `id` int(20) default NULL,
    `a` varchar(20) character set utf8 default NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    insert into `tab1`(`id`,`a`) values (2,'test,test');

    looks like this in MySQL SELECT INTO OUTFILE:

    Code:
    2,”test,test”

    But in SQLyog

    Code:
    2,”test”,test”
    in reply to: #27709
    peterlaursen
    Participant

    There is a problems with the third row (with the multiline string). There should not be a ” (doublequote) after 'd'. Import fails because of this!

    [attachment=1035:warning.jpg]

    MySQL SELECT INTO OUFILE statement has the same issue. I think we may use an API function calling server functionalities (but I will have to check with developers). I reported this: http://bugs.mysql.com/bug.php?id=40320

    in reply to: #27708
    peterlaursen
    Participant

    [attachment=1032:data.jpg] [attachment=1033:settings.jpg] [attachment=1033:settings.jpg]

    Let me explain the above example!

    1st image: you have data like (2,'a'),(4,'b”c'),(6,'de'). In SQLyog (in text mode) they display like 1st image.

    2nd image: the setting for CSV export like this …

    3rd image: .. will generate this CSV-file (as displayed in Notepad).

    More explanation about 3rd image:

    1st row of data: '2' is not “quoted”, 'a' is. The setting *optionally enclosed* in 2nd image means that strings and only strings are enclosed (as explained in MySQL documentation).

    2nd row of data: '4' is not quoted. 'b”c' is BOTH enclosed AND escaped by ” – character (doublequote) so it becomes '”n””c”'. The first and last occurence of ” is because of *enclosed by* – the 2nd occurrance of ” (before third “) is because of *escaped by*.

    3rd row of data: '6' is not quoted. 'de' becomes '”d”e”'. The first and last occurence of ” is because of *enclosed by* – the occurrance before is because of *escaped by*.

    ('rn' (or in ASCII notation: ) is the 'newline' character sequence om Windows – on Linux it is 'n' only. So if intention is that the file should be read by a Windows spreadsheet prgram you should use 'rn' for 'lines terminated by' setting)

    With a fresh SQLyog install the settings is like what is most common with *import to MySQL* using LOAD DATA INFILE statement. But you can change as you want and it will be saved and next time you open the export dialogue if will show what you selected last time.

    I think I understand that it is not as simple and automatic as you expected, but it cannot be simpler if all variations of CSV file format And MySQL “LOAD DATA ..” statement shall be supported.

    in reply to: #27707
    peterlaursen
    Participant

    Please tell: what standard are you referring to?

    The use of 'escaped by' in SQLyog is in accordance with MySQL “load data infile” syntax.

    If you have the string

    Code:
    th”is

    and you with SQLyog want to make CSV look like

    Code:
    “th””is”

    (enclosed and escaped by “)

    .. then you use the ” (double quote) – character for BOTH '(optionally) enclosed by' and 'escaped by' in the CSV export dialogue.

    You noticed the 'change' button? You can define everything exactly as you like here.

    Would you mind provide a screenshot of yor export settings? and an example? (a SQL dump of a small table and what you want it to become after CSV export)?

    Also please read: http://dev.mysql.com/doc/refman/5.0/en/load-data.html

Viewing 15 posts - 2,491 through 2,505 (of 7,398 total)