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.

Then use this bash script. You […]

read more

September 26, 2014   /   by Marco   /   , , ,

How to Check and Repair MySQL Tables Using MySQLcheck

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

read more