mbrestore tool says: file is encrypted or is not a database
I have copied the default, default-0.mb, default-1.mb, default-2.mb, default-3.mb files from the one membase single node machine and moved it on to another machine. I'm trying to copy the data over to the other machine and I'm getting the following error:
C:\Program Files\Membase\Server\bin\ep_engine\management>mbrestore.exe -a "C:\Pr
ogram Files\Membase\Server\data\bu_ns_1\default" "C:\Program Files\Membase\Serve
r\data\bu_ns_1\default-0.mb" "C:\Program Files\Membase\Server\data\bu_ns_1\defau
lt-1.mb" "C:\Program Files\Membase\Server\data\bu_ns_1\default-2.mb" "C:\Program
Files\Membase\Server\data\bu_ns_1\default-3.mb"
Traceback (most recent call last):
File "mbrestore", line 151, in <module>
for db_name in attached_dbs:
File "mbrestore", line 109, in main
parser.add_option("-a", "--add", action="store_true", default=False,
sqlite3.DatabaseError: file is encrypted or is not a database
Could anyone help me with what is going on?
Thanks,
-Sandeep
I believe we corresponded over our jira issue here: http://www.couchbase.org/issues/browse/MB-3360
Basically, in pre-1.7 you need to run: /opt/membase/bin/ep_engine/management/sqlite3 default 'pragma journal_mode=delete' on all the files before using the restore.
If you download 1.7, you can use the mbrestore script provided there and not have to use that workaround.
Perry
Forum support is great for free but sometimes you need a guaranteed response time and dedicated resources for your questions or issues.
Consider purchasing enterprise-level support from Couchbase: http://www.couchbase.com/products-and-services/overview
Call or email "sales -at- couchbase-dot- com" today!