Robert, Thanks again...
I think I am on the right track, maybe. I am trying to use the symlink method you suggested. Below is the command I used to create a symlink named 'amgr' in /var/lib/mysql/ pointing to the real data directory of 'amgr' in /home/mysql/amgr/. The database 'amgr' shows up as a reference (with tables) when I use phpMyAdmin to view it, but the database and tables are totally empty of records...which of course it has many. ln -s /home/mysql/amgr/ /var/lib/mysql/ Also, it produces an error when I click to view one of the tables in phpMyAdmin. ============ MySQL said: Can't find file: './amgr/xxxx.frm' (errno: 13) ============ Did I miss something? Did I mention I was ignorant? Thanks, Dennis Williams ----- Original Message ----- From: "Robert Alexander" <[EMAIL PROTECTED]> To: "DWilliams" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December 30, 2001 3:29 PM Subject: Re: MySQL RPM Install Problem - Ignorance > At 14:37 -0600 2001/12/30, DWilliams wrote: > >Robert, > > > >Thanks for the tips... > > > >>>1. create a symlink at /var/lib/mysql that points to your data directory<< > > > >I had read that this was not the best way prior to v4.0, something about an > >"alter table" statement might ignore the symlink? > > I've used symlinks a lot and have never had any problems. I usually just install the binary distro, and symlink from /usr/local/mysal/data -> my/data/location. > > > > >>>2. you can change or add the 'datadir' variable in your my.cnf file > >(usually /etc/my.cnf) see:<< > > > >I apparently don't have a 'my.cnf' file after install...I found the > >following in /usr/share/mysql/: > > > >my-huge.cnf > >my-large.cnf > >my-medium.cnf > >my-small.cnf > > > >I guess these are example my.cnf files to use...If so, the next question > >which is the appropriate/best type? > > Just open them up in an editor and read what it says at the top. Then copy the one you want to /etc/my.cnf > > > >I guess whatever choice should be > >renamed and located as 'my.cnf' in /var/lib/mysql directory? I'm assuming > >the server on start-up reads this file and overrides compiled commands. > > Not in the data dir. You're telling it where to *look* for the data, right? This would be your global settings and goes into /etc/my.cnf. > > > >Which section does the 'datadir=path/to/data/' command go...to the [mysqld] > >section? > > Yup. > > > >There is no mention of this command on: > >http://www.mysql.com/doc/O/p/Option_files.html > > In a browser, open up the manual that came with your distro and do a search for 'my.cnf' Lots o' good stuff... :> > > > > >>>3. you can specify the data directory location as a configure option > >before compiling.<< > > > >Eventually, I will learn how to do this...but I opted for the RPM instead. > >I guess that is why I have these sort of configuration difficulties. > > > >Thanks again, > >Dennis Williams > > > Regards, > /Rob > -- > Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 > http://www.workmate.ca WWW Database Applications and Web Hosting > > Searchable MySQL List Archive: http://archive.workmate.ca/myarchive > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
