database.sarang.net
UserID
Passwd
Database
DBMS
ㆍMySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
MySQL Q&A 1406 게시물 읽기
No. 1406
Re: mysql based table not create
작성자
정재익
작성일
2000-04-26 20:18
조회수
7,104

> mysql based table is not create. after make install and moved /usr/loc

> al/mysql/bin

> I runned ./mysql_install_db. but next message is appear and based tabl

> e was not created.

> ......message....................

> To start mysqld at boot time you have to copy support-files/mysql.serv

> er to the right place for your system.

>

> I am not understand "support-files/mysql.server".

> please. help.

 

In the source tree of MySQL tar ball, there is 'support-files' directory.

The 'mysql.server' file is script file that invoke the mysqld daemon.

 

The contents of mysql.server is as follows:

 

#!/bin/sh

# Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB

# This file is public domain and comes with NO WARRANTY of any kind

 

# Mysql daemon start/stop script.

 

# Usually this is put in /etc/init.d (at least on machines SYSV R4

# based systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/S01mysql.

# When this is done the mysql server will be started when the machine is started

# and shut down when the systems goes down.

 

# Comments to support chkconfig on RedHat Linux

# chkconfig: 2345 90 90

# description: A very fast and reliable SQL database engine.

 

PATH=/sbin:/usr/sbin:/bin:/usr/bin

basedir=/usr/local/mysql

bindir=/usr/local/mysql/bin

datadir=/usr/local/mysql/var

pid_file=/usr/local/mysql/var/mysqld.pid

log_file=/usr/local/mysql/var/mysqld.log

# Run mysqld as this user.

mysql_daemon_user=mysql

export PATH

 

mode=$1

 

if test -w / # determine if we should look at the root config file

then # or user config file

conf=/etc/my.cnf

else

conf=$HOME/.my.cnf # Using the users config file

fi

 

# The following code tries to get the variables safe_mysqld needs from the

# config file. This isn't perfect as this ignores groups, but it should

# work as the options doesn't conflict with anything else.

 

if test -f "$conf" # Extract those fields we need from config file.

then

if grep "^datadir" $conf >/dev/null

then

datadir=`grep "^datadir" $conf | cut -f 2 -d= | tr -d ' '`

fi

if grep "^user" $conf >/dev/null

then

mysql_daemon_user=`grep "^user" $conf | cut -f 2 -d= | tr -d ' ' | head -1`

fi

if grep "^pid-file" $conf >/dev/null

then

pid_file=`grep "^pid-file" $conf | cut -f 2 -d= | tr -d ' '`

else

if test -d "$datadir"

then

pid_file=$datadir/`hostname`.pid

fi

fi

if grep "^basedir" $conf >/dev/null

then

basedir=`grep "^basedir" $conf | cut -f 2 -d= | tr -d ' '`

bindir=$basedir/bin

fi

if grep "^bindir" $conf >/dev/null

then

bindir=`grep "^bindir" $conf | cut -f 2 -d= | tr -d ' '`

fi

if grep "^log=" $conf >/dev/null

then

log_file=`grep "log=" $conf | cut -f 2 -d= | tr -d ' '`

fi

fi

 

# Safeguard (relative paths, core dumps..)

cd $basedir

 

case "$mode" in

'start')

# Start daemon

 

if test -x $bindir/safe_mysqld

then

# Give extra arguments to mysqld with the my.cnf file. This script may

# be overwritten at next upgrade.

$bindir/safe_mysqld \r

--user=$mysql_daemon_user --datadir=$datadir --pid-file=$pid_file --log=$log_file &

else

echo "Can't execute $bindir/safe_mysqld"

fi

;;

 

'stop')

# Stop daemon. We use a signal here to avoid having to know the

# root password.

if test -f "$pid_file"

then

mysqld_pid=`cat $pid_file`

echo "Killing mysqld with pid $mysqld_pid"

kill $mysqld_pid

# mysqld should remove the pid_file when it exits.

else

echo "No mysqld pid file found. Looked for $pid_file."

fi

;;

 

*)

# usage

echo "usage: $0 start|stop"

exit 1

;;

esac

[Top]
No.
제목
작성자
작성일
조회
1403포린 키???
1772
2000-04-26
6060
1417┕># Re: 포린 키??? -> 어느 DB책이든 보면 나옴
문태준
2000-04-28 16:08:12
6508
1424┕>Re: 포린 키???
장시복
2000-04-29 10:37:58
6926
4683 ┕># 이것 때문에 몇일 고생했는데... 알려주세요.^^
초보자
2000-11-23 23:19:32
5477
1402데이타 베이스 기본 테이블 생성
류성만
2000-04-26
5807
1408┕>Re: 데이타 베이스 기본 테이블 생성
정재익
2000-04-26 20:51:22
6323
1401mysql 에서 embedded sql 을 사용하고 싶은데, 어떻게 하면 되죠.
flywhale
2000-04-26
6373
1407┕>Re: mysql 에서 embedded sql 을 사용하고 싶은데, 어떻게 하면 되죠.
정재익
2000-04-26 20:44:31
6926
1400mysql based table not create
ysm
2000-04-26
5868
1406┕>Re: mysql based table not create
정재익
2000-04-26 20:18:06
7104
1399Mysql 구동 에러가.. 급합니다.
문용우
2000-04-26
5705
1405┕>Re: Mysql 구동 에러가.. 급합니다.
정재익
2000-04-26 19:57:04
6589
1396mysql compile(게시판에 없는 내용)
jungss
2000-04-25
5937
1397┕>Re: mysql compile(게시판에 없는 내용)
jungss
2000-04-25 17:43:21
6177
1395MySQL의 한글 구조는 어떻게 되는지요?
박순성
2000-04-25
6211
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.018초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다