Re: [mv] convert from TAB to SQL

[Viktors Rotanovs <viktors@riga.nu>]

******    message to minivend-users from Viktors Rotanovs <viktors@riga.nu>     ******

Hello, Nick!

The method you recommended is good, but it does not create tables
automatically using mysql/* :(

Nick Pleis wrote:
> 
> ******    message to minivend-users from "Nick Pleis" <npleis@consultant.com>     ******
> 
> It's easy:)
> 
> There are command line utilities supplied with mysql, including one called
> mysqlimport.
> 
> Simply create the table within mysql (You have to issue a CREATE statement),
> and then name your textfile the same name (and case) of the table name.
> 
> So if I have a table MYProducts, I must have a text files called
> MYProducts.txt .
> 
> Then simply try this:
> 
> mysqlimport db_name -u user -p --fields-terminated-by='\\t' MYProducts.txt
> 
> Where db_name is the name of the database where MYProducts is located and
> user is a valid username to access that database.
> 
> It should import from that file after you do that...
> 
> Nick
> ----- Original Message -----
> From: Viktors Rotanovs <viktors@riga.nu>
> To: <minivend-users@minivend.com>
> Sent: Thursday, March 30, 2000 3:12 AM
> Subject: [mv] convert from TAB to SQL
> 
> > ******    message to minivend-users from Viktors Rotanovs
> <viktors@riga.nu>     ******
> >
> > Hello!
> >
> > How can I convert products.txt and other tables
> > from TAB format to MySQL, without reinstalling
> > the catalog?
> >
> > Best Wishes,
> > Viktors Rotanovs
> >
> > DATIONS Ltd., phone: +371 9173000, fax: +371 7377472
> > -
> > 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

-- 

Best Wishes,
Viktors Rotanovs

DATIONS Ltd., phone: +371 9173000, fax: +371 7377472
-
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