lewis wrote:
> I have a production server and testing server. Every so often i need
> to backup the production server and restore it for testing.
>
> I ran the mysql administrator backup on only the db i needed, and
> restored the db on the test server. It carried all of my tables over
> but all the auto-increment fields lost thier auto-increment status.
>
> How do i restore this stuff.
> Sorry if it is a simple question i am new to mysql.
>

how do you restore the database? if you are not dropping tables i can
see why this is happening.

--
lark -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".