Subject: Re: problem with mysqlimport (fwd)
From: Christopher F. Baum (baum@bc.edu)
Date: Wed Sep 22 1999 - 13:46:18 MDT
Thanks, but I don't have an old database in mysql; I have a number of
databases in Oracle that I would eventually like to get into mysql, but a
requisite for getting anything into mysql seems to be the ability to import
data!
Kit Baum
--On Wed, Sep 22, 1999 1:14 PM -0700 Tom Tarka <tommy@mp3.com> wrote:
> Kit Baum wrote:
>
>> ---------- Forwarded message ----------
>> Date: Tue, 21 Sep 1999 06:39:26 -0400 (EDT)
>> From: Kit Baum <baum@bc.edu>
>> To: yellowdog-general@lists.yellowdog.com
>> Subject: problem with mysqlimport
>>
>> I have installed mysql on my yellowdog system successfully; I can create
>> databases, tables, etc. Running as root, I have created a table 'sauto'
>> in database 'baum' and am trying to use mysqlimport to populate it.
>>
>> I use $mysqlimport baum auto.dat on the command line, and the process
>> reports "error: can't get stat of /home/baum/mysql/sauto.dat"
>> (errcode=13) when using table sauto". I can execute the stat command on
>> this text file, and that works just fine. Whatsa hoppnin?
>
> Not that this solves the mysqlimport problem, but could you do a mysqldump
> of your old DB and then just do a: cat dumpfile | mysql
> to populate it?
>
> -t
>
-----------------------------------------------------------------
Kit Baum baum@bc.edu http://fmwww.bc.edu/ec-v/baum.fac.html
This archive was generated by hypermail 2a24 : Fri Oct 01 1999 - 16:13:45 MDT