[ic] mixed up catalog.cfg files
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
More information about the interchange-users