I recently started migrating from MS Access to MySQL. In order to move some of
the information, I used a ColdFusion page with SQL to select information from
the Access database and insert it into the MySQL database. While I was still in
the testing phase, one day I noticed my that I had two of each record in a
table in MySQL. My thinking at the time was that since I had left the page I
mentioned on the server, that somehow it had been called and run the queries
again. Therefore, I cleared out the table, ran the page again and immediately
removed it from the server. Everything seemed fine for a week and then suddenly
all these extra records showed up again in my database. My web host says that
they don't keep a backup on the server, but is it possible that it was cached
by a robot or something and the code was run again even though it's not on the
server? I would be grateful for any explanation or other suggestions as to
how this happened... and even more grateful for a way to prevent the database
from accepting these inserts. As I type this, it comes to mind that if my
theory about a cached page is correct, that a password change would do the
trick - right?