Getting error while restoring a database

Can anyone help me mitigate this?

erpman@localhost:~/frappe-bench$ mysql -u root -p 1bd3e0294da19198 < databases-one.sql;
Enter password:
ERROR 1064 (42000) at line 1: 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 ’

<meta id="bb-bootstrap" data-current-u' at line 1

Thank you

use this for restore database:

bench --site [sitename] --force restore /path to SQLFILE

erpman@localhost:~/frappe-bench$ bench --site site1.local --force restore databases-one.sql
MySQL root password:
ERROR 1064 (42000) at line 1: 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 ’

<meta id="bb-bootstrap" data-current-u' at line 1 Database not installed, this can due to lack of permission, or that the database name exists. Check your mysql root password, or use --force to reinstall

There must have been some data corruption during your update. Although this link is probably NOT the recommended way to fix it, it seems to work OK

1 Like