change domain name

This feature works great. thanks.

Here is a small bug (or feature request):

There should be also an option to change the database name as well.

Status: 
Closed (fixed)

Comments

I see, webmin doesn't have the ability to rename the database either. I guess it is very difficult to rename a mysql database, right?

But the following could be a bug.

I renamed domain.net to test.net. It looks like that virtualmin also created a database test with zero tables. However this new database "test" is not associated with the new domain (but the old database "domain" still is).

(or maybe something else created table "test" without my knowledge, but it currenlty it looks like that virtualmin created the table).

Yes, renaming a MySQL database is basically impossible - the only way it could be done is by dumping the entire DB contents to a file, deleting the old DB, creating a new one and then re-importing. And even then there are some settings that may not be included in the file ... and any scripts that referred to the old database name would be broken.

Regarding that test database, are you sure it didn't already exist?

It is possible, that Joomla created an empty database test (I started joomla exactly once and then realized that I had the "wrong" db name in the config file). I will do some more tests.

I can not reproduce this, so it looks like "something else" must have created that empty database (although that database was not shown before the rename :-)

But here is a small bug I found.

If you click on "virtual server -> edit databases -> manage" and then click on "return to database list", then all databases are displayed ("webmin view for mysql"). Which is probably not correct?

Does that display of all databases happen when logged in as root, or as a domain owner? It is expected for root, since he does have access to all DBs ..

It is root and I understand that the root user has access to all databases.

But in my opinion "return to database list" implies that vm would return to the previous view (which is the view for only one server). Could be especially important if there are many databases and many virtual servers.

If root wanted to see all databases, then root would have probably used the webmin mysql view in the first place?

Actually, those return links will be fixed by a combination of the next Webmin and Virtualmin releases..

Automatically closed -- issue fixed for 2 weeks with no activity.

Hi, just an update regarding:

Actually, those return links will be fixed by a combination of the next Webmin and Virtualmin releases.

Looks like the recent VM 3.93 update didn't fixed the return links?

Do you also have Webmin 1.590 installed? It is needed to fix this ..

yes, webmin 1.5.90 installed as well.

Hmmm .. could you tell the me sequence of links you are clicking on when you see this problem?

Exactly as described above:

If you click on "virtual server -> edit databases -> manage" and then click on "return to database list", then all databases are displayed ("webmin view for mysql"). Which is probably not correct?

Are you logged in as root when doing this, or a domain owner?

Yes, see answers 6 to 8 in this thread:

6 Does that display of all databases happen when logged in as root, or as a domain owner? It is expected for root, since he does have access to all DBs ..

Posted by JamieCameron on Tue, 2012-06-19 06:47

7 It is root and I understand that the root user has access to all databases.

But in my opinion "return to database list" implies that vm would return to the previous view (which is the view for only one server). Could be especially important if there are many databases and many virtual servers.

If root wanted to see all databases, then root would have probably used the webmin mysql view in the first place?

Posted by helpmin on Tue, 2012-06-19 07:15

8 Status: active ยป fixed

Actually, those return links will be fixed by a combination of the next Webmin and Virtualmin releases..

Posted by JamieCameron on Tue, 2012-06-19 07:18

Ok, the issue is that it doesn't current work for root .. I'll look into fixing that.

Webmin 1.600 will really properly fix this.