Re: MySQL Problems With a New Data Directory
2005/10/22, Hal Vaughan <hal@thresholddigital.com>:
> I'm using MySQL 4.0.24-10 on Sarge. I had a setup of a program I've been
> working on for several years that is on a RAID. I changed MySQL's data
> directory so it will be on the same RAID and backed up, along with all my
> other data and programs. Originally this was set up under a Debian-based
> distro that was based on the testing and unstable branches of Debian. Before
> putting the server into production, I wanted to change it to Sarge for
> safety.
>
> So I backed up all the data on the RAID, wiped the original boot/system drive,
> installed Debian Sarge, did an fsck on the RAID, found errors, wiped it out,
> restored the original data, including the MySQL db files. When I installed
> MySQL on the re-done system, it worked. When altered the line
> in /etc/mysql/my.cnf from:
>
> datadir = /var/lib/mysql
>
> to:
>
> datadir = /thresh/tNet/db
Did you move everything that was under the /var/lib/mysql directory ?
even the mysql directory which holds users and grant access for the
whole DB ?
--
Pooly
Webzine Rock : http://www.w-fenec.org/
Reply to: