Page 1 of 1

Add existing DB to Vesta panel

Posted: Wed Nov 22, 2017 8:46 am
by bannedillo
I have some mysql databases, but I want to make backups of that Mysql databases with vesta panel. If I go to phpmyadmin, I can see all databases, but not in vestal panel DB.

How can I add this existing databases to Vesta panel, without losing data or changing login and password?.


Thanks in advance.

Re: Add existing DB to Vesta panel

Posted: Wed Nov 22, 2017 1:52 pm
by mehargags
For VestaCP Managed DBs
login as admin, Goto Backup and Do a Full Backup. This set will have all your DBs inside specific User folders.

You may also refer this custom backup script Dpecca made for me last year

customize backup script
Read till the end

For DBs that were made out of VestaCP, you will have to backup manually using some custom script or using mysqldump one by one, then create them in VestaCP and restore from the Dump file. You can script this a bit using VestaCP CLI but that'll be a bit advanced for you.