![]() The init-db command initializes a database, creating the required tables and initial data. In this situation, the force option indicates that existing data is deleted first.ĬAUTION If the import-file contains spaces, quote this argument. The -force option is required when the data is loaded into a database that already contains data. f,-force Deletes any existing data before loading the data. The syntax and options for the import-db command are: The Application Server must be stopped to perform the import. The import-db command imports the data (from a previous export) into the database. Use the -file option to specify the full path and filename where the backup is saved.ĬAUTION If the directory or filename parameters contains space, then the argument needs to be quoted. The filename will still be named export-.zip. Use the -dir option to override the default backup directory. ![]() If no options are specified, the database export file is created in the \server\data\backups directory and the file is named export-.zip. f,-file Exports the database to the given file. d,-dir Exports the database to the given directory. The syntax and options for the export-db command are: More information on the server commands is available in Server commands (server-command). If you want to perform an online backup without stopping the Application Server, you can use the inbuilt perform-online-backup server command. Before performing the export, stop the Application Server. The export-db command exports the data from the database. The available commands are discussed in detail below. The db-tools command is a powerful low-level utility so carefully consider its use on a production system. Failure to do so results in a “database in use” error message. It is important that any PaperCut NG/MF services and processes are stopped before executing any commands. Example use on the Apple Mac:ĭb-tools import-db -f /Users/bob/papercut-backup.zipĬd "C:\Program Files\PaperCut NG/MF\server\bin\win\"Ĭd "/Applications/PaperCut NG/MF/server/bin/mac/"ĭb-tools import-db /Users/bob/papercut-backup.zipĭb-tools needs exclusive access to the database. On Linux or Mac the command must be run as the papercut user. ![]() Init-db - create tables and initial data in a new databaseĭelete-old-logs - delete old log data (transaction, print, app log, etc.)ĭb-tools is a command-line application accessed via the Command Prompt on Windows, or a Command Shell (e.g. Import-db - import/restore the database data The syntax of the command is: db-tools command Įxport-db - export/backup the database data The tool is located in /server/bin// and needs to be executed from a command prompt. The db-tools command-line tool provides a variety of functionality manipulating the PaperCut NG/MF database and data. PRODUCTS FEATURED Database tool (db-tools)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |