Re: mySQL create tables

["Phil Welch" <PhilmoreW@worldnet.att.net>]

Russ,

Have you tried something like this:

"The configuration of the DBI database is done by setting attributes in
additional Database directives after the initial defining line as described
above. For example, the following defines the database arbitrary as a DBI
database, sets the data source (DSN) to an appropriate value for an mSQL
database named minivend on port 1114 of the local machine:


    Database arbitrary arbitrary.asc SQL
    Database arbitrary DSN           dbi:mSQL:minivend:localhost:1114"

tailored to mySQL?

Regards,

Phil Welch

----- Original Message -----
From: Russ <russ@khouse.org>
To: Minivend-Users <minivend-users@minivend.com>
Sent: Friday, July 23, 1999 1:27 AM
Subject: mySQL create tables


> ******    message to minivend-users from "Russ" <russ@khouse.org>
******
>
> Hello,
>
> On Solaris 2.5 w/ mySQL 3.22, and MV 3.14, and PERL
> 5.005_03...
> My catalog.cfg is this:
>
> Database            products products.asc
> dbi:mysql:dbname:localhost:3306
> Database            products USER       username
> Database            products PASS       password
>
> And the error I get is this:
>
> simple config error: Undefined subroutine
> &Vend::Table::DBI::create called at
> /VENDROOT/mvend/lib/Vend/Table/Import.pm line 160, <IN>
> chunk 1.
>
> simple: error in configuration. Skipping.
> simple: config error. Skipping.
>
> DBD and DBI::mysql are installed, and I've messed with line
> 160 of Import.pm, and I've looked around in DBI.pm, at the
> 'create' subroutine.  So far, I can't find any problem!
> Other databases that ues InMemory instead of DBI modules to
> create the data don't have any problems.
>
> Any ideas folks?
>
> Russ Mann
> --------------------------
> Earn Money to surf the Internet Click Here!
> http://www.alladvantage.com/refhome.asp?refid=AWW-495
>
> -
> 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