[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Setting up Mysql Part I
****** message to minivend-users from Dan Busarow <dan@dpcsys.com> ******
On Tue, 5 Jan 1999, Darren Littlejohn wrote:
> 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)?
You only need the filename there as a placeholder. The file does
not need to exist and if it does exist it does not need any entries.
> 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
MV_table_name optional_flat_file DSN, same as in DBI->connect()
Your "talktominivend" is the name of the database containing the MV tables.
> What is the text file for if you're importing from a mysql database? Where
You can build your mysql table from data in the flat file. I see this
as a good way to shoot yourself but others find it useful. Set
NoImport products any_other_dbi_tables
to protect yourself from this possibly surprising feature.
Dan
--
Dan Busarow 949 443 4172
Dana Point Communications, Inc. dan@dpcsys.com
Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82
-
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
