Re: [mv] minimate & loss of data

[Victor Nolton <ven@pragakhan.com>]

I've setup a crontab to run a script that just copies all the .asc 
files in the products directory everynight at midnight (Note there 
are backups run to tape as well).

I only do this cause I PERSONALLY use to edit the database but now 
the customer is doing it.

here is a snip of the perl script used (nothing fancy)

#!/usr/local/bin/perl
$date_command = "/bin/date";
$date = `$date_command +"%B%d"`; chop($date);

system "/bin/mkdir /usr/home/ven/catalogs/bbbstore/products/backups/$date";
system "/bin/chmod 777 /usr/home/ven/catalogs/bbbstore/products/backups/$date";
system "/bin/cp /usr/home/ven/catalogs/bbbstore/products/*.asc 
/usr/home/ven/catalogs/bbbstore/products/backups/$date";

noone has access to the server other than myself (chmod 777)

Ven

>******    message to minivend-users from mvend@beadles.org     ******
>
>I have an end-user entering products with Minimate.  The products database
>appears to have dropped (deleted) about 75% of the products without the
>user deleting each item.  I don't see a way for the user to cause this,
>unless they uploaded a database file, which they say they did not.
>
>I've checked the httpd logs and the Minivend error.log, but found no clues.
>I'm currently trying to pick through session.gdbm, but am not sure what to
>look for.
>
>Some details about my system:
>
>Minimate v.3.14.0.3
>  Using config/menu.html access (simpler version)
>Linux/Apache
>Database
>  products.gdbm >352 Kb
>  products.asc  >285 Kb
>  number of records > 580 (long product descriptions)
>Edit existing key, spreadsheet edit and auto-export options were not
>visible (because mvc_too_large limit was met?).  The user was exporting
>every few minutes.
>
>Also:
>
>1. What parameters should one look at when choosing a database format (eg.
>SQL vs ASCII)?  Is the decision a performance issue or is database
>integrity a concern?
>
>2. Does the 100_000 for mvc_too_large in minimate/mmtags.cfg mean
>products.gdbm < 100,000 bytes?  Do mvc_too_large and mvc_way_too_large have
>significance other than changing the available editing features?
>
>Any ideas about what happened to my database or how to figure out what went
>wrong would be VERY appreciated.
>
>Melissa Calhoun
>
>
>-
>To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
>email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
>Archive of past messages: http://www.minivend.com/minivend/minivend-list


Ven's News: http://www.pragakhan.com/news.html

                    HEAVEN IS AN ORGASM is Rereleased
              http://lordsofacid.pragakhan.com/heavenisanorgasm

Ven (ven@pragakhan.com) _________________ http://ven.pragakhan.com __
AOL: WebmstrVen     Praga Khan's Official Website        ICQ: 8321393
                       http://www.pragakhan.com
                     Lords of Acid Official Website
                       http://www.lordsofacid.com