deleting file created from mysql | Unix Linux Forums | Web Programming

  Go Back    


Web Programming Discuss Web Programming and Web Server Administration, including LAMP, Apache, MySQL, HTML, SEO, and other Web APIs and topics.

deleting file created from mysql

Web Programming


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 07-28-2008
DILEEP410 DILEEP410 is offline
Registered User
 
Join Date: Dec 2006
Last Activity: 29 August 2013, 9:16 PM EDT
Posts: 153
Thanks: 0
Thanked 0 Times in 0 Posts
Question deleting file created from mysql

Hi,
I executed the query in mysql as
"select * into outfile "/tmp/result.out" from table_x;

which inturn wrote all the records in that table to file in /tmp directory.After this i tried to delete the file "/tmp/result.out", but can't able to do that.
Is there any way to achieve this.Please suggest

Your help is appreciated

Regards
Dileep
Sponsored Links
    #2  
Old 07-28-2008
sysgate's Avatar
sysgate sysgate is offline Forum Advisor  
Unix based
 
Join Date: Nov 2006
Last Activity: 20 November 2013, 8:29 AM EST
Location: Bulgaria
Posts: 1,419
Thanks: 0
Thanked 6 Times in 6 Posts
What is the error message when have tried to delete the file ? What is the OS and you root ? Most probably you don't have rights to delete the file, do a 'ls -la' on the file and check the permissions.
Sponsored Links
    #3  
Old 07-29-2008
DILEEP410 DILEEP410 is offline
Registered User
 
Join Date: Dec 2006
Last Activity: 29 August 2013, 9:16 PM EDT
Posts: 153
Thanks: 0
Thanked 0 Times in 0 Posts
Java

Hi,

The file created with the permissions as
-rw-rw-rw- 1 mysql mysql 432 2008-07-28 14:36 result.out

I know that it is not possible to delete the file from my login, but from mysql it is supposed to delete it, right.

I tried the below command from mysql, that too failed with the error message

mysql> system rm /tmp/result.out
rm: cannot remove `/tmp/result.out': Operation not permitted

I am looking out for something like the UTL_FILE package in Oracle which have the capability to create,rename,delete operations on the files it creates...Can anyone suggest

With Regards
Dileep Pattayath
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
MySQL Daemon failed to start - no mysql.sock file jastanle84 UNIX and Linux Applications 3 10-12-2011 02:56 PM
how to delete core file (file created due to apps crashed) s3270226 Homework & Coursework Questions 6 04-07-2011 12:13 PM
Deleting databases in MYSQL problem asking... patrick87 Web Programming 3 02-05-2010 01:56 AM
How to know when a new file is created? aixjadoo UNIX for Dummies Questions & Answers 1 07-02-2008 12:11 PM
Deleting files created before two days ago josecollantes UNIX for Dummies Questions & Answers 3 02-21-2002 11:05 AM



All times are GMT -4. The time now is 05:27 AM.