On Mon, 16 Apr 2007 10:28:30 +1000, Chris wrote:
> What did *you* do differently this time?
>
> Obviously the user is different, but what about permissions? What were
> they before? 644 should have worked previously but since we don't know
> what they were before we can't tell you.
>
> It has n
Now, would someone please explain *why* this worked and all my other attempts
didn't? Was it because of file permissions? or the linux user id? or that I
put a passwork on the mysql root account? or that I changed the ownership of the
data file? or that I took out some spaces on the data fil
I think I got it:
pasty / paste.husk.org
This content is stored as http://paste.husk.org/8089.
From: Someone at 24.84.131.197
Summary: -bash-3.1$ -bash-3.1$ -bash-3.
-bash-3.1$
-bash-3.1$
-bash-3.1$ whoami
mysql
-bash-3.1$ ls -al /tmp/abc.txt
-rw-r--r-- 1 mysql mysql 27 Apr 13 11:36 /tmp/ab
Hmmm, i got a somewhat different result :^)
(BTW. I'm on Slackware 10.0. What are you on?)
$ cat /tmp/abc.txt
A1, B1, C1
A2, B2, C2
A3, B3, C3
$mysql test
Server version: 5.0.24a-log
mysql> SHOW GRANTS FOR ''@localhost;
+--+
| Grants for @localhost
I think I fixed it, at least as best I could. still same result:
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$ su - mysql
Password:
-bash-3.1$
-bash-3.1$ mysql -u root -p
mysql> quit
Bye
-bash-3.1$ exit
logout
No no no.
AS the MYSQL user:
cat /tmp/abc.txt
So:
Mogens Melander fumlersoft.dk> writes:
>
> Hmmm, your "LINES TERMINATED BY '/r/n';"
>
> should be:
>
> "LINES TERMINATED BY '\r\n';"
>
> if the abc.txt file was generated on windows. If it
> was made on *nix/linux, it should be:
>
> LINES TERMINATED BY '\n';
I think I fixed it, at least as
Hmmm, your "LINES TERMINATED BY '/r/n';"
should be:
"LINES TERMINATED BY '\r\n';"
if the abc.txt file was generated on windows. If it
was made on *nix/linux, it should be:
LINES TERMINATED BY '\n';
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Thu, April 12, 2007 09:58, Thufi
Thufir wrote:
I'm at total loss. apparently, error 13 relates to file permissions? what
could possibly be preventing the import?
Change to the mysql user (you might have to go to root and then mysql):
# su - mysql
then try it:
cat /tmp/abc.txt
what happens?
--
MySQL General Mailing Lis
-p without the passwd immediately following is not compatible with
input redirection.
Either add the password after the -p with NO space, or better yet,
create a .my.cnf file in the home directory of the user running the script
and have it contain the user and password settings.
Victor Spång Arthur
Victor Sp?ng Arthursson <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I'm having a strange problem - I can't read data using the
>
>mysql -u root -p database
> Not getting any error message, but some kind of introduction text
> flashes by reading:
>
>
> [powerbook:~] victor% /usr/local/mys
Thanks Brent,
Yes, I too can import with LOAD DATA and mysqlimport, but the thing that's
irritating is that I have to create the tables first in order to import the
data in either case.
With a 'regular' import from a dumped table, mysql should be able to read
the SQL statements within the dump f
11 matches
Mail list logo
