reconecting databases

Get answers to your questions about color grading, editing and finishing with DaVinci Resolve.
  • Author
  • Message
Offline
User avatar

jamedia

  • Posts: 1159
  • Joined: Sun Apr 14, 2019 7:21 pm
  • Location: Birmingham UK
  • Real Name: Chris Hills

reconecting databases

PostSat Jan 30, 2021 12:56 pm

I have just done a small project. I created a folder. Then created a database in it, then put all the media in a folder in the base folder. So everything is self contained and I can archive the whole lot later.
When I finished the project a week later I wanted to zip up the whole lot and archive it on the NAS.
So I disconnected the database as I would close a library in FCPX.
However now I can't see any way to re-connect the database :-(

In FCPX I have 100's of libraries one per job (which are self contained) and archive these to the NAS complete with all the used and unused media and timelines etc. Therefore the only linraries shown are the current set I am working on.

Of course at any time I can fetch the FCPX library back to the local disk and reopen it. How do I do this with databases in Resolve? I don't want a lit of 100's of databases listed in resolve 90% of which I will never open again but I never know which 10% I will need to reopen
Last edited by jamedia on Sat Jan 30, 2021 5:07 pm, edited 1 time in total.
www.JAmedia.uk
[AMD Ryzen 5950X 16 Core CPU | 128GB Ram | NVIDIA 3080TI 12GB ]
[MB ASUS ProArt B550| C Drive:; 1TB M2 980 Pro | D Drive; 2TB M2 970 EVO ]
[ Win 11 home |Resolve Studio V18.6 | Speed Editor via USB | Scarlett 2i2 3rd Gen| ]
Offline

Jim Simon

  • Posts: 34455
  • Joined: Fri Dec 23, 2016 1:47 am

Re: reconnedting databases

PostSat Jan 30, 2021 2:06 pm

The biggest mistake I made after switching from Premiere Pro was thinking that my previous experience meant I could just jump into a new NLE without difficulty.

Nope. Resolve does things differently, and I had to adjust my work flow in many ways, including my backup and archive methods.

I think your first course of action should be to complete some Resolve training. The Beginner's Guide and Advanced Editing are an excellent groundwork to get you moving smoothly. ;)

https://www.blackmagicdesign.com/produc ... e/training
My Biases:

You NEED training.
You NEED a desktop.
You NEED a calibrated (non-computer) display.
Offline
User avatar

jamedia

  • Posts: 1159
  • Joined: Sun Apr 14, 2019 7:21 pm
  • Location: Birmingham UK
  • Real Name: Chris Hills

Re: reconnedting databases

PostSat Jan 30, 2021 2:19 pm

Jim Simon wrote:The biggest mistake I made after switching from Premiere Pro was thinking that my previous experience meant I could just jump into a new NLE without difficulty.


True... I have used FCPX since it started and that was very intuitive so that no training was needed to get going. I am only moving to Resolve because FCPX is not on PC.

Jim Simon wrote:Nope. Resolve does things differently, and I had to adjust my work flow in many ways, including my backup and archive methods.

So I am discovering. My problem is I have lots of small projects, for many they are one day events. Others are 4 days * 8 hours of video in to 36 separate videos all to be uploaded to 3 different YouTube accounts withing 4 days. This is a breeze with FCPX.

Jim Simon wrote:I think your first course of action should be to complete some Resolve training. The Beginner's Guide and Advanced Editing are an excellent groundwork to get you moving smoothly. ;)

https://www.blackmagicdesign.com/produc ... e/training


Thanks I will have to try that. The problem is finding time to do it when time is at a premium already.

It still doesn't answer my immediate question abut databases. (BTW the DVR manual is not the easiest to use unless you already understand the DVR language and know what to look for. At which point you probably don't need the manual. BTW there is no DVR17 manual in DVR17... only a "new features" which doesn't help/
www.JAmedia.uk
[AMD Ryzen 5950X 16 Core CPU | 128GB Ram | NVIDIA 3080TI 12GB ]
[MB ASUS ProArt B550| C Drive:; 1TB M2 980 Pro | D Drive; 2TB M2 970 EVO ]
[ Win 11 home |Resolve Studio V18.6 | Speed Editor via USB | Scarlett 2i2 3rd Gen| ]
Offline

