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

[Barry <we...@i1...>]

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"
> 
> However, I would strongly recommend against trying to use it on a machine that
> is running out of memory like this .. you'll just end up with broken configurations.

Yeah I know :( I am hoping to find some intermediate workarounds.

Anyway I don't create domains that often, so in the worst case I am 
willing to take down some services for a few minutes to get it done. But 
like you said, if I end up in an incomplete state like this, I'd like to 
be able to recover so webmin/virtualmin is in sync with the actual 
machine config.

Best,

Barry