Hi
I fallowed below steps for restore db but error.
://discuss.frappe.io/t/i-want-to-install-erpnext-on-my-local-host/4099/23
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/cli.py”, line 53, in main
return run(fn, parsed_args)
File “/home/chandu/frappe-bench/apps/frappe/frappe/cli.py”, line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File “/home/chandu/frappe-bench/apps/frappe/frappe/cli.py”, line 67, in new_fn
return fn(*args, **new_kwargs)
File “/home/chandu/frappe-bench/apps/frappe/frappe/cli.py”, line 386, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)
File “/home/chandu/frappe-bench/apps/frappe/frappe/cli.py”, 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/installer.py”, line 37, in install_db
remove_missing_apps()
File “/home/chandu/frappe-bench/apps/frappe/frappe/installer.py”, line 206, in remove_missing_apps
installed_apps = frappe.get_installed_apps()
File “/home/chandu/frappe-bench/apps/frappe/frappe/init.py”, line 418, in get_installed_apps
installed = json.loads(db.get_global(“installed_apps”) or “[]”)
File “/home/chandu/frappe-bench/apps/frappe/frappe/database.py”, line 446, in get_global
return self.get_default(key, user)
File “/home/chandu/frappe-bench/apps/frappe/frappe/database.py”, line 459, in get_default
d = frappe.defaults.get_defaults(parent).get(key)
File “/home/chandu/frappe-bench/apps/frappe/frappe/defaults.py”, line 52, in get_defaults
userd = get_defaults_for(user)
File “/home/chandu/frappe-bench/apps/frappe/frappe/defaults.py”, line 143, in get_defaults_for
where parent = %s order by creation"“”, (parent,), as_dict=1)
File “/home/chandu/frappe-bench/apps/frappe/frappe/database.py”, line 110, in sql
self._cursor.execute(query, values)
File “/home/chandu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/chandu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, “Table ‘1bd3e0294d.tabDefaultValue’ doesn’t exist”)