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
ADVERTISEMENT
Sep 28, 2007
Table '231_message' is marked as crashed and should be repaired
I haven't ever had this happen, is all my data truely lost or can i 'repair' it
i was moving sites to a different server (VPS -> dedicated) and on the vps i have a max of 20gb storage, well as i was using the cpanel transfer it filled this up because it didnt have a warning about this (i dont accept blame )
either way it seemed at this time someone on my site tried to make an adjustment to the table and it crashed it since there wasnt room? i really need to get this fixed asap so I can properly move this site with a working database
View 5 Replies
View Related
Jan 30, 2007
I am trying to start mysql but i am getting the following error
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL................................... [FAILED]
I checked my hostname.err file in /var/lib/mysql and this is the error message it shows.
070130 17:59:41 mysqld started
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 mysqld ended
how I would repair that to get mysql to start again?
View 7 Replies
View Related
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
View Related
Mar 9, 2007
my linux server crashed today. I found these are the last line in the log
file just before i crashed.
Mar 8 07:21:00 myserver xinetd[5376]: warning: can't get client address:
Connection reset by peer
Mar 8 07:21:13 myserver xinetd[5395]: warning: can't get client address:
Connection reset by peer
View 1 Replies
View Related
Aug 14, 2007
I've been with 3 dedicated hosts since 2005 and my sever experienced the first ever crash yesterday. I wanna know if any of you have experienced a crash once and not have it happen again after that time. As this is the first occurence, I'm feeling uneasy about the server stability.
View 13 Replies
View Related
May 10, 2007
This morning, apache crashed on the server that I assist a friend of mine (junglecat here) with. We finally managed to get it up and going - for some odd reason, restarting apache/httpd via Cpanel wouldn't get it going, but SSHing and typing via command line would.
I downloaded the apache error log, and it's CHOCK full of this, repeating over and over (and over) again:
DBD::mysql:t bind_columns failed: Statement has no result columns to bind (perhaps you need to successfully call execute first) at email.pl line 55.
DBD::mysql:t fetch failed: fetch() without execute() at email.pl line 56.
Use of uninitialized value in concatenation (.) or string at email.pl line 59.
Use of uninitialized value in concatenation (.) or string at email.pl line 61.
Use of uninitialized value in concatenation (.) or string at email.pl line 76.
Have tried searching and either I'm not using the correct terms, or this doesn't happen that much (I am betting on the former). Any ideas?
View 5 Replies
View Related
Apr 5, 2009
I have a table that is showing
MySQL Error: 145 (Table './dollarpt_ptc/flinks' is marked as crashed and should be repaired)
I've repaired it via
mysqlcheck --repair --all-databases
that didn't work. I've tried
find /var/lib/mysql/* -name *MYI |xargs myisamchk -o -r
as well with no luck.
I then dropped the table and I still get the message. I know it's using the correct database, so any help would be appreciated.
It's like there is a table where this data is kept, but I've looked and can't find anything.
View 2 Replies
View Related
Jan 13, 2008
about a video sharing website.
I found phpmotion [url] and thinking about using this script, not only it is free but also it has the funtion that alow direct transfer video files from youtube to my server. Moreover, the phpmotion community is lovely.
The problem is that my hosting provider said this script is bad.
Quote:
While it will run on our servers I have heard nothing but bad things
about this software on our servers. For quite a while it has caused
issues to the point of crashing our servers but just recently (in the
last couple days) we have found ways to put limits on our systems which
should effect other programs/processes which will prevent this software
from crashing our servers so whether or not this would be ok to run on
our servers is a big *maybe* Alot of the issues appear to be related to
the fact the software runs php by executing it via shell using the php
executable which isn't really good considering that on our servers it
will always make it use php4 which might not be what your site is
running. PHPMotion is pretty much the only software I have heard
discussed and has caused major issues on our servers so if you could
avoid it I would definitely suggest you do! If you asked me about any
software which is reported to have/cause problems on our servers without
even mentioning phpmtion I would have answered phpmotion as that is the
only one I have heard of which causes tons of issues.
my questions are:
1. Do you have the same experiences with phpmotion?
2. How can I reduce the problem?
3. If phpmotion is really bad, which video sharing script should be recommended?
View 11 Replies
View Related
Oct 25, 2008
I'm hosting proxy sites on my vps and untill yesterday my proxy worked fine with no problems at all.
But while going trough my server graphs I found it odd that I had 0 bandwidth since the middle of yesterday.. I first supposed that this was due school's out [url]but this wasn't the reason I found out!
I tried testing one of my proxies to see if it was still working, but with any URL I try to visit I get:
The requested resource could not be loaded. libcurl returned the error: Couldn't resolve host 'www.google.com'
I suppose the DNS server crashed?
I already restarted the VPS 3 times including the DNS Server.
View 12 Replies
View Related
Jan 27, 2007
Does anyone know of any services that can help retrieve data from a crashed server. The server is managed but the support are saying that they are having problems retriving the data. The server had an os reload and they can't slave the old disk.
View 2 Replies
View Related
Mar 2, 2007
I have a crashed HD that I want to recover the data. I wonder if there is any method or software out there that can do this for me.
The hard drive is installed with centos and uses ext3 filesystem.
I have tried doing a mount, not if it is done correctly, but I only see "lost+found" on the hard drive.
Usually when this happens on my hard drive w/ windows, I use some data recovery software to extract the data. I don't know which software will do this for me on an ext3 filesystem running centos.
View 4 Replies
View Related
Mar 23, 2007
Today my server just crashed instantly... It was running fine with a load of 0.12 but then it went down all the sudden. After a reboot I checked the /var/log/messages file and saw this:
Code:
Mar 23 15:57:00 alpha kernel: Unable to handle kernel NULL pointer dereference at virtual address 00000020
Mar 23 15:57:00 alpha kernel: printing eip:
Mar 23 15:57:00 alpha kernel: c017292b
Mar 23 15:57:00 alpha kernel: *pde = 2085d001
Mar 23 15:57:00 alpha kernel: Oops: 0000 [#1]
Mar 23 15:57:00 alpha kernel: SMP
Mar 23 15:57:00 alpha kernel: Modules linked in: ipt_TOS iptable_mangle ip_conntrack_ftp ip_conntrack_irc ipt_LOG ipt_limit ipt_multiport ipt_state ip_conntr
ack ipt_owner ipt_REJECT iptable_filter ip_tables autofs4 i2c_dev i2c_core sunrpc md5 ipv6 dm_mirror dm_mod button battery ac uhci_hcd ehci_hcd e1000 floppy
ext3 jbd ata_piix libata sd_mod scsi_mod
Mar 23 15:57:00 alpha kernel: CPU: 0
Mar 23 15:57:00 alpha kernel: EIP: 0060:[<c017292b>] Not tainted VLI
Mar 23 15:57:00 alpha kernel: EFLAGS: 00010246 (2.6.9-42.0.3.ELsmp)
Mar 23 15:57:00 alpha kernel: EIP is at dnotify_flush+0xe/0x70
Mar 23 15:57:00 alpha kernel: eax: c0446c40 ebx: ca05dd80 ecx: 0046ef00 edx: f1d95300
Mar 23 15:57:00 alpha kernel: esi: 00000000 edi: ca05dd80 ebp: f1d95300 esp: eb3f3fa0
Mar 23 15:57:00 alpha kernel: ds: 007b es: 007b ss: 0068
Mar 23 15:57:00 alpha kernel: Process httpd (pid: 28057, threadinfo=eb3f3000 task=efaf03b0)
Mar 23 15:57:00 alpha kernel: Stack: ca05dd80 00000220 f1d95300 eb3f3000 c015a7e5 0000020f bff65b64 bff65af0
Mar 23 15:57:00 alpha kernel: c02d47cb 0000020f 0046eff4 08cd4e6c bff65b64 bff65af0 bff615b8 00000006
Mar 23 15:57:00 alpha kernel: c02d007b 0000007b 00000006 0032a7a2 00000073 00000246 bff61598 0000007b
Mar 23 15:57:00 alpha kernel: Call Trace:
Mar 23 15:57:00 alpha kernel: [<c015a7e5>] filp_close+0x49/0x5f
Mar 23 15:57:00 alpha kernel: [<c02d47cb>] syscall_call+0x7/0xb
Mar 23 15:57:00 alpha kernel: [<c02d007b>] packet_rcv+0x17e/0x307
Mar 23 15:57:00 alpha kernel: Code: 00 89 c3 85 d2 74 0e 8b 42 04 8b 12 25 ff ff ff 7f 09 c1 eb ee 89 8b 34 01 00 00 5b c3 55 89 d5 57 89 c7 56 53 8b 40 08 8
b 70 10 <0f> b7 46 20 25 00 f0 00 00 3d 00 40 00 00 75 4d 8d 46 68 e8 fb
Mar 23 15:57:00 alpha kernel: <0>Fatal exception: panic in 5 seconds
Mar 23 16:06:46 alpha syslogd 1.4.1: restart.
So it seems like httpd crashed my server? I checked the Apache error_log and noticed lines like these:
Code:
*** glibc detected *** free(): invalid pointer: 0x08872c98 ***
[Fri Mar 23 15:57:03 2007] [error] [client x.x.x.x] Premature end of script headers: /home/user/public_html/forum/index.php
[Fri Mar 23 15:57:03 2007] [error] [client x.x.x.x] File does not exist: /home/user/public_html/500.shtml
When I look at the whole error_log it seems like such errors appear frequently and for different websites and PHP applications. This isn't the only glibc error, there's also stuff like "*** glibc detected *** corrupted double-linked list: 0x088e0bb8 ***". I have recently installed eAccelerator and searched the web: I'm not the only one who has such problems with eAccelerator. Do you think these glibc errors may have caused the server to crash?
Also, lately I noticed a lot of lines like these in the /var/log/messages file:
Code:
Mar 23 15:47:45 alpha kernel: post_create: setxattr failed, rc=122 (dev=sda7 ino=4318565)
and
Code:
Mar 23 15:50:56 alpha ntpd[2958]: sendto(66.111.46.200): Operation not permitted
I've done some Google'ing on the first error and it seems like someone with the same error got it fixed by running a filesystem check... By the way /dev/sda7 is my /home directory. But in order to run a filesystem check I need to disable all services and unmount /home? That's kind of a pain in the ***... In general, how long do you think it takes to run a filesystem check? Here's information about my /home partition:
Code:
/dev/sda7 198G 71G 118G 38% /home
View 6 Replies
View Related
Jun 26, 2013
I'm running a WAMP server, hosting an internal website for my company's use.
Windows XP Home SP3
Apache 2.0
MySQL Server 5.5
PHP 5.?
Last night Microsoft Security Essentials froze while running a scan. I restarted the scan and it froze again, so I rebooted the server. Now Apache won't start, providing the following error ....
View 4 Replies
View Related
Jul 19, 2014
after reinstalling the mta / postfix / smtp (because I couldn't send mails) my plesk is crashed.
I wanted to log in as admin but it doesn't accept my PW. Now with root and then it wants me to accept the license.
Now I copy all my /var/www/vhosts/ maybe when I do the setup steps in plesk it will overwrite all my website content... I hope not all plesk settings are away.
Why I pay every month money for a license? The trouble and work I have with Plesk..
View 4 Replies
View Related
Oct 5, 2008
My server hard disk is crashed badly. The rescue function in the server cannot take part and so I've tried using some recovery software to get back my data.
I've tried using Easy Recovery Professional. It sort all the files by it file type into different folder. I found a folder named .DB, there are also some .ado and . ldb folder too. I guess one of it is my database. The problem now is, i dunno how to read the file.
Do you have any idea to read it? I've tried many recovery system. eg. DiskInternals Linux Recovery, Disk Doctor Linux Recovery.
it is a linux server
View 8 Replies
View Related
Jun 22, 2015
It seems the servers dns will not resolve and has crashed. When starting the "Named" service, here is the error:
Error in named configuration:
zone 0.0.127.IN-ADDR.ARPA/IN: loaded serial 20010622
zone 215.170.107.in-addr.arpa/IN: loaded serial 1433121512
zone lanewgirl.com/IN: NS 'ns.mydomain.com' has no address records (A or AAAA)
zone mydomain.com/IN: not loaded due to errors.
_default/mydomain.com/IN: bad zone
zone mydomain2.com/IN: NS 'ns.mydomain2.com' has no address records (A or AAAA)
zone mydomain2.com/IN: not loaded due to errors.
_default/mydomain2.com/IN: bad zone
View 3 Replies
View Related
Jul 31, 2013
My windows server's hard disk was crashed & now I have mounted it as secondary hard disk on the server .
Now I want to restore the data to new server .
View 6 Replies
View Related
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
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
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
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
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
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
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
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
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
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