View Full Version : Cannot remove RSS files from htdocs
Want to completely clean out all my RSS files and start over. Problem is, trying to delete these files from the htdocs doesn't work...even though a"delete successful" message is displayed.
Tried to locate the files in My SQL...not much luck with that either since I know very little about SQL & PHP. How can I delete these files without causing other problems?...will clicking on "Drop" while in My SQL do the trick?
Thanks.
The "drop" command will remove the table completely. You probably don't want to do that as you will probably break alot of things. There is an "empty" command that does what you're thinking of which is remove all the individual entries in a table.
However, that probably isn't the problem. What RSS files are we talking about? What are they doing in the database in the first place? Are you using some sort of RSS generator? Details please~ show us the table structure of the table you want to empty.
Didn't want to weigh you down with this but here's the reason I want to delete my RSS feed from MYSQL:
The RSS feed was generated using software called Orange Box. It worked well for months until one day when I wanted to do some editing, I was redirected to a page notifying me that my feed has been encoded using Ion Cube encoder and I would need an IonCube player to display the feed.
I went to my htdocs, opened the RSS folder and discovered 31 IonCube files, most of them "loader" files...files that did not exist when the above OB software was working OK. I have no idea where these files came from or who placed them in the RSS folder. I immediately changed my passwords.
The point is, I need to get all this crap out of MYSQL and create a new RSS feed. Am not using MYSQL for anything else (that I'm aware of.) There are 2 tables...rss_feed and rss_channel. Table structure follows:
************************************************** *******************
rss_feed
Field Type Null Default
entry_id int(7) No
entry_title varchar(100) No
entry_link varchar(200) Yes NULL
entry_content text No
entry_date varchar(50) Yes NULL
entry_author varchar(100) Yes NULL
entry_comments varchar(200) Yes NULL
entry_channel varchar(128) Yes NULL
Indexes: Keyname Type Cardinality Field
PRIMARY PRIMARY 10 entry_id
entry_id INDEX 10 entry_id
entry_channel_2 INDEX 2 entry_channel
entry_channel_3 INDEX 2 entry_channel
entry_channel_4 INDEX 2 entry_channel
entry_content FULLTEXT 1 entry_content
entry_title FULLTEXT 1 entry_title
entry_content_2 FULLTEXT 1 entry_content
entry_content_3 FULLTEXT 1 entry_content
entry_title_2 FULLTEXT 1 entry_title
entry_channel FULLTEXT 1 entry_channel
entry_channel_5 FULLTEXT 1 entry_channel
Space usage: Type Usage
Data 2,328 Bytes
Index 21,504 Bytes
Total 23,832 Bytes
Row Statistics: Statements Value
Format dynamic
Rows 10
Row length ø 232
Row size ø 2,383 Bytes
Next Autoindex 22
Creation Nov 30, 2004 at 01:54 PM
Last update Jan 04, 2006 at 02:48 PM
Last check Jan 04, 2006 at 02:48 PM
************************************************** ************************************************** **
rss_channel
Field Type Null Default
id int(7) No
cname varchar(128) Yes NULL
clink varchar(128) Yes NULL
cdescription text Yes NULL
cnum int(7) Yes NULL
cimgsrc varchar(128) Yes NULL
clang varchar(128) Yes NULL
ceditor varchar(128) Yes NULL
ccopyright varchar(128) Yes NULL
cttl varchar(128) Yes NULL
cfile varchar(128) Yes NULL
Indexes: Keyname Type Cardinality Field
PRIMARY PRIMARY 2 id
cdescription FULLTEXT 1 cdescription
cdescription_2 FULLTEXT 1 cdescription
Space usage: Type Usage
Data 548 Bytes
Index 6,144 Bytes
Total 6,692 Bytes
Row Statistics: Statements Value
Format dynamic
Rows 2
Row length ø 274
Row size ø 3,346 Bytes
Next Autoindex 4
Creation Dec 10, 2004 at 09:28 AM
Last update Jan 04, 2006 at 02:48 PM
Last check Jan 04, 2006 at 02:48 PM
************************************************** ***************************
Both of these tables have an "Empty" command. Hope this provides enough info to resolve my initial question.
Thanks for your help.
vBulletin v3.6.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.