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 nothing
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
Mogens Melander mogens at 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 best I
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
snip
mysql quit
Bye
-bash-3.1$ exit
logout
No no no.
AS the MYSQL user:
cat /tmp/abc.txt
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 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
I'm at total loss. apparently, error 13 relates to file permissions? what
could possibly be preventing the import?
http://paste.husk.org/8073 for:
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$ ll /tmp/abc.txt
-rw-r--r-- 1 thufir thufir 33 Apr 12 06:59 /tmp/abc.txt
[EMAIL PROTECTED] ~]$ cat
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
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, Thufir
Hi!
I'm having a strange problem - I can't read data using the
mysql -u root -p databasepath/to/whatever.sql
Not getting any error message, but some kind of introduction text
flashes by reading:
[powerbook:~] victor% /usr/local/mysql/bin/mysql -u root -p *** databas
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 databasepath/to/whatever.sql
Not getting any error message, but some kind of introduction text
flashes by reading:
[powerbook:~] victor%
-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
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
Hi all,
I'm having a problem importing a dump file in Mac OSX. I created the dump
from phpMyAdmin, and tried to import it in these 2 ways with the following
results:
From mysql command line:
Mysql database_name dumped_file;
Result: ERROR 1064: You have an error in your SQL syntax near
14 matches
Mail list logo