Db upload error in cPanel

Question

I am getting the below when uploading DB to cPanel via both phpmyadmin and terminal

Can anyone advice on this?

<div class="alert alert-danger" role="alert"><h1>Error</h1><p><strong>SQL query:</strong>  <a href="#" class="copyQueryBtn" data-text="SET SQL_QUOTE_SHOW_CREATE = 1">Copy</a>

<a href="index.php?route=/database/sql&sql_query=SET+SQL_QUOTE_SHOW_CREATE+%3D+1&show_query=1&db=homoeopaedia"><span class="text-nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit">&nbsp

-------------

ERROR 1064 (42000) at line 1251371: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<div class="alert alert-danger" role="alert"><h1>Error</h1><p><strong>SQL que...' at line

Answer 1

I did face this error before, it was because the taken db dump was corrupt, I did take again via the command line using
mysqldump -u "dbuser" -p "dbname" > backup.sql

then restore using

mysql -u "dbuser" -p "dbname" < backup.sql