Mysql -- Putting user databases under user directory
I want to put some of my users database under their home directory, is it possible to do that. If so can any one point me to the right source. Regards __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql -- Putting user databases under user directory
Hello Suba, I assume that yo are using any linux OS and MyISAM tables. I think you have several options. The two most common are: 1) you use the datadir option 2) you create symbolic links (ls command) to the users home directory and copy the data (shutdown mysql server before ;-) I havent yet tried them all myself, but they should work at least for the MyISAM tables. Best regards Nils Valentin Tokyo/Japan 2003 6 14 13:19Suba Arunkumar : I want to put some of my users database under their home directory, is it possible to do that. If so can any one point me to the right source. Regards __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql -- Putting user databases under user directory
At 21:19 -0700 6/13/03, Suba Arunkumar wrote: I want to put some of my users database under their home directory, is it possible to do that. If so can any one point me to the right source. Don't do it. There is no advantage to doing this. The database directories must be owned by the server in order for it to properly access them anyway (not owned by your users), and putting database directories under user home directories will tempt them to mess around with the files there -- which they shouldn't be doing. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql -- Putting user databases under user directory
Paul is right (I should have metnioned it as well ;-) Best regards Nils Valentin Tokyo/Japan 2003 6 14 13:40Paul DuBois : At 21:19 -0700 6/13/03, Suba Arunkumar wrote: I want to put some of my users database under their home directory, is it possible to do that. If so can any one point me to the right source. Don't do it. There is no advantage to doing this. The database directories must be owned by the server in order for it to properly access them anyway (not owned by your users), and putting database directories under user home directories will tempt them to mess around with the files there -- which they shouldn't be doing. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]