Is there a way to setup MySQL with Virtual Hosts so that the Data for the Virtual Host MySQL database is stored in the users document root? Example: /home/vhuser1/mysql/datadir/ /home/vhuser2/mysql/datadir/ I checked around and really couldn't find a detailed setup for this purtaining to Ubuntu Server 8.04 LTS.
Sorry about that. There is still alot about Linux that I simply do not understand. So some of this might not be to the current technical babble. Say I have a WebServer that is currently running 3 different domains using Virtual Hosts thru Apache2. Example: www.firstdomain.com www.seconddomain.com www.thirddomain.com say www.firstdomain.com and www.thirddomain.com want to use PHP based forums such as vBulletin or phpBB, and me, being more of a organization freak, want to make it so there mysql data for each individual mysql database is located in there home directory in a folder called mysql so there structure would look something like this. /home/www.firstdomain.com/mysql <--- all database info would be stored here for that domain. /home/www.firstdomain.com/www | | - /home/www.firstdomain.com/www/cgi-bin | - /home/www.firstdomain.com/www/logs essentially I want to keep as much away from the actual server as possible and try to group most of the user information and data into there home directory. I hope that makes a bit more sense.
Thank you for the information. I suppose making a link would definatly work, I was thinking it might be a bit simpler to preform just one back up and beable to capture everything a domain has in a single backup including the MySQL data that the paticular domain has. In anycase thanks for the information.
