On May 11, 5:13 pm, lark <ham...@sbcdeglobalspam.net> wrote:
> 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 -- ham...@sbcdeglobalspam.net
> To reply to me directly, delete "despam".

I am restoring to a new (blank) database