MySQL Backup
MySQL Backup
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
Back to MySQL