我按照百度文库中文档移植mysql到arm+linux上 在pc机上编译成功了。可是移植到我的板上的时候,就是把源目录拷到开发板的/user/local/下;并拷了配置文件my.conf当运行 ./mysql_install_db --user=root --force 就出现以下问题了
Installing MySQL system tables...
000106 2:00:06 [Warning] '--skip-locking' is deprecated and will be removed in
a future release. Please use '--skip-external-locking' instead.
000106 2:00:07 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.key_buffer_size=16384
read_buffer_size=262144
max_used_connections=0
max_threads=151
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 49316 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd: 0x497e80
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x40ba6df8 thread_stack 0x20000
/usr/local/mysql/libexec/mysqld(server_start_time+0) [0x4659e0]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x4a9000 = REPLACE INTO tmp_user SELECT @current_hostname,'root','
','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y
','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0 FROM dual WHERE LOWER( @cu
rrent_hostname) != 'localhost'
thd->thread_id=1
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Installation of system tables failed! Examine the logs in
/usr/local/mysql/var for more information.
怀疑是“thd->query at 0x4a9000 = REPLACE INTO tmp_user SELECT” 这句出错,但是把hostname改成localhost也没用.怀疑权限问题,我把mysql/var目录改成1777了,还是不行。在开发板上,不知道为什么用 /usr/local/mysql/bin/resolveip localhost 竟然得不到ip。在主机上能够得到127.0.0.1。能不能有神人指点下啊 ,搞了一个星期了。我能不能不执行install这句不知道行不行。
Installing MySQL system tables...
000106 2:00:06 [Warning] '--skip-locking' is deprecated and will be removed in
a future release. Please use '--skip-external-locking' instead.
000106 2:00:07 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.key_buffer_size=16384
read_buffer_size=262144
max_used_connections=0
max_threads=151
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 49316 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd: 0x497e80
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x40ba6df8 thread_stack 0x20000
/usr/local/mysql/libexec/mysqld(server_start_time+0) [0x4659e0]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x4a9000 = REPLACE INTO tmp_user SELECT @current_hostname,'root','
','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y
','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0 FROM dual WHERE LOWER( @cu
rrent_hostname) != 'localhost'
thd->thread_id=1
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Installation of system tables failed! Examine the logs in
/usr/local/mysql/var for more information.
怀疑是“thd->query at 0x4a9000 = REPLACE INTO tmp_user SELECT” 这句出错,但是把hostname改成localhost也没用.怀疑权限问题,我把mysql/var目录改成1777了,还是不行。在开发板上,不知道为什么用 /usr/local/mysql/bin/resolveip localhost 竟然得不到ip。在主机上能够得到127.0.0.1。能不能有神人指点下啊 ,搞了一个星期了。我能不能不执行install这句不知道行不行。
解决方案 »
- 怎样解决不让查询语句循环?
- 一个字段datetime
- 同一个表中两个字段PARENT_FUNCTION_ID与FUNCTION_ID,建立父子关联,怎么建?
- 新建数据库 出现---创建/打开物理设备 时发生操作系统错误 32(另一个程序正在使用此文件,进程无法访问。)。
- 在 存储过程/函数 中怎样使用 表名 作为参数?
- SQL2000存储过程使用游标找最后一条记录的ID麻烦高手!
- 备份数据库后,恢复时老是超时过期怎么办呀?
- sql server服务器的群集怎么做,请高手写下具体做法。
- 如何调用未附加的数据库mdf文件那?
- SQL2000导出数据库中表到c盘下的问题。
- 怎样让XP能使用连接SQL serer 2008服务器的客户端
- 随机行+指定行,在sql里应该怎么写,在线等,加急!!!
根本用不着运行这一项。
我直接把windows下面的var下的文件夹全部拷过来用就是了