yyyc186
April 29th, 2008, 03:34 AM
I have an SQL script I've been running for quite a while on Ubuntu 7.10 with no problems. After being forced into a clean install by the "upgrade" process scrambling 7.10 beyond use, I recreated the database and attempted to load the raw data from a CSV file. This is a task I've done hundreds of times.
load data infile '/home/roland/mega_mysql/drawing_data.csv'
into table drawing_data
fields terminated by ','
lines terminated by '\n'
(draw_dt, no_1, no_2, no_3, no_4, no_5, mega_no);
Now when you try to run this script, it gets the dreaded error 13 (access). Doesn't matter how you set the properties for the CSV file, the parent directory, or the home directory. Throwing all protection to the wind still gives you the dreaded error 13.
Something got really hosed with permissions and protections with this release. Might be the source of other problems.
load data infile '/home/roland/mega_mysql/drawing_data.csv'
into table drawing_data
fields terminated by ','
lines terminated by '\n'
(draw_dt, no_1, no_2, no_3, no_4, no_5, mega_no);
Now when you try to run this script, it gets the dreaded error 13 (access). Doesn't matter how you set the properties for the CSV file, the parent directory, or the home directory. Throwing all protection to the wind still gives you the dreaded error 13.
Something got really hosed with permissions and protections with this release. Might be the source of other problems.