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

Forum Replies Created

Viewing 15 posts - 346 through 360 (of 642 total)
1 2 3 … 23 24 25 … 41 42 43
  • Author
    Posts
  • March 17, 2004 at 2:56 pm in reply to: Suitable for 2-Way Synch? #15576
    Shadow
    Member

    Well, you may set up to jobs to do the two way sync. I know that this is only a workaround, but it works…

    March 17, 2004 at 2:54 pm in reply to: new feature request #15572
    Shadow
    Member

    If the query is not very complicated, then you could execute it as 'Select for update' and selct the contents of the given field and copy it…

    March 13, 2004 at 10:48 am in reply to: Relationships #14509
    Shadow
    Member

    We'll need the tables' structure to answer your question!

    March 13, 2004 at 10:43 am in reply to: basic question #15544
    Shadow
    Member

    [email protected] perhaps… What is a “Host Access” anyway? And what do you mean by “calling it”?

    March 13, 2004 at 10:39 am in reply to: Database relationship #15564
    Shadow
    Member

    Just one little addition to Ritesh's post: check MySql's manual on InnoDB rather that InnoDB's own website!

    March 10, 2004 at 3:09 pm in reply to: Multiple SJA Questions #15515
    Shadow
    Member

    You can set up two jobs to tackle mutual synchronization. SJA does not perform any checks on the PKs.

    March 10, 2004 at 3:05 pm in reply to: my.cnf is where? #15529
    Shadow
    Member

    If you have my.ini then you have no nedd for my.cnf, the two are the same… If your my.ini does not have a max_allowed_packet definition, then MySql uses the default value. You have to add the parameter either manually or by using MySql Administrator.

    March 10, 2004 at 3:01 pm in reply to: basic question #15540
    Shadow
    Member

    As far as I'm concerned, SQLyog cannot be used behind firewalls. At least Ritesh keeps telling that…

    March 10, 2004 at 2:52 pm in reply to: refresh object browser #15552
    Shadow
    Member

    The support for the extended user rights introduced in 4.0, 4.1 and 5.0 is planned for SQLyog Max.

    March 10, 2004 at 2:48 pm in reply to: Bad Handshake – Error 1043 #15559
    Shadow
    Member

    There is a special edition of SQLyog if you use 4.1.1!

    February 25, 2004 at 9:49 pm in reply to: SSH and scheduling of backups/sync #15522
    Shadow
    Member

    Unfortunately MySql does not offer any built-in solution for backup apart from these scripts and dumps. Of course, you may copy the files that contain the tables. However, the scripts do their job quite efficiently and Win's scheduler can be used to fire them at a particular time. I wish MySql developed a new backup feature anyway.

    February 25, 2004 at 1:54 pm in reply to: SSH and scheduling of backups/sync #15520
    Shadow
    Member

    Syncing to dbs are a form of backup. There are other methods as well (mysqldump, mysqlhotcopy), which can be automated from the os. See MySql manual's corresponding part for details.

    February 25, 2004 at 11:28 am in reply to: Where is the SJA error log file? #15516
    Shadow
    Member

    Should be located in the same folder where sja.exe is stored.

    February 25, 2004 at 11:25 am in reply to: SSH and scheduling of backups/sync #15518
    Shadow
    Member

    Or using Win's built-in scheduler…

    February 25, 2004 at 11:23 am in reply to: Query Analyzer / Tune up Selects #15505
    Shadow
    Member

    The speed gain must not be attributed to the indices, it is the result of the query cache. I noticed that sometimes MySql does disregard indices created for speeding up queries. Try using FORCE INDEX to make MySql take advantage of your work!

  • Author
    Posts
Viewing 15 posts - 346 through 360 (of 642 total)
1 2 3 … 23 24 25 … 41 42 43