Jim Simon

  • Posts: 34455
  • Joined: Fri Dec 23, 2016 1:47 am

Re: reconnedting databases

PostSat Jan 30, 2021 2:22 pm

jamedia wrote:This is a breeze with FCPX.

I think it is with Resolve as well. It's just done differently.

(And those training manuals are a gentle easing into the Resolve ecosystem. Not quite as intimidating as the full Reference Manual, which you noticed isn't yet available for 17 anyway. But the Beginner's Guide and Advanced Editing will apply nonetheless.)
My Biases:

You NEED training.
You NEED a desktop.
You NEED a calibrated (non-computer) display.
Offline

Jim Simon

  • Posts: 34455
  • Joined: Fri Dec 23, 2016 1:47 am

Re: reconnedting databases

PostSat Jan 30, 2021 2:27 pm

So to point you in the right direction, don't disconnect and reconnect databases as you would Libraries.

Keep your databases online, and ideally located on their own dedicated, internal drive.

Copy all the media to your backup location as a first step. Copy it to your working Media drive as a second step. Even before you begin editing, you've got your 'archive' done.

Backup your databases and export your projects regularly.
My Biases:

You NEED training.
You NEED a desktop.
You NEED a calibrated (non-computer) display.
Offline
User avatar

jamedia

  • Posts: 1159
  • Joined: Sun Apr 14, 2019 7:21 pm
  • Location: Birmingham UK
  • Real Name: Chris Hills

Re: reconnedting databases

PostSat Jan 30, 2021 5:06 pm

Jim Simon wrote:So to point you in the right direction, don't disconnect and reconnect databases as you would Libraries.

Keep your databases online, and ideally located on their own dedicated, internal drive.


I have several 100 FCPX libraries but only half a dozen on my local drives. I don't want 100's of projects listed locally. Only the ones I am working on. Also the FCPX linraries are self contained. I can load them to any other computer (even one not on the network)

Jim Simon wrote:Copy all the media to your backup location as a first step. Copy it to your working Media drive as a second step. Even before you begin editing, you've got your 'archive' done.

not really, The FCPX has all the time lines projects etc. there is more to it than just the clips.

Jim Simon wrote:Backup your databases and export your projects regularly.

this seems more cumbersum than the FCPX method. I will have to read up on it.
www.JAmedia.uk
[AMD Ryzen 5950X 16 Core CPU | 128GB Ram | NVIDIA 3080TI 12GB ]
[MB ASUS ProArt B550| C Drive:; 1TB M2 980 Pro | D Drive; 2TB M2 970 EVO ]
[ Win 11 home |Resolve Studio V18.6 | Speed Editor via USB | Scarlett 2i2 3rd Gen| ]
Offline

Jim Simon

  • Posts: 34455
  • Joined: Fri Dec 23, 2016 1:47 am

Re: reconnedting databases

PostSat Jan 30, 2021 7:15 pm

jamedia wrote:I don't want 100's of projects listed locally.

So organize them with folders in the database.
My Biases:

You NEED training.
You NEED a desktop.
You NEED a calibrated (non-computer) display.
Offline

Jim Simon

  • Posts: 34455
  • Joined: Fri Dec 23, 2016 1:47 am

Re: reconnedting databases

PostSat Jan 30, 2021 7:15 pm

jamedia wrote:I will have to read up on it.

Yup. ;)
My Biases:

You NEED training.
You NEED a desktop.
You NEED a calibrated (non-computer) display.
Offline
User avatar

jamedia

  • Posts: 1159
  • Joined: Sun Apr 14, 2019 7:21 pm
  • Location: Birmingham UK
  • Real Name: Chris Hills

Re: reconnedting databases

PostSat Jan 30, 2021 8:44 pm

Jim Simon wrote:
jamedia wrote:I don't want 100's of projects listed locally.

So organize them with folders in the database.


That's starting to sound messy. an nothing like as sensible as FCPX :-(
Are you saying that ALL my projects have to be listed in my Database? Including the archived ones? I can't just unload them (and potentially reload them later)?

