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

Reply via email to