Re: MySQL Problems With a New Data Directory
On Saturday 22 October 2005 03:09 pm, Pooly wrote:
> 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/
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
Reply to: