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
suggesti
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 fo
Gabe,
There are actually some problems caused by how auto increments are tracked
in the database. We do our backups by using mysqldump at night and
preserving all of the log files that were created during the day. The
problem occurs during recovery where auto increment values can be
incremented
