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

Re: [ic] mixed up catalog.cfg files


Paul Jordan wrote:
suppressed 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:
http://www.icdevgroup.org/interchange-doc-5.2.0/frames/icconfi
g_118.html


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.

Bye
	Racke



--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

_______________________________________________
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.