Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[MarkCoutinho]

Hi all,

I just checked the Wiki page of MC, but there seems to be no command for backing up the library.
Is that true or is there a way to do that by command line?

[Matt]

You can do it with an MCC.

20011
MCC_BACKUP_LIBRARY,                            // [int nMode (0: normal, 1: silent automatic backup)]

[MarkCoutinho]

You can do it with an MCC.

20011
MCC_BACKUP_LIBRARY,                            // [int nMode (0: normal, 1: silent automatic backup)]

Thanks for that, Matt.
Just wondering: although I know that I have preset the location of the backup field, I want to add the path to that location in the command. The reason for that is that I back it up to my Google Drive and that location is differnt at home than at my work, if you know what I mean.
So: is it possible to add the backup location to the command?

Thanks.

[Matt]

Would it work to simply configure each MC to a different backup folder?  Options > File Location > Program Files > Library backups.

Thanks.

[MarkCoutinho]

It would if I wouldn't be restoring the settings each time too. Hence why I'm looking for this command line solution.
But if that's isn't possible, I just have to deal with it

[zeltak]

I would also love to have a way to backup and restore via the command line (using MCC commands) as it would make keeping the library "synced" (or at least the same ) between my main desktop and laptop

thx!

z

[zybex]

It would if I wouldn't be restoring the settings each time too. Hence why I'm looking for this command line solution.
But if that's isn't possible, I just have to deal with it

You could have a script/bat to issue the MCC command, wait a bit, then copy the backup file to the folder you want.

[Matt]

I'll add a command line function tomorrow.  Thanks for the help

[MarkCoutinho]

I'll add a command line function tomorrow.  Thanks for the help

Super!

[zeltak]

Code: [Select]

3. NEW: Added a /BackupLibrary command line tool (takes a filename for the zip file).
thx matt, is it possible to request a /RestoreLibrary option as well as a command line tool?

[Matt]

I think /RestoreLibrary should already work.  There's also /RestoreLibraryAndSettings and /RestoreSettings.

[MarkCoutinho]

Wow! That's more than I hoped for!
This is exactly why I'm a fan of MC since version 8 or something: the forum board with the builders in it - direct answers when needed and sometime action when wanted.

Thanks!

[MarkCoutinho]

I'm sorry to bother you: I can't find the explanation of this command line tool in the Wiki.
If I want to backup the library to for instance c:\music\library mediacenter, what would the full command be that can be run from the command line in Windows (and thus in a batch file that I will schedule)

[Matt]

Just pass the path to a zip file for backup.

MC33.exe /BackupLibrary "C:\Temporary\MC Lib.zip"

[MarkCoutinho]

Works like a charm.
For those interested: I've made a batch file that first backs up the library to a file. After that it renames the file to the format MC always backs up itself (i.e. MC Library Backup (Main Library - 2024-09-28 09-12).
I use the current date/time to rename the file to.

And that batch file I run every day as a scheduled action as well as at home as at my work. (remind: my backup path at work differs from the path at home - hence this solution)

[MarkCoutinho]

I think /RestoreLibrary should already work.  There's also /RestoreLibraryAndSettings and /RestoreSettings.

I just tried this:

mc33.exe /RestoreLibraryAndSettings "c:\music\MediaCenter backups\"

but nothing happens.

What should I do differently?

[Matt]

I would expect you to need the filename to be a ZIP of the settings and library file.  A folder isn't enough.

[MarkCoutinho]

I would expect you to need the filename to be a ZIP of the settings and library file.  A folder isn't enough.

Ah, I see... Than this command tool is no use to me. But I'm super happy with the backup one though!

[zybex]

You just need a script to automatically determine the most recent filename.

Just curious, why would you automate a DB restore?

[zeltak]

Hi zybex!

to "sync" settings across a main laptop and a secondary laptop when on the go

[zybex]

This .bat restores the most recent ZIP backup in a given folder:

Code: [Select]

@echo off
if "%1"=="" echo Usage: MCRestoreLatest c:\Backup\Folder\Path & goto :EOF
set folder=%1
set mask=*.zip

FOR /F "eol=| delims=" %%f IN ('DIR "%folder%\%mask%" /A-D /B /O-D /TW 2^>nul') DO SET "newest=%%f" & GOTO FOUND
echo No %mask% file found in %folder%
GOTO :EOF

:FOUND
echo.
echo Newest file is: "%newest%"
echo.
echo Restoring MC Database in 5 seconds, press CTRL+C to cancel
timeout 5

echo.
mc33.exe /RestoreLibraryAndSettings "%folder%\%newest%"

[MarkCoutinho]

You just need a script to automatically determine the most recent filename.

Just curious, why would you automate a DB restore?

I use it only to automate the restore process as much as I can by hitting just one (combination of) key(s).

[MarkCoutinho]

I use it only to automate the restore process as much as I can by hitting just one (combination of) key(s).

Super, thanks! I'm not home right now, but I will give your code a go.

[MarkCoutinho]

As Zybex has published the restore batch he made, I feel free to show the backup batch I've made.
This batch backs up the library and then renames it to the way MC by default names its back up files. You just have to adjust your own paths.


@echo off
MC33.exe /BackupLibrary "c:\Users\Mark\Google Drive\MediaCenter backups\MC Library Backup.zip"

:: set pause to wait for the backup process to finish
timeout 10

setlocal

:: Retrieve date and time in the correct format (yyyy-MM-dd HH-mm)
for /f "tokens=2-4 delims=/- " %%a in ('date /t') do (
    set year=%%c
    set month=%%b
    set day=%%a
)

for /f "tokens=1-2 delims=:." %%a in ('time /t') do (
    set hour=%%a
    set minute=%%b
)

:: Convert time to 24-hour format as needed
if %hour% lss 10 set hour=0%hour%

:: Set old file name and path
set "source=c:\Users\Mark\Google Drive\MediaCenter backups\MC Library Backup.zip"
set "path=c:\Users\Mark\Google Drive\MediaCenter backups\"
::set "filename=MC Library Backup %year%-%month%-%day% %hour%-%minute%.zip"
set "filename=MC Library Backup (Main Library - %year%-%month%-%day% %hour%-%minute%).zip"
 
:: Rename file
ren "%source%" "%filename%"

echo File renamed to: %path%%filename%

endlocal

[MarkCoutinho]

I think /RestoreLibrary should already work.  There's also /RestoreLibraryAndSettings and /RestoreSettings.

I've done some extensive testing, but /RestoreLibraryAndSettings and /RestoreSettings both don't restore the settings, so that needs some adjustment.
If I restore the library 'by hand' (with the same zip file) the settings are being restored as expected. But that's not the case with the command

[zeltak]

I think /RestoreLibrary should already work.  There's also /RestoreLibraryAndSettings and /RestoreSettings.

thx so much @Matt, how does it know though which backup (file, location etc) to restore from?

best

z