lewis wrote:
> 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
>


when you backup make sure you have a couple of things done right in the
advanced options tab:
1-check add drop statements
2-check complete inserts
3-check comments (if need be)

then take the backup

when restoring make sure you select the file that was just backedup and
make sure that the original schema is selected for target schema and
that file type is sql, then just click the restore button and it should
restore everything including the autoincrements