[ic] mixed up catalog.cfg files
racke at linuxia.de
Thu May 10 03:56:53 EDT 2007
Paul Jordan wrote:
> interchange-users-bounces at icdevgroup.org wrote:
>> On May 9, 2007, at 11:27 AM, Dan Bergan 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.
>> You'll want to check out the NoImport directive to prevent that from
>> happening in the future:
> I agree - I use this religiously. I think NoImport should be the default
> BTW, or there should be some NoImport * facility that can be overridden by
> the mysql definition itself, or lack thereof.
I agree, the standard mode should be to import only if the corresponding
database table doesn't exist.
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
More information about the interchange-users