I have a dozen external hard drives with archived FCPX libraries (apart from recent projects on the NAS and current ones locally) . It is as simple as moving word documents around the place and in the same way I can load them easily in to any FCPX on any of our Mac's just as easily as opening a word doc.
www.JAmedia.uk
[AMD Ryzen 5950X 16 Core CPU | 128GB Ram | NVIDIA 3080TI 12GB ]
[MB ASUS ProArt B550| C Drive:; 1TB M2 980 Pro | D Drive; 2TB M2 970 EVO ]
[ Win 11 home |Resolve Studio V18.6 | Speed Editor via USB | Scarlett 2i2 3rd Gen| ]
Offline

xunile

  • Posts: 3109
  • Joined: Mon Apr 23, 2018 5:21 am
  • Real Name: Eric Eisenmann

Re: reconecting databases

PostSat Jan 30, 2021 8:50 pm

Have you tried clicking the Restore button under the database section of the Project Manager?
Attachments
2021-01-30 (4).png
2021-01-30 (4).png (566.14 KiB) Viewed 750 times
Win 10 Home | Intel i7 - 10700f 64 GB 1 TB GB SSD 2 TB SSD
RTX-3060 12 GB | Resolve Studio 18.6.6| Fusion Studio 18.6.6

Win 10 Home | Intel Core I7-7700HQ 32 GB 1 TB NVME SSD 1 TB SATA SSD
GTX-1060-6GB | Resolve 17.4.6
Offline
User avatar

jamedia

  • Posts: 1159
  • Joined: Sun Apr 14, 2019 7:21 pm
  • Location: Birmingham UK
  • Real Name: Chris Hills

Re: reconecting databases

PostSat Jan 30, 2021 9:30 pm

xunile wrote:Have you tried clicking the Restore button under the database section of the Project Manager?


Sorted!!!!
I could not for the life of me understand why there was a "disconnect" if you can't reconnect. (as the dialogue says wen you disconnect,)

Initially when I created the database I created a folder for it, created it and opened it. Then I copied the Media into the a new folder in the same root folder. So everything was in the same folder. see diagram, All the Media is in Bin1

What I just tried was in he database manager hitting "open database" and then (without first creating a database) pointing "location" at the root directory, gave it a name and it worked!!!! Sensible! but not possible according to the Database dialogue when you disconnect...
Attachments
Capture.PNG
Capture.PNG (12.39 KiB) Viewed 753 times
www.JAmedia.uk
[AMD Ryzen 5950X 16 Core CPU | 128GB Ram | NVIDIA 3080TI 12GB ]
[MB ASUS ProArt B550| C Drive:; 1TB M2 980 Pro | D Drive; 2TB M2 970 EVO ]
[ Win 11 home |Resolve Studio V18.6 | Speed Editor via USB | Scarlett 2i2 3rd Gen| ]
Offline

Mario Kalogjera

  • Posts: 1202
  • Joined: Sat Oct 31, 2015 8:44 pm

Re: reconecting databases

PostSun Jan 31, 2021 12:07 am

Yeah, also the default behavior when you select "new database" (only choice if you wan to reconnect), is to connect to existing one and not create a new one even though your intuition says it should be "create".
Asus Prime X370-Pro+R7 3700X@PBO+32 GB G.Skill AEGIS DDR-4@3200MHz
Sapphire RX6700 10GB
Adata A400 120GB System,A2000 500GB Scratch SSDs
Media storage:"Always in motion is it"
BMD Mini Monitor 4K
Windows 11 Pro+Resolve Studio 18+Fusion Studio 18
Offline
User avatar

jamedia

  • Posts: 1159
  • Joined: Sun Apr 14, 2019 7:21 pm
  • Location: Birmingham UK
  • Real Name: Chris Hills

Re: reconecting databases

PostSun Jan 31, 2021 11:35 am

Mario Kalogjera wrote:Yeah, also the default behavior when you select "new database" (only choice if you wan to reconnect), is to connect to existing one and not create a new one even though your intuition says it should be "create".


Also when you disconnect a database the dialogue says this can't be undone. However as I have just proved it can be undone!

Confusing thing is that when you put in the path to the folder (not a file which initially confused me) you also have to name the database. It appears you can put anything here.... It does not need to be the same name as the database you disconnected. Neither does it pick up the original name when you re-connect.

The disconnecting and reconnecting of databases need to be looked at. I think Resolve is designed to work on one fixed use case that I suspect the majority of it's users are not using
www.JAmedia.uk
[AMD Ryzen 5950X 16 Core CPU | 128GB Ram | NVIDIA 3080TI 12GB ]
[MB ASUS ProArt B550| C Drive:; 1TB M2 980 Pro | D Drive; 2TB M2 970 EVO ]
[ Win 11 home |Resolve Studio V18.6 | Speed Editor via USB | Scarlett 2i2 3rd Gen| ]
Offline

Mario Kalogjera

  • Posts: 1202
  • Joined: Sat Oct 31, 2015 8:44 pm

Re: reconecting databases

PostSun Jan 31, 2021 11:58 am

It asks for a new name because you selected new database option, I suppose - a logic that doesn't extend to other options.

However, I think I don't get the warning massage that says it can't be undone. That's in 16.8.x. ,may be different in R17...

Anyway, "undone" seems to refer just to that current action at hand, doesn't imply you will never be able to reconnect.

Sent from my Mi 9T using Tapatalk
Asus Prime X370-Pro+R7 3700X@PBO+32 GB G.Skill AEGIS DDR-4@3200MHz
Sapphire RX6700 10GB
Adata A400 120GB System,A2000 500GB Scratch SSDs
Media storage:"Always in motion is it"
BMD Mini Monitor 4K
Windows 11 Pro+Resolve Studio 18+Fusion Studio 18
Offline

Jim Simon

  • Posts: 34455
  • Joined: Fri Dec 23, 2016 1:47 am

Re: reconnedting databases

PostSun Jan 31, 2021 1:47 pm

jamedia wrote:Are you saying that ALL my projects have to be listed in my Database? Including the archived ones? I can't just unload them (and potentially reload them later)?

Essentially, yes.

It's just the way databases work.
My Biases:

You NEED training.
You NEED a desktop.
You NEED a calibrated (non-computer) display.
Offline
User avatar

jamedia

  • Posts: 1159
  • Joined: Sun Apr 14, 2019 7:21 pm
  • Location: Birmingham UK
  • Real Name: Chris Hills

Re: reconnedting databases

PostSun Jan 31, 2021 7:33 pm

[quote= Simon""Jim]
jamedia wrote:Are you saying that ALL my projects have to be listed in my Database? Including the archived ones? I can't just unload them (and potentially reload them later)?

Essentially, yes.

It's just the way databases work.[/quote]

Actually no. I have found a way of disconnecting databases and then later reconnecting them.
So I have found a way or replicating the principal of FCPX Libraries in Resolve.
www.JAmedia.uk
[AMD Ryzen 5950X 16 Core CPU | 128GB Ram | NVIDIA 3080TI 12GB ]
[MB ASUS ProArt B550| C Drive:; 1TB M2 980 Pro | D Drive; 2TB M2 970 EVO ]
[ Win 11 home |Resolve Studio V18.6 | Speed Editor via USB | Scarlett 2i2 3rd Gen| ]
Offline

Jim Simon

  • Posts: 34455
  • Joined: Fri Dec 23, 2016 1:47 am

Re: reconecting databases

PostSun Jan 31, 2021 11:49 pm

Well, editors choice, but...it's less than ideal.
My Biases:

You NEED training.
You NEED a desktop.
You NEED a calibrated (non-computer) display.
Offline
User avatar

jamedia

  • Posts: 1159
  • Joined: Sun Apr 14, 2019 7:21 pm
  • Location: Birmingham UK
  • Real Name: Chris Hills

Re: reconecting databases

PostMon Feb 01, 2021 9:23 am

Jim Simon wrote:Well, editors choice, but...it's less than ideal.


What is less than Ideal? The design of DVR? in which case I agree.
www.JAmedia.uk
[AMD Ryzen 5950X 16 Core CPU | 128GB Ram | NVIDIA 3080TI 12GB ]
[MB ASUS ProArt B550| C Drive:; 1TB M2 980 Pro | D Drive; 2TB M2 970 EVO ]
[ Win 11 home |Resolve Studio V18.6 | Speed Editor via USB | Scarlett 2i2 3rd Gen| ]

Return to DaVinci Resolve

Who is online

Users browsing this forum: Bing [Bot], Mads Johansen, panos_mts, sjubussen and 298 guests