Re: [webmin-l] adding a database to a virtualmin domain without one

[Jamie C. <jca...@we...>]

On 12/Dec/2006 21:19 Barry wrote ..
> Jamie Cameron wrote:
> > On 12/Dec/2006 17:33 Barry wrote ..
> >> Jamie -
> >>
> >> Due to the memory issues I described earlier, a domain was created via
> >> virtualmin that didn't have a db associated with it.
> >>
> >> Now I'd like to add that missing db.
> >>
> >> When I bring up the domain frame in virtualmin, there is no button for
> >> "edit databases" as there is on the domains that have databases.
> >>
> >> So it looks like the only way to add the database would be to click
> on
> >> the checkbox for "MySQL database enabled?" and then "Save virtual server"
> >>
> >> But given the memory problems, that seems overkill and in fact won't
> run
> >> at all if I have mysqld running.
> >>
> >> Is there another way to create a database, maybe via the mysql module
> >> (or even by hand - I am willing to do it from the shell if necessary)
> >> and then associate it with a virtualmin domain?
> >>
> >> Maybe there is a webmin/virtualmin command line tool I can use instead
> >> of the web interface?
> > 
> > That depends .. did the MySQL login for your virtual server get created?
> > The fix depends on that.
> 
> Yes, it looks like both the db and the user are there aty this point, 
> but the virtualmin domain summary screen says "Databases: None created"

In that case, try editing the virtual server's file under
/etc/webmin/virtual-server/domains, add changing the mysql=0 line to mysql=1.
This will make the Edit Databases page appear, and on that page you can associate
the existing database with the domain.

 - Jamie