AL8 Forum » Unix & Linux 研究討論 » ERROR: 1004 Can't create file '/tmp/#sql1164_1_0.frm' (errno: 28)


2008-10-6 20:13 zoooooo1
ERROR: 1004 Can't create file '/tmp/#sql1164_1_0.frm' (errno: 28)

Discuz! info: Can not connect to MySQL server

Time: 2008-10-6 8:12pm
Script: /php/index.php

Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Errno.: 2002

Similar error report has beed dispatched to administrator before.



and~~~~~~~~~~~



Initializing MySQL database:  Installing MySQL system tables...
081006 19:37:25 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
081006 19:37:25 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
ERROR: 1004  Can't create file '/tmp/#sql1164_1_0.frm' (errno: 28)
Installation of system tables failed!

Examine the

2008-10-6 21:02 i553041
[quote]原帖由 [i]zoooooo1[/i] 於 2008-10-6 20:13 發表 [url=http://www.alan888.com/Discuz/redirect.php?goto=findpost&pid=1282715&ptid=155686][img=13,13]http://www.alan888.com/Discuz/images/common/back.gif[/img][/url]
Discuz! info: Can not connect to MySQL server
Time: 2008-10-6 8:12pm
Script: /php/index.php
Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Errno ... [/quote]
你都好慳水慳力喎...一個copy and paste就攪掂!
「As title」,「如題」之類都己經夠懶的了,
估唔到呢個版本更加懶...一個Copy and Paste就發帖!
既然你無誠意發問,咁就要睇下有無人有誠意答你了!(至少我就無了!)

[[i] 本帖最後由 i553041 於 2008-10-6 21:04 編輯 [/i]]

2008-10-6 21:10 zoooooo1
=.=
我係幫人問嫁

佢話restart唔到wo

2008-10-6 21:15 kohong
[quote]原帖由 [i]zoooooo1[/i] 於 2008-10-6 21:10 發表 [url=http://www.alan888.com/Discuz/redirect.php?goto=findpost&pid=1282750&ptid=155686][img=13,13]http://www.alan888.com/Discuz/images/common/back.gif[/img][/url]
=.=
我係幫人問嫁
佢話restart唔到wo [/quote]
[color=Red][size=7]你朋友即是你[/size][/color]

:em37:  無人會理你係幫邊個問,  總之咁樣就係懶:em32:

2008-10-6 21:29 i553041
[quote]原帖由 [i]zoooooo1[/i] 於 2008-10-6 21:10 發表 [url=http://www.alan888.com/Discuz/redirect.php?goto=findpost&pid=1282750&ptid=155686][img=13,13]http://www.alan888.com/Discuz/images/common/back.gif[/img][/url]
=.=
我係幫人問嫁
佢話restart唔到wo [/quote]
幫人問就一個Copy and Paste架啦?好大條道理喎!
自己問又好,幫人問又好,有o的禮貌啦,就算帖個log出黎,(幫朋友發問,唔知應該點問!)

咁樣加一句:

「唔好意思,我幫朋友問o既,可唔可以幫我睇下個log係咩問題?又無方法解決?我唔係唔想講詳細o的,但我唔係好識點講...(我都唔係好熟Linux),請幫幫忙!」

係咪好過你一個copy and paste就發帖好好多呀?既顯得自己有修養,講野又有禮貌,至少都比o的發問o既誠意黎睇下丫!

我講野係咁直的了,係唔o岩聽架啦!但我講得o岩唔o岩先?

這個mySQL error 2002,網上有好多人遇到過,隨便揾下資料就有:
Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
參考這個:
[url]http://pchome.blog.enorth.com.cn/article/221219.shtml[/url]

解決到2002個錯誤,1004個error就自然會解決....

2008-10-6 23:18 zoooooo1
我比左條link佢了

thanks多位先

2008-10-6 23:56 zoooooo1
回覆 #5 i553041 的帖子

081006 23:48:37  mysqld started
081006 23:48:37 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
081006 23:48:37 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
/usr/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
081006 23:48:37 [ERROR] Aborting
081006 23:48:37 [Note] /usr/libexec/mysqld: Sh



佢話都係開唔返sql~_~

2008-10-7 00:02 i553041
[quote]原帖由 [i]zoooooo1[/i] 於 2008-10-6 23:56 發表 [url=http://www.alan888.com/Discuz/redirect.php?goto=findpost&pid=1282857&ptid=155686][img=13,13]http://www.alan888.com/Discuz/images/common/back.gif[/img][/url]
081006 23:48:37  mysqld started
081006 23:48:37  option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
081006 23:48:37  option 'max_join_size': unsigned value 18446 ... [/quote]
呢個錯誤有無照住條link所講o既方法解決到先?
Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

2008-10-8 08:24 zoooooo1
佢話得左了

我話thx大家:em32: :em32:

頁: [1]


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.