Database restore (force)

Hi,
How To Restore The Database into Already Exists database…For Eg…Already I m Use Datbase As home …Now i m create a new empty databses as service…when i restore the Database Using Ths Comment In Bench
frappe --restore service 20150225_65613334_database.sql
The Error Is database service Is Already Exists…

Please …
Thanks

Try the -f option like, frappe restore ... -f

Hi rmehta…
This Error Is Occured IN terminal…When Restore database Using -f (Force)…

ikhlas1@ikhlas1:~/bench/sites$ frappe --restore clean 20150225_65613334_database.sql -f
MySQL root password:
Created user cserv
Created database cserv
Granted privileges to user cserv and database cserv
Starting database import…
Imported from database 20150225_65613334_database.sql
Traceback (most recent call last):
File “/usr/local/bin/frappe”, line 9, in
load_entry_point(‘frappe==4.7.1’, ‘console_scripts’, ‘frappe’)()
File “/home/ikhlas1/bench/apps/frappe/frappe/cli.py”, line 53, in main
return run(fn, parsed_args)
File “/home/ikhlas1/bench/apps/frappe/frappe/cli.py”, line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File “/home/ikhlas1/bench/apps/frappe/frappe/cli.py”, line 67, in new_fn
return fn(*args, **new_kwargs)
File “/home/ikhlas1/bench/apps/frappe/frappe/cli.py”, line 378, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)
File “/home/ikhlas1/bench/apps/frappe/frappe/cli.py”, line 309, in _install
admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)
File “/home/ikhlas1/bench/apps/frappe/frappe/installer.py”, line 39, in install_db
create_auth_table()
File “/home/ikhlas1/bench/apps/frappe/frappe/installer.py”, line 71, in create_auth_table
) ENGINE=InnoDB DEFAULT CHARSET=utf8"“”)
File “/home/ikhlas1/bench/apps/frappe/frappe/database.py”, line 162, in sql_ddl
self.commit()
File “/home/ikhlas1/bench/apps/frappe/frappe/database.py”, line 479, in commit
self.sql(“commit”)
File “/home/ikhlas1/bench/apps/frappe/frappe/database.py”, line 79, in sql
self.connect()
File “/home/ikhlas1/bench/apps/frappe/frappe/database.py”, line 49, in connect
use_unicode=True, charset=‘utf8’)
File “/usr/local/lib/python2.7/dist-packages/MySQL_python-1.2.5-py2.7-linux-i686.egg/MySQLdb/init.py”, line 81, in Connect
return Connection(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/MySQL_python-1.2.5-py2.7-linux-i686.egg/MySQLdb/connections.py”, line 193, in init
super(Connection, self).init(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, “Access denied for user ‘clean’@‘localhost’ (using password: YES)”)
ikhlas1@ikhlas1:~/bench/sites$

Thanks…

Invalid db password!

I m Use Only One Passwd For All Site…
Ok u hav Any idea About Ths invalid Passwd…

> How To Restore The Database With Existing Database???

Thanks.

Hi. Mohamed_Sajid.
You can restore by Phpmyadmin.
Jack Le.

Hi.
How ll restore through the phpmyadmin???
Please Give Some idea…give some refrence website

thanks…

Hi.

  1. You install phpmyadmin
  2. You use phpmyadmin to restore database.
    Jack Le

Ok …I tyr it Come Back…
Thanks