[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [ic] How To: use offline with MySQL database?
Scott Goodman wrote:
>
> You are simply trying to import the file? Try it using the mysql command
> line tool. Run something like this:
>
> $ mysql databasename
> mysql> load data infile '/path/to/products.txt' into table products fields
> terminated by '\t' ignore 1 lines;
--------------------------------------
Scott, thanks for the tip. I will be spending some time learning about
how to manage SQL tables. I have not really spent much time doing so. I
tried to do as you suggested & also read the online docs on MySQL for
more info. I have got some permission problems that are not resolved.
Debian sets up MySQL as root on localhost initially. I seem to be having
some problems getting a handle on getting this altered. I am using
WebMin to manage all of my databases/tables in MySQL as I like GUI
interfaces for speed. Any thoughts are appreciated.
John Foster
jfoster@augustmail.com
ICQ# 19460173
_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users
