On Saturday 22 October 2005 03:09 pm, Pooly wrote: > 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/
I used the mysql directory with the table from the original install, with original permissions in the tables. I matched the ownership and file permissions with the ones in /var/lib/mysql. Hal -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]