/var/log/mysql - Can I Delete It

Jul 22, 2007

Question: Is it safe to delete the files in /var/log/mysql ? Also, is there some way I can disable logging so that this folder does not get filled up again?

Explanation:

Last night I started running a Perl script to process the data contained in some files, and then do a series of INSERTs to put them in a MySQL database. When I checked on it this morning, I found that it was very close to being done, but had locked up. I had trouble doing anything at all, actually, until I realized that 100% of the disk space on my hard drive had now been used. I went to investigate, and I quickly realized that my /var/log/mysql folder was over 120GB!

My intuition tells me that this folder is just used to store logs of what MySQL is doing. However, I have no need for these logs, and seeing as they are (unnecessarily) using over 120GB of my hard drive space, I would like to delete everything in that folder. But I'm still fairly new to Linux, and I'm not sure if this is safe. Can I just delete these files? And also, to prevent this from happening again, is there some way I can disable MySQL from creating such enormous log files?

View 12 Replies


ADVERTISEMENT

How To Delete Some Crashed/messy MySQL DB

May 9, 2009

When I try to remove a DB it is giving this error into phpMyAdmin:

#1051 - Unknown table 'seccion,anuncio,lengua,ciudad,email'

After mysql check the errors are:

Repairing tables
user_db.anuncio
error : Table 'user_db.anuncio' doesn't exist
user_db.ciudad
error : Table 'user_db.ciudad' doesn't exist
user_db.email
error : Table 'user_db.email' doesn't exist
user_db.lengua
error : Table 'user_db.lengua' doesn't exist
user_db.seccion
error : Table 'user_db.seccion' doesn't exist
user_dbTest.anuncio
error : Table 'user_dbTest.anuncio' doesn't exist
user_dbTest.ciudad
error : Table 'user_dbTest.ciudad' doesn't exist
user_dbTest.email
error : Table 'user_dbTest.email' doesn't exist
user_dbTest.lengua
error : Table 'user_dbTest.lengua' doesn't exist
user_dbTest.seccion
error : Table 'user_dbTest.seccion' doesn't exist

How this can be fixed and the MySQL DB to be dropped ?

View 6 Replies View Related

I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working

May 8, 2009

Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.

Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..

View 4 Replies View Related

Delete VPS From Hypervm

Apr 1, 2009

i've created VPS with OpenVZ.And there is some problem i have access the vps and it's show some error

Code:
VM creation has failed. Reason: Private area already exists in /vz/private/250
.At the moment i forgot my SSH details..only i know my hypervm "root" details..where i log with admin password.I need to fix this because some clients of my hosting company is waiting and my number of VPS is limited.

View 8 Replies View Related

Cant Delete Files

Jul 12, 2009

im try to delete some file from cpanel but everytime i delete nad refresh they come back
also if i try to change the perms it does not let me?

View 14 Replies View Related

How To Delete A Directory Through Ssh

Aug 20, 2008

I'm trying to use SSH to delete a directory. It won't delete via FTP.

I've tried variations of the below but nothing seems to work;

rm -f [folder]
rm /-f [folder]

the directory that should be deleted is test.crossroadsclub.net, so I use that as the folder.

View 5 Replies View Related

Can I Delete Mysqld.log

Dec 13, 2008

Can I delete mysqld.log

Can I delete or empty mysqld.log

Its currently 850MB

If I can do I have to stop MYSQL first;?

View 6 Replies View Related

How To Delete Files

Aug 13, 2008

i have installed the Domain Technologie Control Panel on Debian Etch, and have 2 folders that will not delete via FTP

I was wondering if anyone had a tutorial or could tell me how to be able to delete them....

View 14 Replies View Related

Delete /dev/sda4

Jul 14, 2008

[root@d7 ~]# fdisk -l

Disk /dev/sda: 160.0 GB, 160041885696 bytes
255 heads, 63 sectors/track, 19457 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 57 457821 83 Linux
/dev/sda2 58 15355 122881185 83 Linux
/dev/sda3 15356 15616 2096482+ 82 Linux swap / Solaris
/dev/sda4 15617 19457 30852832+ 8e Linux LVM

i want removed/deleted /dev/sda4

View 2 Replies View Related

Can We Delete Sql Logs

Jul 7, 2008

Can we delete sql logs ? as it occupies 2.97gb

