Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


INTO OUTFILE Error 2


Login or Register to Reply

 
Thread Tools Search this Thread
# 8  
Don't leave people guessing, provide adequate info. Check your mysql manual:
- What does "ERROR 1" mean?
- What does "Errcode: 2" mean?


- What's the code in "line 1" that tries to "create/write" the files?



Do the necessary directories exist?
What be their permisions?
Can you create files in there by using shell commands?
Can other users create those files?
Show the results of your attempts.
# 9  
Here is a link to the error codes:

MySQL :: MySQL 5.6 Reference Manual :: B.3.1 Server Error Message Reference


Code:
Error number: 1002; Symbol: ER_NO; SQLSTATE: HY000

Message: NO

Used in the construction of other messages.

Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Solaris 10 error "-sh: /tmp/outfile: cannot create"
feroccimx
Hello, Each time a user log on to host, they receive below error: -sh: /tmp/outfile: cannot create Example: $ ssh host user@host's password: Last login: Fri Dec 4 08:17:28 2015 from client.ref |-----------------------------------------------------------------| -sh:...... Solaris
2
Solaris
Outfile
PerlNutt
Hi guys! So I have a program that allows the user to enter a file, change some characters (for example, a changes to t, etc.) and then save the new file under a new name. However, I need to press carriage return twice for the program to end. I was just wondering if anyone knew of a way for the...... UNIX for Dummies Questions & Answers
2
UNIX for Dummies Questions & Answers
print to more than one outfile AWK
dcfargo
I'd like to do an if / else if condition and print to different files. Something like: awk '{ if ($1 == "yes") print $2, $4 < infile > outfile1 ; else if ($1 == "No") print $2, $4 < infile > outfile2 }' Obviously I don't know the syntax. Thanks so much.... Shell Programming and Scripting
5
Shell Programming and Scripting
How to outfile contant as an input for a command
nitin_aaa27
I`m having output file which contain following no which changes every time i run script.The number given below are there in file and i have to fatch them from file. 12 15 56 158 365 165 598 568 265 256 258 now i want to use above number from output to input as $j r=`/omp/bin/ICIC...... UNIX for Dummies Questions & Answers
1
UNIX for Dummies Questions & Answers
Setting outfile with (brackets)
Pablo_beezo
I have a file that comes in as 20081002_invoices.txt and needs to go out as invoices(20081002).xls When ran this file should have three seperate fields as follows: column1 column2 column3 data1 data2 data3 when i run the script it produces the invoices(20081002).xls but moves...... Shell Programming and Scripting
1
Shell Programming and Scripting

Featured Tech Videos