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

Duplicated Lines ?

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Duplicated Lines ?

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • April 27, 2004 at 5:51 am #8409
      Néo
      Member

      Hi there !

      here is my latest problem in my database implementation : while creating indexes in my brand new imported tables, PhpMyAdmin reported me duplicated lines.

      After checking my sources it appears that those lines were single in the original .DBF Files. How comes ?

      I'm currently using the latest EasyPhp release (before I move the whole solution on a Netware platform), accessing the database thru MyODBC and the .DBF Files thru ODBC Foxpro driver. The odd part is that duplicated lines vary when I repeat the operation.

      Any idea of where the problem might come from ?

      Thank's for your help,

      Néo

    • April 27, 2004 at 9:01 pm #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 28, 2004 at 2:06 pm #15728
      Néo
      Member

      Well, I first imported the data with SQLyog BEFORE trying to index the tables and only then discovered it had created duplicatas.

      I tryed the same exercise AFTER having created the indexes and SQLyog then reports me errors, so some of the rows can't be imported.

      I used PhpMyAdmin to create the primary indexes since it appeared simplier to me in case of multiple fields primary key creation.

      By the way, that kind of errors worries me a bit concerning the data integrity, huh ?

      Thank's for your help

    • April 30, 2004 at 12:30 pm #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.

    • May 2, 2004 at 12:06 pm #15730
      Néo
      Member

      All right, I'll do that as soon as I get back to my office…

  • Author
    Posts
Viewing 4 reply threads
  • You must be logged in to reply to this topic.