Sorry for the long title I wasn't sure how else to make it distinct from the auto-search results.
I have a large-ish dump file (~44GB) and I'm trying to import this into MySQL on a different server.
Both servers are running 5.7, though one is 5.7.20 (source) and the other is 5.7.42 (target), on Ubuntu 22.04 LTS. I have, just as a hail mary, installed the latest MySQL 8 server for the OS as the target database server, which produced the same results.
Every attempt to restore the database results in a syntax error, but not always in the same place, and sometimes before or after where the previous run got to.
For example; on run 1 it may error on line 26880, then run 2 it will error on line 14230 (earlier than run 1), then run 3 maybe on line 390290 (later than both of them). Line numbers here are arbitarary but do go up and down, and generally never in the same place twice.
max_allowed_packetis maxed at 1GB
innodb_buffer_pool_sizeis set to 128GB (which is approximately 65% of the available RAM)
Everything else is default. There are no errors listed in the error log.
I have tried other backups, which produce the same result.
The backup is not compressed.
What have I done wrong?