Zen Cart Logo
Forums / General Questions / Ok to remove/empty unused sql authorizenet?

Ok to remove/empty unused sql authorizenet?

Views: 521

Results 1 to 4 of 4
17 Apr 2012, 6:08 PM
#1
divinelighting avatar

divinelighting

Zen Follower

Join Date:
Jun 2006
Location:
Atlanta, GA
Posts:
124
Plugin Contributions:
0

Ok to remove/empty unused sql authorizenet?

I'm making space on my server and don't want to cause problems. I found a file /mysql/DATABASE/authorizenet.MYD that is very large. It is 43mb and the 9th largest file/directory on my server.

I haven't used authorize.net in 2 years. Is it safe to empty this table?

17 Apr 2012, 6:32 PM
#2
divinelighting avatar

divinelighting

Zen Follower

Join Date:
Jun 2006
Location:
Atlanta, GA
Posts:
124
Plugin Contributions:
0

Re: Ok to remove/empty unused sql authorizenet?

Here is the whole path

var/lib/mysql/DATABASE/authorizenet.MYD

17 Apr 2012, 8:18 PM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Ok to remove/empty unused sql authorizenet?

YOUR POST IS SERIOUSLY ALARMING!!!!

If you have no history in it which you need to keep, then you can truncate the table.

**BUT DO NOT EVER delete .MYD files by hand!!!!!!!! Seriously. YOU SHOULD NOT BE MUCKING AROUND IN THAT FOLDER AT ALL!!!!!!!!!
**If you're going to delete data associated with a given table, then make a solid reliable backup and truncate the table using phpMyAdmin. DO NOT DELETE MYSQL DATABASE FILES DIRECTLY!!!!!!! EVER!!!!!!

17 Apr 2012, 11:31 PM
#4
divinelighting avatar

divinelighting

Zen Follower

Join Date:
Jun 2006
Location:
Atlanta, GA
Posts:
124
Plugin Contributions:
0

Re: Ok to remove/empty unused sql authorizenet?

10-4. I wouldn't delete any file associated with the database. I know that would be a major FAIL. I just put the path there because I wasn't really sure what I was looking it. Thanks for clearing it up.