Open and merge *.db files

If you are experiencing problems with "Everything", post here for assistance.
Post Reply
sekera
Posts: 12
Joined: Tue Apr 11, 2023 4:13 am

Open and merge *.db files

Post by sekera »

Hello
1. How to open *.db file (which i copied for backup) ? efu file is a 5 times larger (888 MB-efu vs 145 MB-db)
2. If I have two *.db files - can i merge them to one *.db file ?
void
Developer
Posts: 16681
Joined: Fri Oct 16, 2009 11:31 pm

Re: Open and merge *.db files

Post by void »

1. How to open *.db file (which i copied for backup) ? efu file is a 5 times larger (888 MB-efu vs 145 MB-db)
Either:

Use db2efu

-or-

Make sure Everything is not running (File -> Exit)
Open in Everything with:
Everything.exe -db "c:\backup\Everything.db" -read-only
From the File menu, click Export...



EFU files are raw editable text. (technically EFU files are CSV files)
DB files are slightly compressed.


2. If I have two *.db files - can i merge them to one *.db file ?
No.
You could convert both DBs to EFU files and manually merge them.
sekera
Posts: 12
Joined: Tue Apr 11, 2023 4:13 am

Re: Open and merge *.db files

Post by sekera »

Thanks for fast answer!
You could convert both DBs to EFU files and manually merge them.
If anybody will add merge plugin or merge soft for *.db or for *.efu - it will be very usefull !
Because manually merge 5 000 000 stings + 10 000 000 strings - it is need a strong PC with at least 32 GB or 64 GB RAM
And not any txt-soft will open 10 million strings. AkelPad is opening it about 5-10 minutes. (after it you need to open second efu, and copy strings, etc - it s about a 30 minutes for one merging)
Excel maximum strings (rows) is 1 million on a sheet
Just try manually merge two efu files with 5 000 000 strings(files) each, without any special soft, Notepad can not even open 500 MB txt-efu files
Last edited by sekera on Tue Apr 11, 2023 4:46 am, edited 1 time in total.
void
Developer
Posts: 16681
Joined: Fri Oct 16, 2009 11:31 pm

Re: Open and merge *.db files

Post by void »

Everything 1.5 will have the option to merge file lists with the File List Editor:
  • In Everything 1.5, from the Tools menu, click File List Editor.
  • From the File menu, click Import....
  • Select file list 1 and click Open.
  • From the File menu, click Import....
  • Select file list 2 and click Open.
    (optionally, from the Tools menu, click Remove duplicates)
  • From the File menu, click Save As....
  • Choose a filename and click Save.
sekera
Posts: 12
Joined: Tue Apr 11, 2023 4:13 am

Re: Open and merge *.db files

Post by sekera »

void wrote: Tue Apr 11, 2023 4:46 am Everything 1.5 will have the option to merge file lists with the File List Editor:
Wow! Awaiting 1.5
Have a nice day, man
sekera
Posts: 12
Joined: Tue Apr 11, 2023 4:13 am

Re: Open and merge *.db files

Post by sekera »

void wrote: Tue Apr 11, 2023 4:46 am In Everything 1.5
from the Tools menu, click File List Editor.
From the File menu, click Import....
Tested Everything-1.5.0.1341a.x64
Seems working good and fast
Now I have 19 million strings and 2.63 Gb efu file, heh
Post Reply