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

Re: [ic] mixed up catalog.cfg files


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

I found this when I googled the icdevgroup.org site:
http://www.icdevgroup.org/pipermail/interchange-cvs/2002-October/004258.html

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

 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)?

Dan



On 5/9/07, Paul Jordan <suppressed> wrote:
suppressed 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
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users

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