I've noticed that exporting table structure as CREATE scripts seems to helpfully set the auto_increment on the table to what it was while exporting. While I can see how this is desirable as the default action, it is a bit of a pain when developing a new database since it means testing (adding dummy rows) will propagate to other environments (when running the CREATE scripts).

Is there any way of exporting tables etc (via the scheduler) WITHOUT setting the AUTO_INCREMENT? I thought that selecting the export of "structure only" as opposed to "structure and data" would have done the trick, but no.

This is not an issue with SQLyog really. The MySQL server returns that table definition.

anyway .. let us discuss of we can do something about it!

I forgot to tell the 'workaround'

Use the table menu .. backup .. Export Data as CSV etc and select SQL. This will generate a very simple CEATE statement only.