SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Wizard Mike Borozdin's Avatar
    Join Date
    Oct 2002
    Location
    Edinburgh, UK
    Posts
    1,743
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question How do I restart a MySQL server in Linux????

    Hi!

    This question might seem to be silly, but I searched in the documentation and didn't found an answer, so I'm asking here . How do I restart a server in Linux? I can restart it in phpMyAdmin, I even did that, but then when I looked at its status I found its uptime and it said as if I hadn't restarted it.

    Why do I need to restart it?

    Because I changed the configuration file /etc/my.cnf and put that string there:

    Code:
    sort_buffer_size=128M
    By the way, after several restarting in phpMyAdmin it still showed the old sort_buffer_size value in the system variables, so I don't think phpMyAdmin restart the it properly, correct me if I'm wrong.

  2. #2
    SitePoint Zealot pionar's Avatar
    Join Date
    Nov 2003
    Location
    Indianapolis
    Posts
    168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    mysql is a daemon; all daemons have a script in /etc/rc.d/init.d/ that accept three arguments - stop, restart, and start. to restart mysql, you would type at the command line:

    Code:
    /etc/rc.d/init.d/mysqld restart
    mysqld is the server, mysql is the client.

    note that the exact path may be different.

    and you'll (probably) have to be root.

  3. #3
    SitePoint Zealot hpnadig's Avatar
    Join Date
    Sep 2003
    Location
    Bangalore
    Posts
    174
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    use $> service mysql restart

    simple enuph (as root)
    Home Page| Blog | Gallery
    sys op & contributor @ kn wikipedia

    Still stuck with a stinky browser? Go get FireFox


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •