Hello,

I have just installed 7.04 distro. I have installed mysql 5.0 using Synaptic it now sits in /var/lib/mysql. I have an USB connected external harddrive that I would like to place my data/tables in. Can anyone tell me how to go about this?

A related reply asked me to post df -h and mount so here they are.....

df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 53G 2.4G 48G 5% /
varrun 990M 116K 990M 1% /var/run
varlock 990M 0 990M 0% /var/lock
procbususb 990M 132K 990M 1% /proc/bus/usb
udev 990M 132K 990M 1% /dev
devshm 990M 0 990M 0% /dev/shm
lrm 990M 39M 952M 4% /lib/modules/2.6.20-15-generic/volatile
/dev/sdb1 459G 13G 423G 3% /media/disk


mount
/dev/sda1 on / type ext3 (rw,errors=remount-ro)
proc on /proc type proc (rw,noexec,nosuid,nodev)
/sys on /sys type sysfs (rw,noexec,nosuid,nodev)
varrun on /var/run type tmpfs (rw,noexec,nosuid,nodev,mode=0755)
varlock on /var/lock type tmpfs (rw,noexec,nosuid,nodev,mode=1777)
procbususb on /proc/bus/usb type usbfs (rw)
udev on /dev type tmpfs (rw,mode=0755)
devshm on /dev/shm type tmpfs (rw)
devpts on /dev/pts type devpts (rw,gid=5,mode=620)
lrm on /lib/modules/2.6.20-15-generic/volatile type tmpfs (rw)
binfmt_misc on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
/dev/sdb1 on /media/disk type ext3 (rw,noexec,nosuid,nodev)

# Databases located in: /var/lib/mysql/
# Default config file installed by RPM: /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log

Thanks for your response. I change the settings in /var/lib/mysql/my.cnf to below but the database sill gets saved in /var/lib/mysql

Any ideas?

# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /media/disk/mysql
tmpdir = /media/disk/tmp
language = /usr/share/mysql/english
skip-external-locking

Just asking to make sure,

but did you restart the mysql service?

ok got mysql to store on an external hd, thanks for the replies.

Now I have a new problem, I wanted to store these files externally to save space on my hard drive but it seems that the database is being added simultaneously to cache? Anyone have a solution for this?

Thanks