MySQL crash!

Can't get CREATE TABLE for table 'user' (Can't open file: 'user.MYD'.

[Jesse_Smith]

Is there any way to fix this error? It's bombed me with around 3,000 E-mails today so far. This is with a vBulletin board.

***

[root admin]# mysqldump -uroot -pPASSWORD vgchat user > /home/sites/domain
m/web/back-ups/user.sql
mysqldump: Can't get CREATE TABLE for table 'user' (Can't open file: 'user.MYD'.
(errno: 145))

[root admin]# mysqldump -uroot -pPASSWORD vgchat > /home/sites/domain/web
/back-ups/6-66-03.sql
mysqldump: Can't get CREATE TABLE for table 'user' (Can't open file: 'user.MYD'.
(errno: 145))

phpMyAdmin gives out

user Browse Select Insert Properties Drop Empty
Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site4/web/phpMyAdmin/lib.inc.php on line 507

try to view it and it gives out

Database vgchat - table user
Error

SQL-query:

SELECT * FROM user

MySQL said: Can't open file: 'user.MYD'. (errno: 145)

[grahamstewart]

So have you checked that the user.MYD file exists and has the correct permissons?

[Jesse_Smith]

Telnet says

[root admin]# cat user.MYD
cat: user.MYD: No such file or directory

[Air]

It wouldn't be in your root. likely in /var/lib/mysql/your-databasename but it could be elsewhere, it depends on your MySQL config, check in /etc/my.cnf to see the MySQL config, it will give the path to the data directory.

Or just try:

find / -name user.MYD -print

[Jesse_Smith]

ARG! I think I got a lot of permission settings to change!

find: /var/lib/nfs/sm: Permission denied
find: /var/lib/nfs/sm.bak: Permission denied
find: /var/lib/slocate: Permission denied
find: /var/lib/pgsql/backups: Permission denied
find: /var/lib/pgsql/data: Permission denied
find: /var/log/samba: Permission denied
find: /var/spool/cron: Permission denied
find: /var/cobalt: Permission denied
find: /var/empty/sshd: Permission denied
find: /home/mysql/mysql: Permission denied
find: /home/mysql/vgchat: Permission denied
find: /home/mysql/webmasters: Permission denied
find: /proc/1/fd: Permission denied
find: /proc/2/fd: Permission denied
find: /proc/3/fd: Permission denied
find: /proc/4/fd: Permission denied
find: /proc/5/fd: Permission denied
find: /proc/6/fd: Permission denied
find: /proc/296/fd: Permission denied
find: /proc/305/fd: Permission denied
find: /proc/335/fd: Permission denied
find: /proc/347/fd: Permission denied
find: /proc/376/fd: Permission denied
find: /proc/381/fd: Permission denied
find: /proc/391/fd: Permission denied
find: /proc/413/fd: Permission denied
find: /proc/414/fd: Permission denied
find: /proc/443/fd: Permission denied
find: /proc/566/fd: Permission denied
find: /proc/589/fd: Permission denied
find: /proc/630/fd: Permission denied
find: /proc/684/fd: Permission denied
find: /proc/723/fd: Permission denied
find: /proc/729/fd: Permission denied
find: /proc/730/fd: Permission denied
find: /proc/8055/fd: Permission denied
find: /proc/9845/fd: Permission denied
find: /proc/9846/fd: Permission denied
find: /proc/9847/fd: Permission denied
find: /proc/9877/fd: Permission denied
find: /proc/9896/fd: Permission denied
find: /proc/9921/fd: Permission denied
find: /proc/9923/fd: Permission denied
find: /proc/9948/fd: Permission denied
find: /proc/9949/fd: Permission denied
find: /proc/9963/fd: Permission denied
find: /proc/9998/fd: Permission denied
find: /proc/9999/fd: Permission denied
find: /proc/10001/fd: Permission denied
find: /proc/23330/fd: Permission denied
find: /proc/27249/fd: Permission denied
find: /proc/7586/fd: Permission denied
find: /proc/20103/fd: Permission denied
find: /proc/23554/fd: Permission denied
find: /proc/23691/fd: Permission denied
find: /proc/29164/fd: Permission denied
find: /proc/6366/fd: Permission denied
find: /proc/9359/fd: Permission denied
find: /proc/9384/fd: Permission denied
find: /proc/9390/fd: Permission denied
find: /proc/9391/fd: Permission denied
find: /proc/20727/fd: Permission denied
find: /proc/22294/fd: Permission denied
find: /proc/24553/fd: Permission denied
find: /proc/24695/fd: Permission denied
find: /proc/25639/fd: Permission denied
find: /proc/26961/fd: Permission denied
find: /proc/27232/fd: Permission denied
find: /proc/30873/fd: Permission denied
find: /proc/30883/fd: Permission denied
find: /proc/31223/fd: Permission denied
find: /proc/31308/fd: Permission denied
find: /proc/31651/fd: Permission denied
find: /proc/31827/fd: Permission denied
find: /proc/32159/fd: Permission denied
find: /proc/32162/fd: Permission denied
find: /etc/default: Permission denied
find: /etc/locks: Permission denied
find: /root: Permission denied
find: /usr/doc/cgiwrap-3.7: Permission denied
find: /usr/doc/MySQL-3.23.54: Permission denied
find: /usr/lib/pgsql/backup: Permission denied
find: /usr/local/majordomo: Permission denied
find: /nsr/cores: Permission denied

[Air]

from the output it looks like the user.MYD file would be in /home/mysql/vgchat and as you can see the ID you used does not have permission on those files.

[Jesse_Smith]

When I try to get in that folder, it says it's not a reguler file.

[Air]

if you enter:

cd /home/mysql/vgchat

and then

ls -l

what do you get displayed?

BTW sorry about the basic commands, but I have no way of knowing where you're at with this stuff, so no offence intended ok ...lol

[Jesse_Smith]

It looks like they all have the same permission setting

-rw-rw---- 1 mysql root 189 Mar 4 12:27 access.MYD
-rw-rw---- 1 mysql root 2048 Mar 4 14:09 access.MYI
-rw-rw---- 1 mysql root 8624 Jan 17 16:13 access.frm
-rw-rw---- 1 mysql root 439740 Jun 11 06:49 adminlog.MYD
-rw-rw---- 1 mysql root 64512 Jun 11 07:32 adminlog.MYI
-rw-rw---- 1 mysql root 8750 Jan 17 16:13 adminlog.frm
-rw-rw---- 1 mysql root 20 Jan 17 16:13 adminutil.MYD
-rw-rw---- 1 mysql root 2048 Jan 17 18:12 adminutil.MYI
-rw-rw---- 1 mysql root 8580 Jan 17 16:13 adminutil.frm
-rw-rw---- 1 mysql root 2349 Jun 11 11:33 afterburner_sessions_day.
MYD
-rw-rw---- 1 mysql root 1024 Jun 11 11:33 afterburner_sessions_day.
MYI
-rw-rw---- 1 mysql root 8582 Jan 20 14:41 afterburner_sessions_day.
frm
-rw-rw---- 1 mysql root 4719 Jun 11 11:34 afterburner_stat.MYD
-rw-rw---- 1 mysql root 1024 Jun 11 11:34 afterburner_stat.MYI
-rw-rw---- 1 mysql root 8790 Jan 20 14:41 afterburner_stat.frm
-rw-rw---- 1 mysql root 10800 Jun 9 05:56 announcement.MYD
-rw-rw---- 1 mysql root 3072 Jun 10 08:48 announcement.MYI
-rw-rw---- 1 mysql root 8754 Jan 17 16:13 announcement.frm
-rw-rw---- 1 mysql root 0 Jan 17 16:13 attachment.MYD
-rw-rw---- 1 mysql root 1024 Jan 17 16:13 attachment.MYI
-rw-rw---- 1 mysql root 8754 Jan 17 16:13 attachment.frm
-rw-rw---- 1 mysql root 0 Jan 17 16:13 avatar.MYD
-rw-rw---- 1 mysql root 1024 Jan 17 16:13 avatar.MYI
-rw-rw---- 1 mysql root 8664 Jan 17 16:13 avatar.frm
-rw-rw---- 1 mysql root 1296 Jan 21 17:00 bbcode.MYD
-rw-rw---- 1 mysql root 2048 Apr 5 17:55 bbcode.MYI
-rw-rw---- 1 mysql root 8772 Jan 17 16:13 bbcode.frm
-rw-rw---- 1 mysql root 380 Jun 10 14:25 calendar_events.MYD
-rw-rw---- 1 mysql root 3072 Jun 10 14:28 calendar_events.MYI
-rw-rw---- 1 mysql root 8746 Jan 17 16:13 calendar_events.frm
-rw-rw---- 1 mysql root 0 Jan 17 16:13 customavatar.MYD
-rw-rw---- 1 mysql root 1024 Jan 17 16:13 customavatar.MYI
-rw-rw---- 1 mysql root 8658 Jan 17 16:13 customavatar.frm
-rw-rw---- 1 mysql root 134064 Jun 11 11:35 forum.MYD
-rw-rw---- 1 mysql root 2048 Jun 11 11:35 forum.MYI
-rw-rw---- 1 mysql root 9574 Jan 17 16:13 forum.frm
-rw-rw---- 1 mysql root 2145 Jun 9 00:32 forumpermission.MYD
-rw-rw---- 1 mysql root 3072 Jun 10 08:48 forumpermission.MYI
-rw-rw---- 1 mysql root 9266 Jan 17 16:13 forumpermission.frm
-rw-rw---- 1 mysql root 5684 Feb 21 16:09 icon.MYD
-rw-rw---- 1 mysql root 2048 Apr 5 18:58 icon.MYI
-rw-rw---- 1 mysql root 8616 Jan 17 16:13 icon.frm
-rw-rw---- 1 mysql root 5248 Jun 9 00:37 moderator.MYD
-rw-rw---- 1 mysql root 5120 Jun 10 08:48 moderator.MYI
-rw-rw---- 1 mysql root 9310 Jan 17 16:13 moderator.frm
-rw-rw---- 1 mysql root 96772 Jun 11 04:57 poll.MYD
-rw-rw---- 1 mysql root 9216 Jun 11 04:57 poll.MYI
-rw-rw---- 1 mysql root 8838 Jan 17 16:13 poll.frm
-rw-rw---- 1 mysql root 129822 Jun 11 04:57 pollvote.MYD
-rw-rw---- 1 mysql root 148480 Jun 11 04:57 pollvote.MYI
-rw-rw---- 1 mysql root 8690 Jan 17 16:13 pollvote.frm
-rw-rw---- 1 mysql root 27727460 Jun 11 11:35 post.MYD
-rw-rw---- 1 mysql root 4118528 Jun 11 11:35 post.MYI
-rw-rw---- 1 mysql root 9020 Jan 17 16:13 post.frm
-rw-rw---- 1 mysql root 2461284 Jun 11 11:25 privatemessage.MYD
-rw-rw---- 1 mysql root 139264 Jun 11 11:25 privatemessage.MYI
-rw-rw---- 1 mysql root 9056 Jan 17 16:13 privatemessage.frm
-rw-rw---- 1 mysql root 2835 May 30 22:10 profilefield.MYD
-rw-rw---- 1 mysql root 2048 May 30 22:15 profilefield.MYI
-rw-rw---- 1 mysql root 8828 Jan 17 16:13 profilefield.frm
-rw-rw---- 1 mysql root 3268 Jun 7 22:37 replacement.MYD
-rw-rw---- 1 mysql root 3072 Jun 8 12:01 replacement.MYI
-rw-rw---- 1 mysql root 8690 Jan 17 16:13 replacement.frm
-rw-rw---- 1 mysql root 506 Mar 31 18:33 replacementset.MYD
-rw-rw---- 1 mysql root 2048 Mar 31 18:45 replacementset.MYI
-rw-rw---- 1 mysql root 8604 Jan 17 16:13 replacementset.frm
-rw-rw---- 1 mysql root 305848 Jun 11 17:13 search.MYD
-rw-rw---- 1 mysql root 22528 Jun 11 17:13 search.MYI
-rw-rw---- 1 mysql root 8784 Jan 17 16:13 search.frm
-rw-rw---- 1 mysql root 11961114 Jun 11 11:35 searchindex.MYD
-rw-rw---- 1 mysql root 16087040 Jun 11 11:35 searchindex.MYI
-rw-rw---- 1 mysql root 8616 Jan 17 16:13 searchindex.frm
-rw-rw---- 1 mysql root 8756 Jan 17 16:13 session.frm
-rw-rw---- 1 mysql root 41464 May 31 12:17 setting.MYD
-rw-rw---- 1 mysql root 4096 May 31 12:37 setting.MYI
-rw-rw---- 1 mysql root 8804 Jan 17 16:13 setting.frm
-rw-rw---- 1 mysql root 3255 Jan 17 16:14 settinggroup.MYD
-rw-rw---- 1 mysql root 2048 Jan 17 18:53 settinggroup.MYI
-rw-rw---- 1 mysql root 8640 Jan 17 16:13 settinggroup.frm
-rw-rw---- 1 mysql root 16401 May 27 17:08 smilie.MYD
-rw-rw---- 1 mysql root 2048 May 28 13:00 smilie.MYI
-rw-rw---- 1 mysql root 8660 Jan 17 16:13 smilie.frm
-rw-rw---- 1 mysql root 518 Mar 31 21:17 style.MYD
-rw-rw---- 1 mysql root 2048 Apr 5 17:55 style.MYI
-rw-rw---- 1 mysql root 8712 Jan 17 16:13 style.frm
-rw-rw---- 1 mysql root 1690 Jun 10 20:20 subscribeforum.MYD
-rw-rw---- 1 mysql root 7168 Jun 10 21:17 subscribeforum.MYI
-rw-rw---- 1 mysql root 8674 Jan 17 16:13 subscribeforum.frm
-rw-rw---- 1 mysql root 87600 Jun 11 11:17 subscribethread.MYD
-rw-rw---- 1 mysql root 138240 Jun 11 11:17 subscribethread.MYI
-rw-rw---- 1 mysql root 8678 Jan 17 16:13 subscribethread.frm
-rw-rw---- 1 mysql root 556588 Jun 11 04:26 template.MYD
-rw-rw---- 1 mysql root 19456 Jun 11 04:26 template.MYI
-rw-rw---- 1 mysql root 8666 Jan 17 16:13 template.frm
-rw-rw---- 1 mysql root 506 Mar 31 18:35 templateset.MYD
-rw-rw---- 1 mysql root 2048 Apr 1 10:39 templateset.MYI
-rw-rw---- 1 mysql root 8598 Jan 17 16:13 templateset.frm
-rw-rw---- 1 mysql root 779304 Jun 11 17:58 thread.MYD
-rw-rw---- 1 mysql root 251904 Jun 11 17:58 thread.MYI
-rw-rw---- 1 mysql root 9112 Jan 17 16:13 thread.frm
-rw-rw---- 1 mysql root 20776 Jun 11 03:10 threadrate.MYD
-rw-rw---- 1 mysql root 27648 Jun 11 03:10 threadrate.MYI
-rw-rw---- 1 mysql root 8688 Jan 17 16:13 threadrate.frm
-rw-rw---- 1 mysql root 1451500 Jun 11 11:35 user.MYD
-rw-rw---- 1 mysql root 326656 Jun 11 11:35 user.MYI
-rw-rw---- 1 mysql root 10068 Jan 20 14:09 user.frm
-rw-rw---- 1 mysql root 16380 Jun 11 04:02 useractivation.MYD
-rw-rw---- 1 mysql root 15360 Jun 11 05:17 useractivation.MYI
-rw-rw---- 1 mysql root 8702 Jan 17 16:13 useractivation.frm
-rw-rw---- 1 mysql root 17647630 Jun 11 11:25 userfield.MYD
-rw-rw---- 1 mysql root 84992 Jun 11 11:25 userfield.MYI
-rw-rw---- 1 mysql root 8814 May 30 21:31 userfield.frm
-rw-rw---- 1 mysql root 2650 May 31 23:16 usergroup.MYD
-rw-rw---- 1 mysql root 3072 Jun 2 12:50 usergroup.MYI
-rw-rw---- 1 mysql root 9914 Jan 17 16:13 usergroup.frm
-rw-rw---- 1 mysql root 765 Jan 17 16:13 usertitle.MYD
-rw-rw---- 1 mysql root 2048 Jan 21 19:57 usertitle.MYI
-rw-rw---- 1 mysql root 8626 Jan 17 16:13 usertitle.frm
-rw-rw---- 1 mysql root 6230235 Jun 11 11:35 word.MYD
-rw-rw---- 1 mysql root 2566144 Jun 11 11:35 word.MYI
-rw-rw---- 1 mysql root 8584 Jan 17 16:13 word.frm

::BTW sorry about the basic commands

That's OK, you know more about telnet than I do.

Luckly I got a back-up from 12 days ago that I can use.

[Air]

Well the good news is the file is there:

-rw-rw---- 1 mysql root 1451500 Jun 11 11:35 user.MYD

If you were able to use phpmyadmin before without problems on this table, then try to use the phpmyadmin functions under "Table Maintenance" to "check" the user table and possibly "repair" the user table. Other wise if you have a backup you may need to restore those tables to a previoulsy working point.

[Jesse_Smith]

>>>Error
>>>MySQL said: Can't open file: 'user.MYD'. (errno: 145)

Shows up at all the 'Browse Select Insert Properties Drop Empty' links. Is there a newer version? 2.1.0

It doesn't show a 'Table Maintenance' link.

[Jesse_Smith]

It's back!

I ran
REPAIR TABLE user;
in it. Found the answer by entering "Can't open file user.MYD" in Google! Google might be mesed up, but it can still provide info!

>>>>>Your user table is corrupted. Run this MySQL query in phpMyAdmin or equivalent:

>>>>>REPAIR TABLE user;