Re: Configuring Mysql

[Derek Simkowiak <dereks@kd-dev.com>]

******    message to minivend-users from Derek Simkowiak <dereks@kd-dev.com>     ******

> How do I set up Minivend to read products from my Mysql database?

	I haven't done this yet, but it seems pretty clear to me: set up
your MySQL tables like you want them, then define the MiniVend directive
"Database" for the appropriate DBI username, host, port, etc.  The
MiniVend "Database" directive would be in the "catalog.cfg" file.

	Here is the MySQL example from the "simple" demo catalog:

/home/minivend/catalogs/simple/catalog.cfg:
----------------------------------------------------------------
Database            products products.asc dbi:mysql:minivend:localhost:3333
----------------------------------------------------------------

	...The docs section "SQL support via DBI" describes the DBI
support more fully.  I believe that may be the document you attached.

	The important thing to remember is to specify the "NoImport"
directive, otherwise MiniVend will read the ASCII files (i.e.,
products.asc) and overwrite whatever is in your MySQL database.  (I
consider that very dangerous behaviour, and think that the user should be
forced to explicitly state a directive which would allow MiniVend to
overwrite the tables).


Derek Simkowiak
dereks@kd-dev.com


-
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