s or a mysqldump of the databases and comes up with a sql script:
> >
> > Alter table Table1 add myField4 int;
> > Alter table Table1 change myField1 myField1 varChar(60);
> >
> > Yes, I can do it by eyeballing it...I'm just too lazy. :)
> >
> >
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 21, 2001 1:48 PM
> To: Cal Evans
> Cc: [EMAIL PROTECTED]
> Subject: Re: Database structure DIFF
>
>
>
> I'm not sure what you mean by "structural changes
;ve made things clearer.
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 21, 2001 1:48 PM
To: Cal Evans
Cc: [EMAIL PROTECTED]
Subject: Re: Database structure DIFF
I'm not sure what you mean by "structu
I'm not sure what you mean by "structural changes".
If the the two table have the same number of columns and they are in the same order,
you can do something like what I have explained below. It you included the table info
from prod and test I could help you better (DESC prod;).
# Create t
Pardon the newbie question but is there a tool available for MySQL that I
can give it 2 databases and it give me the ALTER TABLE statements necessary
to make 2 identical to 1?
Specifically, I have a test and prod database. I've made structural changes
to test and want to propagate them to prod.
