Welcome to WebmasterWorld Guest from 126.96.36.199
For example, I have DIV and CLASS codes with quote marks (div id="fred" - p class="red") that I want to stay.
I've read through the mysql documentation and understand that I can set the fields-terminated-by, fields-enclosed-by and lines-terminated by with characters, but I can't find which characters are allowed. I also am not sure about doubling the quotes in order to keep them ("") or adding slashes (\"), or what.
I did a test run with phpmyadmin to add a simple four field test text file to a table I set up with phpmyadmin. I tried changing from the default field separators of ";" to "^" and record ends of "#". Nothing.
LOAD DATA LOCAL INFILE '#*$!/tmp/phpRIYxId' INTO TABLE `junktable` FIELDS TERMINATED BY '^' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '#'
The used command is not allowed with this MySQL version
The problem could be with the upload file process, but I still would like to know how to deal with quotes within my "fields" and what choices do I have for field separators and line ends.
I have a lot of data to add to the database and I want to prepare it right for importing. Thanks.
well when you insert data there are a bunch of ways to do it
creating and understanding the data to be inserted is the most important part.
>> I finally found a mediumly fast way to turn the html pages into raw data
What do you mean by raw data?
What exact format does it have?
<div id="fred><p>Blah Blah <a class="external" href="link.html">Link blah</a>....
that kind of thing.
How do I treat the quotes around the codes so they don't interfere with the import, and what are my choices for field and line breaks.
The code for which I tried to import the data is listed in the post above.
I read somewhere in all the millions of pages I've been reading on this subject for the past three weeks that I need FILE permission for something, and maybe this is one of the somethings. I went through my list of permissions and don't see a FILE to be selected. Is this why I might not be able to import my data to MySQL?
Thanks for the help. I've got a lot of work to do on this, especially stripping the "non-essential" (to the database) HTML code from everything to put it into the database. I want to prepare the data properly so it will whizbang right in there - no stress....ha ha.
SHOW VARIABLES LIKE 'local_infile [dev.mysql.com]';
Does that help?
The file I am trying to upload looks like this and is in a file called "test.txt"
I left the last line as one line to test the end record but I also tried the file with everything on one line.
The file structure is set up:
Field Type Null
name varchar(20) No
color1 varchar(20) No
color2 varchar(20) No
color3 varchar(20) No
This should work like a charm so I'm not sure what's going on.