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

Forum Replies Created

Viewing 15 posts - 301 through 315 (of 642 total)
1 2 3 … 20 21 22 … 41 42 43
  • Author
    Posts
  • April 30, 2004 at 12:39 pm in reply to: Import HUGE table (~1G) via query #15719
    Shadow
    Member

    Then this problem is beyond our capabilities…

    April 30, 2004 at 12:37 pm in reply to: How do I view warnings on a data import? #15645
    Shadow
    Member

    From MySQL 4.1.1 on use SHOW WARNINGS statement to retrieve the errors (see MySql manual for details abot SHOW WARNINGS). Before this version, the warning counter is used for indicating that something was not OK, but the warnings are not stored. Hint: warnings happen under same circumstances as if INSERT statement had been issued.

    April 30, 2004 at 12:30 pm in reply to: Duplicated Lines ? #15729
    Shadow
    Member

    Unfortunately, you are not the only person who reports such problem (duplicate lines in imported data). You should contact Ritesh so that he can debug SQLyog if you provide some sample data.

    April 27, 2004 at 9:01 pm in reply to: Duplicated Lines ? #15727
    Shadow
    Member

    Do you use SQLyog to migrate data to MySql? If yes, does it report any errors after importing? Have you tried creating those indices in SQLyog?

    April 27, 2004 at 8:56 pm in reply to: Error Deleting #15713
    Shadow
    Member

    If you have access to the machine running MySql service, then you should check out MySql's data directory and see if the corresponding *.MYD file is there – or even the folder is there. I would remove the whole db manually, in case it's possible. Otherwise you should contact the operators of the server.

    April 25, 2004 at 5:30 pm in reply to: Error 1065 #15723
    Shadow
    Member

    Or accidentally put two “;” at the end of a query…

    April 25, 2004 at 5:28 pm in reply to: Import HUGE table (~1G) via query #15717
    Shadow
    Member

    Can you export the data as csv file from your db?

    April 25, 2004 at 5:25 pm in reply to: Error Deleting #15711
    Shadow
    Member

    Do you have all the necessary character sets installed?

    April 16, 2004 at 11:44 pm in reply to: Multiple Tables From Query Method #15692
    Shadow
    Member

    Neo: scheduling ODBC import is planned for SQLyog MAX.

    April 16, 2004 at 11:41 pm in reply to: Problem with Job Manager – windows 98 #15666
    Shadow
    Member

    Why do you create the xml file manually? You said that you were unable to schedule the job. Use SQLyog to create the xml file, then schedule it manually.

    April 16, 2004 at 6:28 am in reply to: No PRIMARY KEY defined #15670
    Shadow
    Member

    Even SQLyog's GUI cannot really handle tables without PKs… You should request it as a new feature!

    April 16, 2004 at 6:22 am in reply to: When do u need 2 refresh? #15679
    Shadow
    Member

    You should issue a refresh command to SQLyog after you alter the structure immediatelly in order to see the changes in the object browser. It a feature of SQLyog. Automatic refresh of the object browser has already been requested.

    April 16, 2004 at 6:17 am in reply to: Nuke Website Setup #15677
    Shadow
    Member

    If the table names are different, then it is not an issue, although generally it's not a good idea to mix two apps' dbs.

    Tools -> Execute Batch File

    April 16, 2004 at 6:13 am in reply to: No PRIMARY KEY defined #15668
    Shadow
    Member

    The problem is that sja uses primary keys to determine which rows must be updated, so currently a table must have a primary key in order to be synced by SQLyog. If you need to mirror a db, then you might consider using MySql's built-in replication feature.

    April 16, 2004 at 6:09 am in reply to: Problem with Job Manager – windows 98 #15664
    Shadow
    Member

    Actually, SQLyog does use the built-in scheduler… Most likely the Schedule API in XP and 2000 differs from that of W98 and this causes the problem. I'll test it in the upcoming days and will report back.

  • Author
    Posts
Viewing 15 posts - 301 through 315 (of 642 total)
1 2 3 … 20 21 22 … 41 42 43