-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Peter, et al --
...and then Peter Brawley said... % % > <snip> I can't find a my.cnf file anywhere on this % > FreeBSD 4.5 system! % > % > I know [also from your other reply :-] that I can set various options in % > my personal .my.cnf file... Does that include innodb file paths and the % > like, or is that only in the system-level file? % % IMO it's best to have just one my.cnf.ini. I imagine so, but I can't change the system file. Of course, I haven't found it yet, either! % % > % skip-innodb % > % is not commented out, do so. If other innodb vars are commented out, % > % uncomment them. % > % > I'll leave the rest of these checks until I find the file... Meanwhile, % > here are some selections from a 'show variables;' that make me wonder % > about our innodb status... ... % % See the manual about how to set up InnoDB. You will have to create the % InnoDB directory yourself, then set % innodb_data_file_path = <filename>:<size> % innodb_data_home_dir = <path. % innodb_log_group_home_dir = <path> % innodb_log_arch_dir = <path % in my.cnf/ini. It doesn't say whether I must do this once for the entire database or can do it on a per-user basis in my own my.cnf file. I have to think the former, but can anyone say one way or another? % % PB Thanks & HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE969okGb7uCXufRwARAuBaAKCctm6gNxYboMPLJ/k44M3gqGyBrgCgxvKQ N53k36P1JzNdxBIBjoSgRgo= =DSoI -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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