Please note I am using Ubuntu Server 6.10 to verify this documentation.
My favorate text editor is pico, if you prefer something else please substitute that for pico in any command which references pico.
- I find the easiest way to do things which are only documented for the Desktop install of Ubuntu is to install a lightweight window manager like Ice WM and then configure the system using a GUI when no other method is documented or if the other documented methods take too much time to read them.
- Change the directory where MySQL stores it's data files:
- mkdir [YourNewDirectory]
- Optional: If you want the data on a new partition, create and format the partition and then mount it to the new directory.
- cp -ar /var/lib/mysql/* [YourNewDirectory]
- pico /etc/mysql/my.cnf
- Go to the [mysqld] directive.
- The line which has "datadir = /var/lib/mysql" and change it to "datadir = [YourNewDirectory]"
- Save the file
- /etc/init.d/mysql restart
- Set up a Primary Domain Controller (PDC) with Ubuntu
- See the related link: Howto forge