All the log is under a single file, occupying huge amount of space on our server
use lxadmin for the vps

we are unable to even open up the file, as we have almost run out of space, we would atleast like to delete around old logs older than a month, this logs are from 3 months, so please help us in solving this problem

if we delete the sql log, will a new log be created automatically or it gives an error?

View 13 Replies View Related

Nobody Folders And Delete

Jun 29, 2008

when people run a forum and the template and forumdate folders may created some files with nobody permission,

the user could not delete them by the user themself,

and need admin login as root with ssh to delete those,

and let the files permission can run as the user instead of nobody.

the server is centos with cpanel and suexec.

View 5 Replies View Related

Delete Command

Feb 24, 2008

can i activate the deletion command for 10 or 30 mins and then stop it? i think by this way we cant delete some files from the dir and not all the files so i can edit my files

i want to do this because my server doesnt respond to any file system command because my hardisk is full! so i need to remove some files by any way

View 13 Replies View Related

Can I Delete These Folders From My Ftp

Mar 17, 2007

I heard the following folders were used by frontpage.

_private
_vti_bin
_vti_cnf
_vti_log
_vti_pvt
_vti_txt

I was wondering can i delete these folders if i'm not using frontpage ?

View 4 Replies View Related

Delete Files In /var/log

Aug 3, 2007

I am currently freeing up some space on my VPS and want to know if it ok for me to delete the following files in: /var/log/

apf_log.3
apf_log.4
boot.log.3
boot.log.4
cron.3
cron.4
exim_mainlog.3.gz
exim_mainlog.4.gz
exim_paniclog
exim_paniclog.3.gz
exim_paniclog.4.gz
exim_rejectlog.3.gz
exim_rejectlog.4.gz
maillog.3
maillog.4
messages.3
messages.4
rpmpkgs.3
rpmpkgs.4
secure.3
secure.4
spooler.3
spooler.4

View 2 Replies View Related

Delete A Cronjob Via SSH

Mar 23, 2007

I have a cronjob that is still entered in my server, but due to my own lack of knowledge i deleted the domain from my server without removing the cronjob and now i keep getting the emails from my server

Code:
/bin/sh: line 1: /home/userID_Removed/public_html/cgi-bin/script-removed/cron.cgi: No such file or directory
I just need to know how to remove the cronjob via SSH, i logged in as Root to my SSH and then did crontab -l and I see the two cronjobs I want to remove, but can't find the code to do so anywhere via Google.

There is 3 total that I want to remove but there is about 10 cronjobs setup there so i want to remove those three and make sure the other 7 stay running as they should.

View 2 Replies View Related

My.cnf Have Delete The Table

May 9, 2007

i have update my.cnf with the following configuration and now i have a lor of customer that have lost him table, seem that this configuration have delete in random .Myi files, i would put this my.cnf also on others server but i would undestand which setting in this .cnf make problem for the table.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
#skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=96M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=384M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=3M ## 1MB for every 1GB of RAM
read_buffer_size=3M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=3M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=2
collation-server=latin1_general_ci

[mysql.server]
user=mysql
#basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

View 3 Replies View Related

How To Delete None Empty Dir

Jan 28, 2007

I am trying to delete none empty directory using this command...

rmdir dirname

but system say directory not empty.. how I can delete directory with all directory/files under it

View 1 Replies View Related

How To Delete Backup Files

Oct 25, 2009

I have files on offsite backup from a previous server - I can login via putty ot winscp.

Putty login shows:

Quote:

FreeBSD 6.1-RELEASE-p3 (BACKUP3)

i want to delete them all - how can I do this in the most secure manner with the access I have?

View 9 Replies View Related

Unable To Delete Folders In Ftp

Mar 28, 2009

im using fireftp and i chmod the folders to 777 but it seems that im still unable to delete the folders as i get the message 550 directory not empty etc.

View 9 Replies View Related

How Can I Delete Much Emails In Cpanel

Apr 27, 2008

my control panel is: Cpanel

when somebody send me a wrong email , that will go to my Default address

example , my website name is : "test.com" and my website user : "test"

now , if somebody send a mail to 4444442342343@test.com that mail will go to my default address: " test "


i have a 50.000 emails in my default address

how can i delete complete that emails?

is there anyway for delete much email?

View 7 Replies View Related

Delete Everything On Server Before Cancelling

Mar 21, 2008

I am currently transferring from a VPS to a dedicated server.

After you have made the transition, do you delete everything on your previous server? Or can I expect that everything be deleted anyway when my subscription runs out?

I bring this up because there sometimes is sensitive data stored there (ie. databases with personal info) and I'm wondering how much I should delete. Obviously I'll get rid of the DBs, but what about essential stuff like the operating system?

View 5 Replies View Related

Safe To Delete These Files

Feb 12, 2008

I am running my VPS on direct admin panel, my disk space is going low, so i am deleting few junk / log files

Kindly let me know

1) is it safe to delete data of this directory -

/var/log/httpd/domains

The File names in above directory are such as - " domain.com.bytes "

As it is occupying 600 MB space

2) where can i delete much junk / temp files, to free up space.

View 5 Replies View Related

WHM: Can You Delete Entries In SSL Key/Crt Manager

Aug 14, 2008

how to delete the excessive SSL keys / CRT's from WHM?

I have so many of these freakin' things (from doing it WRONG the first few times) that I want to clean it up.

how do you clear out the KEYS / CRTS / Signing Requests from WHM?

View 3 Replies View Related

DOS/Cmd.exe Command To Delete Subdir

May 22, 2008

and its file.

i tried del c: emp*.*

but that didn't work and if i try rmdir c emp, it removed c: emp directory or maybe i'm not looking hard enough.

basically i want to copy a folder with many subdirectory under it, zip it up the folder and delete all the subfolder and the files in the subfolder but not the parent folder where it store all temp data.

i already got xcopy and zipping work but i can't seem to figure out how to remove all the folder inside the parent folder without deleting the parent folder.

i'm creating a batch file to run this task.

View 1 Replies View Related

Plesk Not Delete Domain

May 27, 2007

When i try to erase a domain from the Plesk it can't be erased and it gives the following error, i have read a lot of writings about this problem but i still didn't succeed. When at last i tried to erase it again it gave the following problem.

Error;
Domains not delete : Problems occured while removing domains: Unable to turn
the domain OFF: domainsmng failed : Execute usermng access off failed : Unable to get the user (kenthosting)
home: (2221) The user name could not be found

View 8 Replies View Related

Delete Mails In Exim

Dec 30, 2007

I read this post:
[url]

I should delete older than 5 days emails, how can I do it? (on cpanel and exim)

View 5 Replies View Related

How To Delete Specific Files

Oct 10, 2007

In one folder, I have thousand of files, and I want to delete 100 specific files. Saying specific files, I mean all of them has a keyword. So, I can find out all of them by using
grep "keyword" *

but dont know how to delete all of them. Not deleting one by one.

View 2 Replies View Related

Secure Delete Data On HDD

Jun 14, 2007

we've just moved to a new server and was wondering if there was any programs to secure erase all data on the hard drive on the old server (with centOS), as we don't want anyone else who get this harddrive to be able to recover any data.

I'm not that familiar with the file systems used by linux, so perhaps this isn't a problem. Just had to ask.

We use some DoD "approved" applications to remove sensitive data on NTFS partitions on our stationary computers, but couldn't find anything for *nix.

View 4 Replies View Related

How Can I Delete All The Rabbish Mails

Mar 9, 2007

one of my domainname has got too many crap emails. i want to delete all emails under that domain name..
emails like

Quote:

ur/1147413032.H680181P13997.myserver.***.com:2,
/home/***/mail/cur/1146844476.092499.mbox:2,
/home/***/mail/cur/1156427256.H96385P5958.myserver.***.com:2,
/home/***/mail/cur/1155811341

im on cpanel + centos how can i delete on ssh or whatever...

View 1 Replies View Related

FTP: User Cannot Delete Files, Etc.

Aug 20, 2007

I'm having a problem with one of my users on my box. For some reason they cannot delete files or change permissions and sometimes while uploading, it says the server has reset.

I haven't had any issues myself but what could be causing this?

I am using a Linux Fedora 4.0 box with Cpanel.

View 14 Replies View Related

DNS Zone Delete At WHM By Mistake.

Jan 1, 2007

We delete DNS zone of one of our domains at whm by mistake now that domain is not in account list ..how can i add this domain to WHM account list again,

adding dns zone option in WHM did not reslove the problem...

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved