Re: [mv] MySQL database update problem

[John Beima <jbeima@palb.com>]

******    message to minivend-users from John Beima <jbeima@palb.com>     ******

Actually I want the tables to be able to be exported and imported. This 
is how i move them between two servers.

Simply put MiniVend does some searches based on the text files and some 
based on the SQL files. A simple "st-sql" added to your search criteria 
forces them to always be based on the SQL tables...

John


Quoting Stefan Hornburg <racke@linuxia.de>:

> ******    message to minivend-users from Stefan Hornburg 
<racke@linuxia.de>
>     ******
> 
> John Beima <jbeima@palb.com> writes:
> 
> > ******    message to minivend-users from John Beima <jbeima@palb.com> 
   
> ******
> > 
> > Actually this problem is kinda wierd...
> > 
> > We use phpMyAdmin to update the database, and just lik eyou said if 
you 
> > edit an existing code everything goes live fine, but if you add new 
items
> 
> > they don't appear.
> > 
> > The key to getting around this is one of two procedures.
> > 
> > First go into MiniMate and export the database/table back to the 
original
> 
> > text file, stop MiniVend and remove the database/table.sql file, 
restart 
> > MiniVend and when it re-imports the database/table it will work fine.
> > 
> > Two go to your searches and add teh parameter of "st=sql". This tells 
> > MiniVend to look at the sql tables and not the text source files.
> > 
> > Even though MiniVend is sposely looking at the MySQl tables, if the 
> > "code" is not in the source text file, it wont appear in your on-line 
> > catalog.
> > 
> > This was was a pain in my behind for a long time.
> 
> Hmm... maybe you should add the SQL tables to "NoImport". 
> 
> Ciao
>         Racke
> 
> -- 
> LinuXia Systems && Cobolt NetServices, eCommerce and more
> Shop- und Datenbanklösungen mit MiniVend, Firewalls auf Debian-Basis
> http://www.linuxia.de - http://www.cobolt.net
> -
> 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