Restoring DB from Version 9 develop to version-11 Master (production)

[AnthonyS]

in reference to this post

How to restore a database from a backup (bench backup & bench restore)?

Continuing the discussion from Try Bench Restore?: can’t confirm this is what actually happens. Getting an Exception: Database [database_name] already exits. instead. So there is at least one step missing in between. my workflow cd frappe-bench bench backup (this creates a new file in /sites/my_site/private/backups) delete a Sales Invoice in my ERPNext instance `bench restore \path\to\backupfile.sql.gz do you need to create new empty db first? How would u practically do that? this older…

it was creating the db while restoring it, i got this error
ERROR 1227 (42000) at line 24879: Access denied; you need (at least one of) the SUPER privilege(s) for this operation.
i used the commands that bkm shared

gunzip yourbackupfile.sql.gz
sudo bench --force --site your.site.name restore /path.to.your.sql.file

EDIT: It restores couple data not everything i think it stops when it reaches the error above.

EDIT: i removed these lines
/*!50013 DEFINER=root@localhost SQL SECURITY DEFINER */
there were like 5 of them which was causing the security error from the sql file.
now my problem is i can’t login through any of the restored users.
it just stuck on verifying…
while opening the console from the browser this is what i get

Failed to load resource: the server responded with a status of 500 ()
website.js:162 Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 58, in application
    init_request(request)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 120, in init_request
    frappe.local.http_request = frappe.auth.HTTPRequest()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 51, in __init__
    frappe.local.login_manager = LoginManager()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 105, in __init__
    if self.login()==False: return
  File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 126, in login
    self.authenticate(user=user, pwd=pwd)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 209, in authenticate
    self.check_if_enabled(user)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 215, in check_if_enabled
    if cint(doc.allow_consecutive_login_attempts) > 0:
AttributeError: 'SystemSettings' object has no attribute 'allow_consecutive_login_attempts'

how to proceed with this error if anyone encountered it?