[ic] mixed up catalog.cfg files
Paul Jordan
paul at gishnetwork.com
Wed May 9 12:38:13 EDT 2007
interchange-users-bounces at icdevgroup.org wrote:
> Hello All -
>
> I made a big error yesterday and loaded a catalog.cfg file for a test
> catalog into my live catalog (and restarted). I quickly realized my
> error and put the correct file back in place and restarted the
> catalog. Everything looked to be running fine again.
>
> However, when I looked at the error.log, I saw this (when applying
> the incorrect cfg file): - - - [08/May/2007:17:25:53 -0400] - - table
> orderline created: create table orderline (
>> code char(14) NOT NULL PRIMARY KEY,
>> store_id varchar(9) DEFAULT '' NOT NULL, (etc...)
>
> There were a few other tables as well.
>
> Then I noticed that the last two years worth of transactions and
> orderline records were gone from my database! It also looks like
> about 5 months worth of userdb records are missing as well.
>
> I do have a backup, but why would some of the records be deleted? I
> just want to understand what happened so I can make sure I
> fix/restore everything correctly.
Maybe that was the data in the products/foo.txt files? You probably
exported userdb 5 months ago (to it's unused txt file - assuming you are
using a sql db). Not sure why overwriting catalog.cfg tried to import the
txt files if there were .sql files in place... That is a little scary.
Paul Jordan
More information about the interchange-users
mailing list