Forum: Ruby on Rails migrating data to multiple tables?

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
2153c531546ec0ee458057c2f279565d?d=identicon&s=25 zbadone (Guest)
on 2007-07-21 06:43
(Received via mailing list)

I'm trying to create a data migration for a new project I'm working
on.  I have numerous tables and would like to be able to populate the
MySql db with test data.

I get the data to appear in the tables but the linking (has_many,
has_one, etc.) don't seem to connect to each record properly. The area
I'm talking about is the id field of each record. I can get the
linking of the tables but the id of the records are starting from 15
of so each time.

| id | client_id | address |
| 33 |         1 |       1 |
| 34 |         2 |       2 |
| 35 |         3 |       3 |
| 36 |         1 |       4 |

Now this db has been through a number of migrations, both forward and
backwards (Version=0).
Is this something I'm overlooking in Rails or is this a MySql problem?

B0f09f622c913a13b9bfd332fca56563?d=identicon&s=25 Dan Manges (dcmanges)
on 2007-07-22 20:55
(Received via mailing list)
Knowing what is wrong without seeing the migrations is difficult, but
you can reset the auto_increment value on a table:
ActiveRecord::Base.connection.execute "ALTER TABLE people

It sounds like the auto_incrementing is continuing, but that shouldn't
happen if you're completely dropping your tables by going down to
database version 0.

Hope that helps,
Dan Manges
E3513c4edd6810bb4b9914b58da2a2c3?d=identicon&s=25 Jamal Soueidan (jamal)
on 2007-07-22 21:03
This happened to me once, I didn't know what to do also :)

But as "Dan Manges" said, if you drop your table the auto increment will
reset to ZERO again.
This topic is locked and can not be replied to.