MySQL Backup

MySQL Backup

• mysqldump
• MySQL backup all databases
• MySQL Backup using mysqldump
• Plesk MySQL Daily Backup Script

Backup Services

• https://sqlbak.com/ – Free for 1 server, 2 databases
• https://simplebackups.com – Free plan supprt 1 database

MySQL Backup Tricks

• Extract Backup of one database from mysqldump all databases
• Export MySQL Database table as an XML Document
• Split mysqldump backup file into tables

MySQL Restore Errors

• MySQL Unknown collation: utf8mb4_unicode_520_ci
• ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_ci’
• MySQL Unknown collation: ‘utf8mb4_0900_ai_ci’
• MySQL ERROR 1193 Unknown system variable GTID_PURGED
• MySQL ERROR Access denied you need SUPER privilege for this operation
• sshpass

MySQL Backup Errors

• mysqldump errno: 24 Can’t open file when using LOCK TABLES