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 fromhappening in the future:http://www.icdevgroup.org/interchange-doc-5.2.0/frames/icconfig_118.htmlI 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.