2005/10/22, Hal Vaughan <[EMAIL PROTECTED]>: > 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/
