[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