[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [ic] mixed up catalog.cfg files


suppressed 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

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.