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