MySQL Table Crashed

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


ADVERTISEMENT

Table Marked As Crashed.

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

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

Mysql/user Is Marked As Crashed

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

Mysql: Copying To Tmp Table

May 18, 2009

mysql: Copying to tmp table, what causes that?

My server is majorly overloading and mysql is atop the cpu, and when I do a processlist there are about 20 copying to tmp table processes.

View 3 Replies View Related

Optimizing Large MySQL Table

Nov 2, 2009

I optimized a mysql table of 2 million records and about 500MB.. it took about 15 minutes.. However, on the same DB now i have another huge table of 88 million records, it size is 2.2 GB and it has about 30 MB to optimize... my questions..

1.- How can I speed up the optimization process so it can take the less possible time? any tweaks to my.cnf?

2.- Should I repair it using phpmyadmin or just from the shell?

3.- Should I stop http traffic during this optimization?

This is a dedicated db mysql server that handles a large VB forum with 5-8 users online average:

Code:
Intel Xeon 3.2 x4 procs, 32 bits, 4 GB ram
/etc/my.cnf

Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
skip-bdb
query_cache_limit=1M
query_cache_size=48M
query_cache_type=1
max_connections=1200
interactive_timeout=100
wait_timeout=300
connect_timeout=10
thread_cache_size=128
key_buffer=48M
join_buffer=8M
max_allowed_packet=16M
table_cache=2036
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M

# Add
max_heap_table_size = 48M
tmp_table_size = 48M
low_priority_updates=1
concurrent_insert=2

[mysqldump]
quick
max_allowed_packet=16M

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

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries=/var/log/slow-queries.log

On the other side, i have the same hardware for the webserver..

View 2 Replies View Related

Deleted Columns_priv Table MySQL

Jun 24, 2009

I accidentally deleted the columns_priv table in mysql database. How can I bring it back can anyone show me the structure of that table so I can build it back.

View 4 Replies View Related

Mysql: Incorrect Key File For Table

Apr 20, 2009

I have a server with many db on mysql 5

Any db contains 5 table with data

This data is processed by routine

Many time routine die with the error:
"Incorrect key file for table '/var/tmp/#sql_3018_0.MYI'; try to repair it"

The table sql_3018_0.MYI not exist, think that this is refered to a temporary table but is deleted by process..

View 1 Replies View Related

MYSQL Incorrect Key File For Table

Jul 3, 2008

what I can do about the following database error in mysql?

Incorrect key file for table '/tmp/#sql_(number of table.MYI); try to repair it

I've repaired, optimized and checked the database in phpmyadmin. Initially 2 tables were showing overhead, but the error message is for a temp table and I'm not sure how to try to repair a temp table.

View 5 Replies View Related

How To Alter Tabel And Create Table In Mysql

Jun 24, 2009

I have a script and there are some modifications that I want to make

In the instructions it says ALTER TABLE and CREATE TABLE in myqsl but I dont know exactly how to do this.

I have tried to google but everything i find is very technical and doesnt explain the easiest way to do it.

Should I use phpmyadmin or whats the correct way?

View 5 Replies View Related

Mysql Disable INSERT Access To Specific User/table

Apr 26, 2009

How can I disable INSERT access to specific table.

The user should have full access the the DB except insert to specific table.

The tables_priv allow to set what enable and not what disable.

I'm using mysql v5

View 4 Replies View Related

Server Crashed

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

Server Crashed

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

Apache Crashed - Any Ideas?

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

Phpmotion Causes Server Crashed

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

DNS Server Crashed - Rebooting Has No Effect

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

Retrieve Data From Crashed Server

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

Recover Data From Crashed Server

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

Server Crashed: Kernel Panic

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

Apache :: Crashed WAMP Server - Cannot Load

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

Plesk 12.x / Linux :: After Reinstalling MTA / Postfix Crashed?

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

Server Hard Disk Crashed Badly, How To Recover It

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

Plesk 12.x / Linux :: DNS Server Crashed Failed To Start

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

Plesk 11.x / Windows :: How To Restore Data From Crashed Hard Disk - 11.5.3

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

How To Run OPTIMIZE TABLE

Mar 25, 2009

Today i need to run "OPTIMIZE TABLE" from MySQLTuner recommendation.

Now i don't know how to run it ? I try to put in SQL Query via phpmyadmin and:

SQL query:

OPTIMIZE TABLE

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

View 5 Replies View Related

Full BGP Table

Apr 19, 2007

Can i expect a 7204VXR NPE-300 router with 256Meg to hold a full BGP table?

Would it be possible to hold to full BGP tables (multihoming) with a NPE-400 with 512Meg?

View 9 Replies View Related

Attachment Table

Oct 21, 2007

I have a site running on vps and the attachment table got crashed , I am unable to repair it :

thesymbi_vb.attachment
error : Not enough memory for blob at 605100 (need 6315809)
warning : Number of rows changed from 4 to 3081
status : OK

This is result of repairing from WHM, how to repair it?

View 5 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







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