MySql 4.0.3 Feature question.

Dormition Skete A Monastery of the Russian Orthodox Autonomous Church http://www.BuenaVistaCO.com/GOC http://www.ROACAmerica.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: relocating databases

all your file permissions are ok -- that your mysql user can see them. 5. Restart the server. It worked for me. You can see other options for your my.cnf file by looking at the instructions for installing MySql. I hope this helps... In Christ, Peter, hierodeacon Dormition Skete

Cross-database joins

% *** If this is not possible, can this be accomplished with a UNION by selecting all the records in the local table, and joining the result set with the shared table? If so, how? Any help will be *greatly, greatly* appreciated. In Christ, Peter, hierodeacon Dormition Skete A Monastery of the Russian Orthodox

Re: Cross-database joins

Many thanks. You filled in the missing piece for me. It appears to be working... at least with both databases on the same MySql server. I hope that putting one db on the file server and one locally does not prove to be problematic (that issue never occurred to me), but if worse comes to worse,