Thanks. That sounds pretty labor intensive, since I'd have to do the copy for each table. That makes the process much harder to automate. And I'm not sure the end result would be what I wanted anyway. I would like to be able to do this without copying data around. Does anybody have another suggestion?
On Mon, May 19, 2008 at 11:00 PM, Moon's Father <[EMAIL PROTECTED]> wrote: > You can import your data into a test database,then export the data using > statement select ... into ... > then You can complare the two. > > > On Tue, May 20, 2008 at 9:14 AM, Dan Lipsitt <[EMAIL PROTECTED]> wrote: > >> Is there a set of flags for mysqldump that will include the auto_increment >> specifier for columns, but leave out the AUTO_INCREMENT=x saved values? >> >> I want to compare the schema of two versions of a database, without >> considering the data. In my opinion, the saved auto increment counter is >> part of the data, not part of the schema, but the --no-data flag doesn't >> seem to share my opinion. >> >> If I run >> >> mysqldump a -d > a.sql >> mysqldump b -d > b.sql >> diff a.sql b.sql >> >> I want to see no output if the schemas are the same, regardless of how >> many >> rows of data each database has. Is there a way to do this with just >> mysqldump or mysql? >> >> Thanks, >> Dan >> > > > > -- > I'm a mysql DBA in china. > More about me just visit here: > http://yueliangdao0608.cublog.cn
