On Feb 9, 2012, at 12:49 PM, Peter Vandenabeele wrote: > On Thu, Feb 9, 2012 at 6:43 PM, John Hinnegan <[email protected]> wrote: > I'm using AWS RDS / MySQL for my DB layer. > > I ran migrations on my sandbox environment, and then on my production > environment, and I'm getting slight differences. I'm fairly new to MySQL. > The differences are these AUTO_INCREMENT fields. Should I take the > difference to indicate that I've messed up my migrations and should start > fresh? Or is it possible for the same migrations to result in different > schemas? > > Schema's dumped using mysqldump: > mysqldump -u xxx -pxxx dbnamexxx --no-data=true --add-drop-table=false -h > dbhostxxx > dbnamexxx.schema > > then diffed > 50c50 > < ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 > COLLATE=utf8_unicode_ci; > --- > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > 69c69 > < ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 > COLLATE=utf8_unicode_ci; > --- > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > 86c86 > < ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 > COLLATE=utf8_unicode_ci; > --- > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > > > Maybe the AUTOINCREMENT is related to master-master replication on one of > the 2 Mysql installations ? > > http://dev.mysql.com/doc/refman/5.1/ja/replication-auto-increment.html > > If it has master-master replication, the AUTO_INCREMENT _must_ be set to > avoid collisions of the sequences for the id's > > HTH, > > Peter
I have seen this behavior when a dump is made from a database that already contains data. The auto-increment attribute is only reset by calling TRUNCATE TABLE tablename before dumping. I would not worry about it at all, unless you have a requirement that your first ID be 1. Walter > > -- > *** Available for a new project *** > > Peter Vandenabeele > http://twitter.com/peter_v > http://rails.vandenabeele.com > http://coderwall.com/peter_v > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
