Akopia Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

RE: [mv] Mysql and text db's



Title: RE: [mv] Mysql and text db's

In 4.04 do the following:

1) Remove area.mysql country.mysql products.mysql cat.mysql inventory.mysql pricing.mysql shipping.mysql from catroot/mysql.

2) Edit catalog.cfg and define SOMESQL, SQLDSN and username and password for accessing the database.
3) Copy these from inside the #ifndef SOMESQL to somewhere else

Database            area         area.txt          TAB
Database            area         AUTO_NUMBER       1
Database            cat          cat.txt           TAB
Database            country      country.txt       TAB
Database            inventory    inventory.txt     TAB
Database            products     products.txt      TAB
Database            pricing      pricing.txt       TAB
Database            pricing      KEY               sku
Database            pricing      NUMERIC           q2
Database            products     HOT               1
Database            products     INDEX             category:c
Database            shipping     shipping.txt      TAB
Database            shipping     AUTO_NUMBER       1

Start Minivend and the 3 remaining tables should be created in MySQL...

Hope this helps,

Cameron

 -----Original Message-----
From:   owner-minivend-users@minivend.com [mailto:owner-minivend-users@minivend.com]  On Behalf Of adfranse
Sent:   Tuesday, May 30, 2000 3:32 AM
To:     'minivend-users@minivend.com'
Subject:        [mv] Mysql and text db's

******    message to minivend-users from adfranse <info@afa.nl>     ******

Hi,

I only want a few databases in mysql. These are orderline, transactions and userdb. All the other databases have to stay text. I this possible and if so, How ????

Grt, Walter
-
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


Search for: Match: Format: Sort by: