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

Forum Replies Created

Viewing 15 posts - 3,106 through 3,120 (of 7,398 total)
  • Author
    Posts
  • in reply to: #26146
    peterlaursen
    Participant

    no .. you should not have that problem!

    … unless there was a 'regression' in 5.0.45 that was fixed again in 5.0.51.

    If you attach a small (zipped) sample of such CSV, I/we could try.

    in reply to: #26021
    peterlaursen
    Participant

    Ok .. I do not remember dyndns in detail anymore. 3 years ago I used it. maybe it is more relevant if you run a server ofn a PC with a dynamical IP.

    Did you ask the support of your ISP? Or serach their Fourms (if they have).

    This is specific for that ISP and the answer is specific for that ISP.

    in reply to: #26019
    peterlaursen
    Participant

    you can work around not having a static ip by using a 'dynamic dns service' like http://www.dyndns.dk (there probably is one in your language as well)

    in reply to: #26152
    peterlaursen
    Participant

    Not reproducable for me on Vista SP1 RC, Nvidia graphics, resolution 1440*900.

    Do you have the Vista 'sidebar' turned ON?

    (this position is default for sidebar).

    Vista SP1 final/public is expected in days/weeks. I think that might solve?!

    in reply to: #26150
    peterlaursen
    Participant

    You can also create a 'merge' table (a collecition of identical MyIsam tables). But currently we do not support MERGE in SQLyog GUI. Unless you need to use full-text indexes (or spatial datatypes) using InnoDB is the simplest solution.

    in reply to: #26148
    peterlaursen
    Participant

    Please post only once per problem.

    It is much easier for everyone if the complete discussion it in one place!

    I replied in the other post.

    in reply to: #26149
    peterlaursen
    Participant

    Please try to use InnoDb tables and not MyIsam tables.

    This is likely a restriction with MyISAM

    (and it is definitely a server issue, not a SQLyog issue!)

    in reply to: #26144
    peterlaursen
    Participant

    http://bugs.mysql.com/bug.php?id=11203

    Quote:
    Fixed in 4.1.16 and 5.0.16.

    You should *really* upgrade that server – in particular if it is a 5.0 before 5.0.15. You will continue to run into all sorts of problems if you don't!

    btw: Somewhat related bugs here:

    http://bugs.mysql.com/bug.php?id=1704

    http://bugs.mysql.com/bug.php?id=31663

    http://bugs.mysql.com/bug.php?id=29442

    in reply to: #26143
    peterlaursen
    Participant

    I think this is fixed already with a server version later than yours! With 5.0.51a I get

    Code:
    CREATE TABLE `loadtest` (
    `id` bigint(20) unsigned NOT NULL auto_increment,
    `txt` varchar(50) default NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8

    insert into loadtest (txt) values ('linernbreaks');
    select * from loadtest; — show results in text

    /* returns

    id txt
    —— ————
    2 line
    breaks */

    /* now export as CSV with SQLyog with 'excel-friendly' values
    file reads like

    id,txt
    “1”,”line
    breaks”

    */

    delete from loadtest;

    — next import CSV with SQLyog

    select * from loadtest; — show results in text

    /* returns

    id txt
    —— ————
    2 line
    breaks */

    No problem here with this server version!

    in reply to: #26132
    peterlaursen
    Participant

    what do you refer to as 'compole'??

    CREATE SP/SF or CALL SP/SF ?? i would think CALL ?

    I do not have a particular good idea for Stored Functions right now!

    in reply to: #26141
    peterlaursen
    Participant

    Try copying the LOAD DATA statement from HISTORY and execute through command line!

    in reply to: #26140
    peterlaursen
    Participant

    If it is a bug, it is a bug with the MySQL server/parser I think.

    But I agree that inside a “quoted string” 'newlines' should not be parsed.

    What is the server version you are using?

    Please read this

    http://webyog.com/faq/content/28/73/en/i-h…l?highlight=csv

    Note that SQLyog simply executes

    LOAD LOCAL DATA INFILE {with parameters as you specified in the import dialogue).

    So I am 99% sure that is is the server that breaks here!

    But maybe it is documented like that somewhere.

    (It is very difficult to convince anybody at MySQL AB that a documented behaviour may still be a bug!)

    I can check later tonight. If I can confirm this and reproduce from command line client as well I will report to http://bugs.mysql.com

    .. unles you prefer to do yourself (but report as an issue with LOAD DATA statement and not as an issue with SQLyog!). They will probably tell you in the first to use another 'terminated by' sequence than 'rn' .. but I think Excel won't let you configure that! So they will have to admit I think that the parser is too simple here! Unless it has been fixed in a later server version than yours already.

    Could you zip and attach a small sample file to reproduce with?

    in reply to: #26134
    peterlaursen
    Participant

    this question was asked many times before!

    Please read:

    http://webyog.com/faq/content/28/70/en/i-o…tabase-why.html (it applies to DELETES as well of course)

    So yes .. good idea to have a PK!

    But we have plans (not priority) to popup a dialogue where user can specify a LIMIT.

    A 'smart' way to solve this is to use the Migration tool:

    http://webyog.com/faq/content/17/151/en/ho…-databases.html

    And also Data Sync will only create one row onfor duplicate rows in target if there is no PK.

    in reply to: #26136
    peterlaursen
    Participant

    After installation you will find it in SQLyog installation folder (SQLyogTunnel.php).

    Please read the 'getting started' paragraph of the help!

    in reply to: #26130
    peterlaursen
    Participant

    Execute “SHOW WARNINGS” (will display warnings for last operation that affected a table – for more exact details refer to MySQL docs). For debugging insert “show warnings” statements in the SP code itself at appropriate places.

    Better ideas out there?

Viewing 15 posts - 3,106 through 3,120 (of 7,398 total)