dbu

  • dbu can process multiple commands in the same run, allowing you to perform large batch operations without the overhead of running the utility once for each step.

    To do this, you must launch dbu with the -m parameter, followed by the path to the database to edit:

    > dbu -m /USA_DB/users/user.db

    Once launched, dbu can receive the commands add, update, delete or delete all. Each command must be preceded with ### and a space, and followed by its parameters, like so:

    ### add

    UserName: jdoe

    FirstName: john

    LastName: doe

    ID: 50

    ### update <record number>

    Type: 9

    ### delete <record number>

    ### delete all

    This mode is designed to take scripts piped to it. If you run it without piping a script to it, you will be prompted to enter the commands in the terminal. When you're done, in the Windows command prompt, you can terminate the prompt by pressing Ctrl + Z and pressing Enter. In Bash, you can press Ctrl + D.

  • The -update and -delete options work with the -search option to work on records obtained by the search results. As a result, you don't need to specify a record number, provided that your -search query returns records. If the search query returns multiple records, the -update or -delete operation will work on all matching records.

    To preserve backward compatibility, you must follow -update and -delete with record number 0 if you want dbu to work on search results instead of a specific record number, like so:

    > dbu -delete 0 -se 'UserName:jdoe' /USA_DB/users/user.db

    This will delete all records with the username jdoe.

  • The -f parameter when used in combination with -append or -update, allows you to specify each field followed by their value inline instead of specifying them through standard input. Each field must be separated from their value by a colon, and each field and value pair must be separated by a comma, like so:

    > dbu -update <record number> -f 'FirstName:john,LastName:doe' /USA_DB/users/user.db

If you need to perform maintenance or updates on a Harmony server, you can pause it instead of stopping it completely.

Users who attempt to save a scene while the server is paused will receive a warning message. The server will queue the save and commit the changes when the server is resumed. For more information about pausing and resuming the database server, see the following:

  • macOS.
  • Windows.
  • Linux.