Add existing DB to Vesta panel
-
bannedillo
- Posts: 7
- Joined: Wed Nov 22, 2017 8:43 am
Add existing DB to Vesta panel
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.
How can I add this existing databases to Vesta panel, without losing data or changing login and password?.
Thanks in advance.
-
mehargags
- Support team
- Posts: 1096
- Joined: Sat Sep 06, 2014 9:58 pm
- Contact:
- Os: Debian 8x
- Web: apache + nginx
Re: Add existing DB to Vesta panel
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.
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.