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

Forum Replies Created

Viewing 15 posts - 136 through 150 (of 642 total)
  • Author
    Posts
  • in reply to: How do I show warnings? #16458
    Shadow
    Member

    Use SHOW WARNINGS command to get more info. In this case, however, I belive MySql only returns the number of warnings, but no additional data is recorded.

    in reply to: Email date not set by notification service #16415
    Shadow
    Member

    Didn't have time to test it. Perhaps this weekend! 🙁

    in reply to: export resultset makes yog crash #16429
    Shadow
    Member

    Beta 5 does not crash on W2K with IE6 SP1.

    in reply to: Email date not set by notification service #16413
    Shadow
    Member

    It's an XML data file and not a schema file. Starts like

    in reply to: Export Data #16427
    Shadow
    Member

    @peterlaursen: Yes, that was a question for you! Of course, a db structure may not be completely altered by an automatic tool, but in simpler cases it might come handy. I know the limits of ALTER TABLE statements, especially in older versions of MySql, that is why I asked what you had in your mind. Though you had an alternative approach…

    in reply to: Export Data #16425
    Shadow
    Member

    You mean, a tool that creates alter table statements instead of completely dropping and then recreating a table?

    in reply to: Export Data #16423
    Shadow
    Member

    If I understood your problem properly, then the answer is – unfortunately – no, data sync wizard is not suitable for your needs.

    First of all, data sync wizard works only if the synced tables' structures are identical. SQLyog has a structure sync wizard, but that cannot be scheduled and needs manual intervention anyhow. Secondly, data sync wizard cannot sync data using complex queries including joins. All you can do is to specify a WHERE clause. Data sync wizard, however, will be further developed. You could participate in testing SQLyog MAX and try to convince Ritesh to incorporate the features you require.

    in reply to: Need to update user management in 4.1 #16422
    Shadow
    Member

    That's a good idea! 😀

    in reply to: daya synchronization deletes information #16416
    Shadow
    Member

    If there are such rows in the target db that are not present in the source db and you chose to perform a one-way sync, then sja deletes these extra rows.

    in reply to: Problem with "Copy Table Structure / Data" #16378
    Shadow
    Member

    Works correctly with MySql 4.1.3 on W2K.

    in reply to: Problem with "Copy Table Structure / Data" #16377
    Shadow
    Member

    Considering MySql's silent column changes, a CHAR(100) column is highly interesting!

    in reply to: Error 1062 #16401
    Shadow
    Member

    This might explain terrym's problem as well.

    in reply to: Cannot connect to ISP mysql #16394
    Shadow
    Member

    I figured that out by starting SQLyog…

    in reply to: Cannot connect to ISP mysql #16392
    Shadow
    Member

    Sorry once again, SJA bundled with 4.0 beta may use HTTP tunneling.

    So, if your ISP does not allow direct connection from remote hosts, then you have to copy SQLyogTunnel.php to ISP's server and use tunneling features in the connection.

    in reply to: Error 1062 #16396
    Shadow
    Member

    Are you sure that your PK field is of integer type? Isn't it accidentally a signed tinyint? The error message may be caused by overflow…

Viewing 15 posts - 136 through 150 (of 642 total)