Tag Archive: databases

December 11, 2019   /   by Marco   /   , , , , , , ,

SCRIPT TO BACKUP ALL MYSQL DATABASES IN VESTACP

SCRIPT TO BACKUP ALL MYSQL DATABASES IN VESTACP

If you have multiple databases hosted on VestaCP the easiest way I found to backup all the databases is to use a script. The first thing you need to do is create a backup account in mySQL that has view only access to all the databases. CREATE USER ‘backupuser’@’localhost’ IDENTIFIED BY ‘xxx’; GRANT SELECT, SHOW […]

read more