I am interested in backing up a WordPress (multisite) website.
Because this WordPress lives on a shared hosting environment, my options (for daily automated backups not managed by most host) are a little limited.
To work around that, I’ve written a simple Bash script that pulls in the files via rsync. That is running perfectly.
To back up the MySQL database, I’ve created a daily Cron job which of course runs serverside. I then use rsync to pull that down into my locally backup archive alongside the files.
I decided to test the MySQL database for restorability today by trying to import it, via phpmyadmin, into another Cpanel.
These are the settings that I used.
The import fails with the following message:
It’s been years since I did much with MySQL databases. Could anybody point me in the right direction to try figure out what exactly is failing? It would be much appreciated.