The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL Problem

Discussion in 'Database Discussions' started by Batu, Sep 11, 2006.

  1. Batu

    Batu Member

    Joined:
    Dec 17, 2004
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    MySQL Setup Script Version 7.0
    Loaded cPPkgs::MySQL ok!
    This is the cPPkgs::MySQL 4.1.21 installer for Linux.
    Preparing... ########################################### [100%]
    1:MySQL-shared ########################################### [100%]
    Preparing... ########################################### [100%]
    1:MySQL-devel ########################################### [100%]
    Preparing... ########################################### [100%]
    1:MySQL-embedded ########################################### [100%]
    Preparing... ########################################### [100%]
    1:MySQL-client ########################################### [100%]
    Preparing... ########################################### [100%]
    1:MySQL-bench ########################################### [100%]
    Preparing... ########################################### [100%]
    Giving mysqld a couple of seconds to exit nicely
    1:MySQL-server ########################################### [100%]
    060911 9:30:41 [ERROR] /usr/sbin/mysqld: Disk is full writing './mysql/help_category.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs

    And I TRY


    [[[root@corvette:~]]]mysql start
    ERROR 2013 (HY000): Lost connection to MySQL server during query


    /tmp CHMOD is 1777

    Please help,I can't start MySQL.

    Thanks.
     
  2. hicom

    hicom Well-Known Member

    Joined:
    May 23, 2003
    Messages:
    272
    Likes Received:
    0
    Trophy Points:
    16
    Run 'df' as root, the error is clear....your disk is full (mostly /var)
     
  3. Batu

    Batu Member

    Joined:
    Dec 17, 2004
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    df

    Filesystem 1K-blocks Used Available Use% Mounted on
    /dev/mapper/VolGroup00-LogVol00
    113210032 110012688 0 100% /
    /dev/hda1 101086 15428 80439 17% /boot
    none 1033048 0 1033048 0% /dev/shm
    /dev/hdd2 114309732 108030692 472348 100% /disk3
    /usr/tmpDSK 495844 10583 459661 3% /tmp
    /tmp 495844 10583 459661 3% /var/tmp


    Df reply.
     
  4. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    So, you need to clean up space on that full partition.
     
Loading...

Share This Page