Tag Archive: databases

December 11, 2019 / by Marco / backup, database, databases, mysql, mysqldump, script, vestacp, zip

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 […]

September 26, 2014 / by Marco / check, databases, show, use

How to Check and Repair MySQL Tables Using MySQLcheck

For some reason my WordPress site was not displaying the correct information. The site uses WooCommerce and the products was not displaying at all. This was quite strange. I thought I’d better backup the database so when I did, I received the following error message: mysqldump: Got error: 145: Table ‘./xxx/wp_postmeta’ is marked as crashed […]