I usually do the database work in MySQL first and then update the schema file with symfony propel-build-schema xml. I find it easier to create tables in MySQL then typing them in the schema files, plus you don't lose any data when you do this.
On 9/6/07, Kiril Angov <[EMAIL PROTECTED]> wrote: > > > And how exactly are the new tables created in MySQL. You need to execute > the commands from symfony propel-build-schema which is done by symfony > propel-insert but it does insert/delete ALL tables not just the changes. > > Kupo > > Quenten Griffith wrote: > > Why would you have to reset your data in your tables? Change the > > schema inside your database and run symfony propel-build-schema then > > symfon propel-build-model and your new table is now ready to use in > > your model with out losing any data in your actually database. > > > > On 9/6/07, *Kiril Angov* <[EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED]>> wrote: > > > > > > +1 > > > > So many times I had to add a table to the schema and did not want to > > reset all my old tables data but simply to execute the changes > > (migrations, right :)) > > > > Kupo > > > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> wrote: > > > Hi everyone, > > > > > > This quote: > > > > > > "The way the databases are created, and modified can be maddening. > > > There does not appear to be a way to modify a single table and > only > > > rebuild the model layer function for it, the entire database must > be > > > dumped and rebuild. To make matters worse the database backup > system > > > is broken and reloads data unreliably, again as far as I can > > tell. I > > > work around this by doing a MySQL complete data dump, and > > reloading it > > > when I've rebuild the database structure." > > > > > > >From http://www.robertspeer.com/blog/?p=8 > > <http://www.robertspeer.com/blog/?p=8> > > > > > > I agree with his frustrations with the database interactions. I > was > > > wondering if this was being addressed in the 1.1 release. > > > > > > Thanks, > > > Kevin > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" 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/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
