backup – Can’t import MySQL database from mysqldump

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.

enter image description here

The import fails with the following message:

enter image description here

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.