Re: [mv] convert from TAB to SQL

["Nick Pleis" <npleis@consultant.com>]

******    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