Setting up Mysql Part I

["Darren Littlejohn" <darrenl@cats.ucsc.edu>]

******    message to minivend-users from "Darren Littlejohn" <darrenl@cats.ucsc.edu>     ******


I'm trying to get a big picture of how things work with Minivend, so that I
can set up my Storefront. It seems that I can tell minivend to look at DBI
for a Mysql database, but then there are a couple of confusing points:

1) Why do I need to include a .asc file in the Database directive (from
Catalog.cfg)?

In the documentation:

"Here is an example of a completely set up DBI database on mySQL, using a
comma-separated value input, setting the DBI attribute LongReadLen to
retrieve an entire field, and changing some field definitions from the
default char(128):

  Database   products  products.csv  dbi:mysql:minivend:localhost:3333
  Database   products  USER          mike
  Database   products  PASS          NeVairBE
  Database   products  DELIMITER     CSV"



What is the syntax of these directives? My guess is the following:

Directive  database_name ???.csv dbi:dbiformysql:talktominivend:host:port

What is the text file for if you're importing from a mysql database? Where
does the text file come from? Do I need to spit out a tab delimited text
file from my Mysql database in order for it to be read by minivend? Is it
automatically updated when my Mysql database is updated?

Is the text file just a table name definition so then minivend gets the
actual data from the mysql server?

-d-



Darren Littlejohn
Psychology Instructional Computing Manager
Psychology Faculty Services
University of California Santa Cruz
831-459-4652
darrenl@cats.ucsc.edu

I often quote myself; it adds spice to my conversation. -George Bernard
Shaw

> -----Original Message-----
> From: owner-minivend-users@minivend.com
> [mailto:owner-minivend-users@minivend.com]On Behalf Of Karl M. Joch
> Sent: Tuesday, January 05, 1999 6:48 AM
> To: minivend-users@minivend.com
> Subject: Mysql Hack. Anybody think that troubles comes up?
>
>
> ******    message to minivend-users from "Karl M. Joch"
> <k.joch@kmjeuro.com>     ******
>
> I had a big problem with loading our shop. Comsumes amounts of Memory and
> was unable to start on the Development System. We have 8 Tables
> defined for
> this Shop. Products has 520.000 entries and the Keyword File more then 1.5
> Millions. Now i looked for a way to start faster without loosing
> performance
> and wasting memory.
>
> Mysql has a Limit clause to reduce the query output (eg. 3 here).
> So I found
> in DBI.pm:
>
> sub list_fields {
>         my($db, $name) = @_;
> # DEBUG
> #Vend::Util::logDebug
> #("DBI list_fields call: @_\n")
> #       if ::debug(0x4);
> # END DEBUG
>         my @fld;
>
> #### JK 990105 &#196;nderung fuer schnelles Laden mit wenig Memory usage
>         my $sth = $db->prepare("select * from $name LIMIT 3")
>
>                 or croak $DBI::errstr;
> #### end
>         # Wish we didn't have to do this, but we cache the columns
>         $sth->execute           or croak "$DBI::errstr\n";
>
>         @fld = @{$sth->{NAME}};
>
>         croak "DBI: can't find field names.\n"
>                 unless @fld > 1;
>
> I check everything and it works fine at the moment. Anybody thinking that
> this doesn&#180;t work on the production machine too, or gives headache later?
>
> Running: Freebsd, MV 3.11 and Mysql 3.21.27 on a P2/350 with 256
> MB Ram and
> 48 GB HD
>
> Many thanks,
>
> Karl
>
> -
> 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
>

-
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