[Nigel Askew]

Yeah, i’ll send an email today,

I’ve cleared the old database, just wondering if you have any guidelines for backing up and restoring the database for cat dv, we’re currently using mysql administrator:

https://mac-free.com/download/MySQL-Administrator.html

to make a back up of the database,

i tried to restore from the back up using the same program but it didn’t work very well

thanks

gene

[Nigel Askew]

cool, well thanks again, this is going to save me so much time, and perhaps if someone else comes to you with the same problem it will help them too 🙂

[Nigel Askew]

I FIGURED IT OUT 😀

i did a search and replace ON the semi-colon character ;

it worked perfectly, goodness knows why my copy works like this, but i’ve managed it, so i’m pretty happy now, that’s going to save me hours of work.

i appreciate your patient help, i know how frustrating remote support can be, thanks very much

[Nigel Askew]

Sorry, it’s early, i understand what you mean now

i had tried both /n and \n and left the incorrect one in for the screen shot, but i tried both

it doesn’t seem to want to find ‘, ‘ at all, it said ‘0 clip(s) updated’ and didn’t put the incorrect ‘/n’ in when i tried that, as you imagine it would

i don’t know why it’s not recognising the comma, it’s the same whether i have regular expressions turned on or off,

maybe you could make a new catalog where you are, enter some values with some commas in and attempt to search and replace them if you have time, if not don’t worry, it would just help to know i’m not missing something obvious

[Nigel Askew]

“Are you seeing this like 40s/n50s/nfeminine?”

Sorry, i’m not sure what you mean, I’m seeing it in CatDV as it appears in the picture, with commas in it. That field (themes/trends/styles) has all sorts of different values in it, and sometimes they’ve been separated by commas.

the quickest way i’ve found of correcting the commas is to group by the field i’m checking for that catalogue (themes/trends… for example) and scanning down the list of terms until I see a value like ’40s, 50s, feminine’ which sticks out for it’s length. then i go in, click on the star at the end of the text box, type each value seperately and tab down to the plus sign, then back up for the next one. once they’re all in i remove the original value. as you can imagine this is quite time consuming.

i was hoping i would be able to use the settings in the picture i sent to replace the comma with a semi colon or a \n to seperate the values that have already been entered.

[Nigel Askew]

Hi Rolf,

Thanks very much for your message, I have previously tried what you suggested on 8.1.1 and it didn’t work, and i’ve just downloaded 8.1.2 and it still doesn’t seem to want to work.

Here’s a picture showing what settings i’m using (there’s a space after the comma) and the offending field with the commas in,

https://i47.tinypic.com/wj8f0g.png

let me know what you think,

thanks,

[Nigel Askew]

Sorry, i’m in a hurry so i’ve missed some details out, i’ve tried exporting using quicktime conversion and with compressor, similar times in both.

thanks

[Nigel Askew]

scratch what i said about the macbook export time, it’s giving me the same time as the mac pro, which still doesn’t seem right for the mac pro

thanks

[Nigel Askew]

Yeah, the AJA IO La that was only thing I could find that might help, I appreciate everyone’s curteous responses, usually when we post questions on here I get shot into the ground with accusations of eco-unfriendly codecs, explotative container formats and sociopathic workflows, I’ll have a think.

We may capture it all uncompressed using a black magic card on the PC and convert it to pro res on the mac after.

[Nigel Askew]

thanks for replying so quickly

is there a free way of doing this? it looks like disk warrior does whole drives, i just want to recover one file for now, messing with the whole drive directory seems a bit scary with 12TB

thanks