#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    144
    Rep Power
    9

    How to restart mysql


    Hello

    I'm on FreeBSD 6.2 dedicated server with root access
    control-panel Directadmin

    Today i check that i cann't login into directadmin. at the same time ftp and ssh access are live.

    try to do restart and after this mysql service is down too.

    all my attempts to do restart aren't successful.

    1. don't have http access to DA
    2. have ftp access, but cann't overwrite files
    3. have ssh access
    4. mysql service is stoped

    try to do mysql restart with this command

    /usr/local/etc/rc.d/mysql-server.sh stop
    but there isn't such file

    try to connect to mysql and get such output

    Warning: mysql_connect() [function.mysql-connect]: Can't connect to local
    MySQL server through socket '/tmp/mysql.sock' (2) in


    what to do ?

    any advise will be appreciated
    Your Health Encyclopedia :: Recurrent Depression
    Medical and health consumer information resources containing comprehensive and unbiased information in patient-friendly language
  2. #2
  3. mod_dev_shed
    Devshed Supreme Being (6500+ posts)

    Join Date
    Sep 2002
    Location
    Atlanta, GA
    Posts
    14,817
    Rep Power
    1100
    If you moved mysql-server.sh into the rc.d folder, it'd be /etc/rc.d I believe this file is located in the scripts folder within your mysql installation folder, which is usually /usr/local/mysql.

    You could also just use mysqld_safe directly. In either case, did you read the MySQL manual for information on starting and stopping the server? You can also search for your error message.
    # Jeremy

    Explain your problem instead of asking how to do what you decided was the solution.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    144
    Rep Power
    9
    in my case right path is

    /usr/local/etc/rc.d/mysqld

    thank you
    Your Health Encyclopedia :: Recurrent Depression
    Medical and health consumer information resources containing comprehensive and unbiased information in patient-friendly language

IMN logo majestic logo threadwatch logo seochat tools logo