Ok.. Disregard... the spaces I added for troubleshooting after the
commas fubar'd it.
>Now, I have another problem:
>ERROR 13 (HY000): Can't get stat of
'/users/lolajl/documents/development/knitlib/datafiles/standardwttype.txt'
>(Errcode: 13)
That's permission. is the dir 755?
PB
Lola J. Lee Beno wrote:
Peter Brawley wrote:
>ERROR 1064 (42000): You have an error in your S
Lola J. Lee Beno wrote:
ERROR 13 (HY000): Can't get stat of
'/users/lolajl/documents/development/knitlib/datafiles/standardwttype.txt'
(Errcode: 13)
Never mind . . . I figured that I needed to add LOCAL to the query.
Should have gone back to the manual page for LOAD DATA.
--
Lola - mai
Peter Brawley wrote:
>ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your >MySQL server version for the right
syntax to use near 'standardwttype.txt`
Use single quotes not (dreaded) backticks.
This seems to have fixed one problem. Now, I ha
Lola
>I keep getting an error message:
>ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your >MySQL server version for the right
syntax to use near 'standardwttype.txt`
Use single quotes not (dreaded) backticks.
PB
-
Lola J. Lee Beno wrot
> I am moving a table from a 3.23.56 db to a 4.1.7 db. I currently only
> testing to see if I can. So far, I have been able to create the receiving
> table, but not be able to insert the data. (The only difference I see when
> using phpMyAdmin is the collation column on the 4.1.7 server)
>
> Whe
--- mos <[EMAIL PROTECTED]> schrieb: > At 12:23 PM
Thanks a lot, Mike.
It works.
I spent many hours with this problem.
I also tried the trick with a temporary table,
but used the "INSERT" command, which didn't help.
All the best to you,Harald
>
> Harald,
> 1) load the data into
At 12:23 PM 7/9/2004, you wrote:
Hi,
I'd like to load "TEXT"-data of variable length
into an existing table with "CHAR"-columns.
The input file consists of about 4200 lines
with alphanumeric characters and newline only.
Instead of filling up the "TEXT"-column
next to the existing columns, Mysql
app
--- Victor Pendleton <[EMAIL PROTECTED]> schrieb:
> What are the delimiters for this file?
I tried different variants:
No delimiters.
Delimiter ' (quote).
Delimiter " (doublequote).
All lines terminated by \n.
The files holds only a single column.
The column makes up 4200 rows.
Each row of diff
What are the delimiters for this file?
-Original Message-
From: Jens Gerster
To: [EMAIL PROTECTED]
Sent: 7/9/04 12:23 PM
Subject: Loading data into "TEXT" column;
Hi,
I'd like to load "TEXT"-data of variable length
into an existing table with "CHAR"-columns.
The input file consists of
On Thursday 03 April 2003 09:28, Justin French wrote:
> I have a 2.7meg dump of SQL created by phpMyAdmin [1], however when I try
> to import this data back into mysql through phpMyAdmin, it times out
> (understandably), so I guess I need to do this from the command line, but
> have no idea how to
Sean,
Monday, October 07, 2002, 10:11:51 PM, you wrote:
SM> I seem to have run into a rather peculiar problem. I was attempting to load
SM> data into a table from a file. I checked with the online documentation and
SM> found the following syntax:
SM> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE
Dear Ben,
there is no need for two separate .sql files (maybe there *is* a need,
you will know ;-)
To dump structures from one database, all tables and all data included,
and with "drop table" so you can restore overwriting existing tables:
mysqldump my_db --add-drop-table > my_db.sql
To r
On Tue, Aug 21, 2001 at 03:25:07PM -0500, Ben Davis wrote:
> I have a .sql file that I got from a PHPMyAdmin dump. Now I want to run the
> sql commands that are in that sql file, possibly even including the INSERT
> commands.. I have one that contains just the structure and one that has the
> st
)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql>
>From: "Milan Kajnar" <[EMAIL PROTECTED]>
>To: "Siomara Pantarotto" <[EMAIL PROTECTED]>
>Subject: Re: Loading data with a txt file
>Date: Thu, 17 May 2001 08:14:14 +0200
>
>Whe
LOAD DATA LOCAL INFILE '/path/myfile.txt'
INTO TABLE mytable
FIELDS TERMINATED BY '|';
If the text values are enclosed by double quotation
marks, you need to remove the semicolon in line 3 and
add:
ENCLOSED BY "\"";
If your myfile.txt was created in Windows, you *may*
need to remove the semicol
http://www.mysql.com/documentation/mysql/commented/manual.php?section=LOAD_D
ATA
LOAD DATA LOCAL INFILE "myfile.txt" INTO TABLE mytable FIELDS TERMINATED BY
'|'
- Original Message -
From: "Marcus Ouimet" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 200
17 matches
Mail list logo
