Hi,
sunrise@sunrise:~/frappe-bench$ bench --site store --force restore /home/ikhlas/Downloads/sun4.sql
MySQL root password:
sh: 1: cannot open /home/ikhlas/Downloads/sun4.sql: No such file
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 162, in _run_module_as_main
“main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/sunrise/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/home/sunrise/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/sunrise/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/home/sunrise/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/home/sunrise/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/sunrise/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/sunrise/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/sunrise/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/home/sunrise/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/sunrise/frappe-bench/apps/frappe/frappe/commands.py”, line 29, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/sunrise/frappe-bench/apps/frappe/frappe/commands.py”, line 138, in restore
_new_site(db_name, site, mariadb_root_username=mariadb_root_username, mariadb_root_password=mariadb_root_password, admin_password=admin_password, verbose=context.verbose, install_apps=install_app, source_sql=sql_file_path, force=context.force)
File “/home/sunrise/frappe-bench/apps/frappe/frappe/commands.py”, line 87, in _new_site
install_db(root_login=mariadb_root_username, root_password=mariadb_root_password, db_name=db_name, admin_password=admin_password, verbose=verbose, source_sql=source_sql,force=force, reinstall=reinstall)
File “/home/sunrise/frappe-bench/apps/frappe/frappe/installer.py”, line 39, in install_db
remove_missing_apps()
File “/home/sunrise/frappe-bench/apps/frappe/frappe/installer.py”, line 313, in remove_missing_apps
installed_apps = json.loads(frappe.db.get_global(“installed_apps”) or “[]”)
File “/home/sunrise/frappe-bench/apps/frappe/frappe/database.py”, line 643, in get_global
return self.get_default(key, user)
File “/home/sunrise/frappe-bench/apps/frappe/frappe/database.py”, line 655, in get_default
d = self.get_defaults(key, parent)
File “/home/sunrise/frappe-bench/apps/frappe/frappe/database.py”, line 661, in get_defaults
defaults = frappe.defaults.get_defaults(parent)
File “/home/sunrise/frappe-bench/apps/frappe/frappe/defaults.py”, line 72, in get_defaults
globald = get_defaults_for()
File “/home/sunrise/frappe-bench/apps/frappe/frappe/defaults.py”, line 179, in get_defaults_for
where parent = %s order by creation"“”, (parent,), as_dict=1)
File “/home/sunrise/frappe-bench/apps/frappe/frappe/database.py”, line 136, in sql
self._cursor.execute(query, values)
File “/home/sunrise/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/sunrise/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, “Table ‘3a21295d81.tabDefaultValue’ doesn’t exist”)
sunrise@sunrise:~/frappe-bench$
@Mohamed_Sajid Make sure that you have the right path, is It Downloads or downloads?
Also your command I think is mistaken, check below:
bench restore SQL_FILE_PATH