Re: Adding a new HDD - how do I move /var/lib/mysql ?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wed, Jan 10, 2007 at 09:31:31PM +0200, Justin Hartman wrote:
> I currently have a server with an 80GB hdd which is running out of
> space very quickly. I want to now add a 250GB hdd in addition to the
> 80GB one and move my mysql data to this new 250GB drive.
>
> I am running mysql-5.0.30 on Etch which was installed via apt-get so
> there has been no modifications made to mysql whatsoever. How do I now
> move my mysql server to store files on the new hard drive instead of
> the old one without having to mess around too much?
>
> Any help appreciated.
> --
> Regards
Hi Justin,
probably the simplest way is to just make a new /var on the new drive
and move all of it there.
- -add new HD to computer
- -partition HD
- -format HD
- -mount new HD as /mnt/newvar
- -stop all processes (like single user mode)
- -copy all of /var to /mnt/newvar
- -move /var to /oldvar (not sure this works)
- -create /var
- -edit fstab to add mount point to make new partition point to /var
- -reboot and hope it works
cheers,
Kev
- --
| .''`. == Debian GNU/Linux == | my web site: |
| : :' : The Universal | 'under construction' |
| `. `' Operating System | go to counter.li.org and |
| `- http://www.debian.org/ | be counted! #238656 |
| my keysever: subkeys.pgp.net | my NPO: cfsg.org |
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFFpUKVv8UcC1qRZVMRAvwyAJ4nh36cOzFyI6mrZ0yUAER1XfkMZwCdE1sU
4LPXJ/EqDEsLSHtoj+GUfiA=
=hbeC
-----END PGP SIGNATURE-----
Reply to: