Tag Archive: database

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

March 19, 2019   /   by Marco   /   , , , , ,

HOW TO FIX DELETING A TABLE THAT DOESN’T EXIST

HOW TO FIX DELETING A TABLE THAT DOESN’T EXIST

In my mySQL database I noticed that there was a table missing from phpmyadmin. I tried creating the table but mySQL reported that it already exist (it was a ghost table). I tried using mysqlcheck to repair the database and it came back saying it the table didn’t exist. I then tried to create the table and […]

read more