[ic] mixed up catalog.cfg files

Dan Bergan danb at berganconsulting.com
Wed May 9 13:44:56 EDT 2007

My "test" catalog.cfg had the following line:
DatabaseDefault  HIDE_AUTO_FILES  1

I found this when I googled the icdevgroup.org site:

  Result is to hide all .sql, .*dbm, and .autonumber files
  by putting a "." in front of them.

  I got sick of having the directory listing scroll off the

  WARNING: If this is set after databases are imported, they
  will be overwritten! So do it at the beginning.

So, I assume that's what did it...

I wonder how will this interact with NoImport (or NoImportExternal)?


On 5/9/07, Paul Jordan <paul at gishnetwork.com> wrote:
> 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
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

More information about the interchange-users mailing list