[thelist] Mysql backing up db

Adrian Fischer adrian at logo-logic.com
Fri Oct 19 18:50:47 CDT 2001


Hi Guys + Gals

I'm using mysql and perl to run an online db app.  I use phpadmin to keep
tabs on the db.  Using phpadmin I can download the db data and structure.
All good stuff.

My question is:  If the db should fall over and I have to use my back up
data to restore the db how do I over come the issue of the first column in
my db being an autoincrementing column.  I actually use this column as a
means of identifying data in the db.  If I try and insert a backed up set of
data it tells me there is an error because I already have a number in the
first column.

Would this tend to suggest that I haven't designed my db correctly?  Or am I
missing something more subtle?

Your help as always is appreciated.

Regards

Adrian Fischer
Australia
Adrian Fischer
AussieBidder

http://aussiebidder.com





More information about the thelist mailing list