Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 11-11-2004, 09:13 AM   #1
LQ Newbie
Registered: Nov 2004
Posts: 3

Rep: Reputation: 0
mysql-installation: Not enough space in /var/lib/mysql/

hi you out there.
I need your help

i want to install mysql4.x on my Debian-Computer.(Distribution Debian 3.0)
But i get the error-message

#apt-get install mysql-common mysql-client mysql-server

Unpacking mysql-common (from .../mysql-common_4.0.22-0.dotdeb.1_all.deb) ...
Unpacking libmysqlclient10 (from .../libmysqlclient10_3.23.56-2_i386.deb) ...
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_2.9003-3_i386.deb) ...
Unpacking libmysqlclient12 (from .../libmysqlclient12_4.0.22-0.dotdeb.1_i386.deb) ...
Unpacking mysql-client (from .../mysql-client_4.0.22-0.dotdeb.1_i386.deb) ...
Unpacking mysql-server (from .../mysql-server_4.0.22-0.dotdeb.1_i386.deb) ...

ERROR: There's not enough space in /var/lib/mysql/ (<-------??????????)

dpkg: error processing /var/cache/apt/archives/mysql-server_4.0.22-0.dotdeb.1_i386.deb (--unpack):
subprocess pre-installation script returned error exit status 1
Errors were encountered while processing:
E: Sub-process /usr/bin/dpkg returned an error code (1)

I clean the directory var/cache/apt/archives/ with apt-get clean.

Further information:

#cat /etc/mtab gives back

/dev/sda2 / ext2 rw,errors=remount-ro 0 0
proc /proc proc rw 0 0
/dev/hda1 /backup ext2 rw 0 0
cat /etc/fstab gives back

# /etc/fstab: static file system information.
# <file system> <mount point> <type> <options> <dump> <pass
/dev/sda2 / ext2 errors=remount-ro 0 1
/dev/sda5 none swap sw 0 0
proc /proc proc defaults 0 0
/dev/fd0 /floppy auto user,noauto 0 0
/dev/cdrom /cdrom iso9660 ro,user,noauto 0 0
/dev/hda1 /backup ext2 auto 0 0

cfdisk gives back

Disk Drive: /dev/hda
Size: 20490559488 bytes
Heads: 255 Sectors per Track: 63 Cylinders: 2491

Name Flags Part Type FS Type [Label] Size (MB)
hda1 Boot Primary Linux ext2 20489.18

i hope someone can help me
Old 11-11-2004, 10:03 AM   #2
Registered: Jul 2003
Location: netherlands
Distribution: debian
Posts: 403

Rep: Reputation: 30
you may want to check the available disk space with 'df -h'. don't know how much space mysql needs...

.-=~ iluvatar ~=-.
Old 11-11-2004, 10:13 AM   #3
LQ Newbie
Registered: Nov 2004
Posts: 3

Original Poster
Rep: Reputation: 0
df -h gives back

Filesystem Size Used Avail Use% Mounted on
/dev/sda2 -2254564460220k 1.0k 0.0k 10% /
/dev/hda1 -1833560400439k 1.0k 0.0k 1% /backup
Old 12-02-2004, 04:58 PM   #4
LQ Newbie
Registered: Jun 2004
Location: OH
Distribution: Debian currently
Posts: 20

Rep: Reputation: 0
I had a similar problem and have only used 15% of that drive. Is it possible that there may be a problem with the .deb package?
Old 12-02-2004, 07:30 PM   #5
LQ Newbie
Registered: Dec 2004
Posts: 6

Rep: Reputation: 0


you could make soft link for /var/lib/mysql to another partition which gets enough disk space

Old 12-03-2004, 03:21 AM   #6
LQ Newbie
Registered: Jun 2004
Location: OH
Distribution: Debian currently
Posts: 20

Rep: Reputation: 0
Thanks for the reply chiahsin, but there should be plenty of room on this partition. It seems like there may be something wrong with the installer, although I could be missing something else here. Has anyone else come across something like this or do you have any other suggestions?
Old 12-15-2004, 11:15 AM   #7
LQ Newbie
Registered: Dec 2004
Posts: 2

Rep: Reputation: 0
Yes!! Same issue here. I wonder where we submit MySQL bug reports for Debian?

Hmm, here's a discussion on MySQL's website:,1984,1984

Last edited by Crenfax; 12-15-2004 at 11:17 AM.
Old 06-18-2005, 09:06 PM   #8
LQ Newbie
Registered: Jun 2005
Posts: 1

Rep: Reputation: 0
had this problem, fixed it!

I was only moments away from turning my friday night and saturday into a reinstall sunday... but then i found this forum, SWEET!

Anyways you have to clean up everything, by apt-get remove mysql-server and apt-get remove mysql-client , i threw in a reboot after this step... i don't know if it's my MS background that makes me think this is neccesary, or my general experience with computers that does?

Anywhoos, now that everything's cleaned out:

apt-get update

apt-get install coreutils

there is a problem with the df that comes with our version of debian that means the output of df shows some messed up output. simply upgrading the coreutils means the parsed output of df does not cause the mysql install to error-out.

then apt-get install mysql-server (duh) and it's working for me!

Rock on folks.

Old 11-10-2006, 03:19 PM   #9
LQ Newbie
Registered: Nov 2006
Posts: 1

Rep: Reputation: 0
"had this problem Fixed it!" awwwwwwwwwww

i was pretty pumped to see somebody fixed this but i'm afraid i still am boned.

did the:
apt-get install coreutils

it says i have the most recent version and that i should run the apt-get -f install
........ so i do, it trys to install mysql-server-5.0 since mysql-server depends on it, and pow, same old error comes up again and nothing has changed


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 03:13 PM
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock welery Linux - Software 19 03-06-2014 08:19 AM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 02:52 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
Not enough space in /var/lib/mysql/ mtmacedo Linux - Software 1 10-22-2004 04:53 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:55 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration