Database restore error my old db to new setup

I fallowed below steps for restore db but error.
some one please elaborate steps for restore db
tried several times without good result

chandu@eiplerp:~/frappe-bench$ bench frappe --restore 1bd3e0294d /home/frappe-bench/myback-sites1.sql -f
MySQL root password:
Created user 1bd3e0294d
Created database 1bd3e0294d
Granted privileges to user 1bd3e0294d and database 1bd3e0294d
Starting database import…
sh: 1: cannot open /home/frappe-bench/myback-sites1.sql: No such file
Imported from database /home/frappe-bench/myback-sites1.sql
Traceback (most recent call last):
File “/home/chandu/frappe-bench/env/bin/frappe”, line 9, in
load_entry_point(‘frappe==4.14.0’, ‘console_scripts’, ‘frappe’)()
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 53, in main
return run(fn, parsed_args)
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 67, in new_fn
return fn(*args, **new_kwargs)
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 386, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 317, in _install
admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 37, in install_db
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 206, in remove_missing_apps
installed_apps = frappe.get_installed_apps()
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 418, in get_installed_apps
installed = json.loads(db.get_global(“installed_apps”) or “[]”)
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 446, in get_global
return self.get_default(key, user)
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 459, in get_default
d = frappe.defaults.get_defaults(parent).get(key)
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 52, in get_defaults
userd = get_defaults_for(user)
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 143, in get_defaults_for
where parent = %s order by creation"“”, (parent,), as_dict=1)
File “/home/chandu/frappe-bench/apps/frappe/frappe/”, line 110, in sql
self._cursor.execute(query, values)
File “/home/chandu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/chandu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, “Table ‘1bd3e0294d.tabDefaultValue’ doesn’t exist”)

Please someone adress my issue
Please my live server down for this issue.


@talluri_chandu you should get help from a freelancer on this. Someone might have to take a look.

Btw, we fixed the v5 issue you reported a few days back.

Hi Mehta
can you please sagest someone how know about this ( freelancer )

/home/frappe-bench/myback-sites1.sql doesn’t exist it seems