We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Viewing Manually Added DB in CP
Viewing Manually Added DB in CP
I added several databases via SSH. I am migrating a lot of content from another webserver and did not want to manually create each database from the control panel. How do I get these imported databases to show in the control panel now that they are on the server? I have edited db.conf file in /usr/local/vesta/data/users/admin/ but the databases are still not showing. What am I missing?
New to Vesta, but tried to find answers in forums and search but came up empty on this one.
New to Vesta, but tried to find answers in forums and search but came up empty on this one.
Re: Viewing Manually Added DB in CP
You did right thing, you can try to restart vesta or look at file again, may be you maked mistake?I have edited db.conf file in /usr/local/vesta/data/users/admin/ but the databases are still not showing. What am I missing?
Re: Viewing Manually Added DB in CP
Ok. What is U_DISK in db.conf and how would I find the value for manually added databases. I think this may have been the reason they weren't showing.
Re: Viewing Manually Added DB in CP
It's user id - if you just copy or make similar, it'll be fine.akforsyt wrote:Ok. What is U_DISK in db.conf and how would I find the value for manually added databases. I think this may have been the reason they weren't showing.
For user admin example:
Code: Select all
DB='admin_default' DBUSER='admin_default' MD5='*3C4D7C6CB05404F0E63E62F5E4274C6371A642B1' HOST='localhost' TYPE='mysql' CHARSET='UTF8' U_DISK='1' SUSPENDED='no' TIME='17:42:46' DATE='2015-01-25'
Re: Viewing Manually Added DB in CP
Ok. Found out U_DISK in db.conf actually refers to the disk usage of the database.
Copying new lines to db.conf does not appear to add the existing databases to the control panel. I tried restarting the whole server after adding the new line, but nothing changes. Not a huge deal since they do exist, but it would be nice to see them in the control panel.
Any other suggestions or advice? Alternatively, is there a better way to import many databases?
Copying new lines to db.conf does not appear to add the existing databases to the control panel. I tried restarting the whole server after adding the new line, but nothing changes. Not a huge deal since they do exist, but it would be nice to see them in the control panel.
Any other suggestions or advice? Alternatively, is there a better way to import many databases?
Re: Viewing Manually Added DB in CP
Yeah, it's my bad - disk usage, of course.akforsyt wrote:Ok. Found out U_DISK in db.conf actually refers to the disk usage of the database.
Rebuild user may be?akforsyt wrote:Copying new lines to db.conf does not appear to add the existing databases to the control panel. I tried restarting the whole server after adding the new line, but nothing changes. Not a huge deal since they do exist, but it would be nice to see them in the control panel.Any other suggestions or advice?
It's worked fine in many cases.
Re: Viewing Manually Added DB in CP
Thank you for the very quick replies. Very much appreciated.
Rebuilt the admin user via CLI - v-rebuild-user admin.
Now I see the count of databases is correct both on user page and DB listing, but the database name and info still does not show on the Database page.
Rebuilt the admin user via CLI - v-rebuild-user admin.
Now I see the count of databases is correct both on user page and DB listing, but the database name and info still does not show on the Database page.