I have written a backup routine in PERL which works ok except for a problem if the backup is restored.
My tables cross reference on an auto - increment field but when I create a new set of tables, the auto increment fields are reset too, therefore losing the relationships.
I have written a work round where the 'number' fields are copied to a non auto field and then copied back to the auto field after restore.
This works ok but I was wondering if there is a another approach to the problem.
Keith
My tables cross reference on an auto - increment field but when I create a new set of tables, the auto increment fields are reset too, therefore losing the relationships.
I have written a work round where the 'number' fields are copied to a non auto field and then copied back to the auto field after restore.
This works ok but I was wondering if there is a another approach to the problem.
Keith