No PRIMARY KEY defined

This topic is empty.

Viewing 8 reply threads

Author

Posts
- April 16, 2004 at 6:13 am #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:17 am #15669
  
  Patrick
  Member
  
  What about weak entity sets which, by definition, have no primary key??
  
  SQLyog seems to be a fantastic product, surely it's not crippled by something as fundamental as this!
- April 16, 2004 at 6:28 am #15670
  
  Shadow
  Member
  
  Even SQLyog's GUI cannot really handle tables without PKs… You should request it as a new feature!
- May 14, 2004 at 11:15 am #15671
  
  kams
  Member
  
  Same here… Great product ! but this PK rule made it useless for me…
  
  Feature request :
  
  Isn't it possible to ask user what they want to do with the pk less tables ?
  
  Either copy it one way or the other… then later have a merge/sync function…
  
  Tx again for your hard work !
- May 16, 2004 at 5:20 am #15672
  
  emagin
  Member
  
  Is there any kind of a workaround to this PK requirement?
  
  This is killer. I mean, what DB that you want to synch DOESN'T have tables w/out PK's.
  
  Any kind of hack would be of interest.
- May 18, 2004 at 2:54 am #15673
  
  emagin
  Member
  
  Ok, we can probably force all tables to have PKs.
  
  Will it support multi field PKs?
- May 19, 2004 at 6:05 pm #15674
  
  Shadow
  Member
  
  Sure, it doesn't matter how many fields a PK has.
- June 8, 2004 at 4:59 pm #15675
  
  halcyon
  Member
  
  Hi I'm using SQLYog 3.71 and also having the same problem with sync'ing tables without a PK.. I have tables where the key column lists them as MUL, which I'm assuming is multiple… and yet it does not sync. Here is the message I get:
  
  No PRIMARY KEY defined in the table '`yazdFilter`'
  
  Here is the table info:
  
  Code:
  
  Column Information For – salesweb.yazdFilter
  ——————————————–
  
  Field Type Collation Null Key Default Extra Privileges Comment
  ———— ——- ——— —— —— ——- —— ——————————- ——-
  filterObject blob NULL YES (NULL) select,insert,update,references
  forumID int(11) NULL MUL 0 select,insert,update,references
  filterIndex int(11) NULL MUL 0 select,insert,update,references
  
  Index Information For – salesweb.yazdFilter
  ——————————————-
  
  Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
  ———- ———- ———– ———— ———– ——— ———– ——– —— —— ———- ——-
  yazdFilter 1 forumID 1 forumID A (NULL) (NULL) (NULL) BTREE
  yazdFilter 1 filterIndex 1 filterIndex A (NULL) (NULL) (NULL) BTREE
  
  DDL Information For – salesweb.yazdFilter
  —————————————–
  
  Table Create Table
  ———- ————————————————————————————————————————————————————————————————————————————————
  yazdFilter CREATE TABLE `yazdFilter` (
  `filterObject` blob,
  `forumID` int(11) NOT NULL default '0',
  `filterIndex` int(11) NOT NULL default '0',
  KEY `forumID` (`forumID`),
  KEY `filterIndex` (`filterIndex`)
  ) TYPE=MyISAM DEFAULT CHARSET=latin1
  
  Any ideas??? We REALLy need to backup/sync these tables.
  
  Thanks
- June 8, 2004 at 10:05 pm #15676
  
  Shadow
  Member
  
  As I said before, sja is currently unable to sync tables without a PK. I know no hack or workaround. It is up to Ritesh to incorporate a new feature. He argues that you cannot tell which record gets updated in a table without PK as there may be multiple rows holding the same values.
  
  You should consider using MySql's built-in replication feature, that won't mind about PKs.
Author

Posts