Solved it by creating an update sql command from the backup insert sql, saving in a file using Notepad++, and imported via phpmyadmin. Maybe there had been an issue with extra newline characters or missing backslash escape characters when I tried before.
