|
|
Removes the specified item from the database. This flag can be used to remove anything from a file to a volume. It is generally best to follow a remove with the dbmgr -dbclean command to truly purge the items and their related objects. You can use either the name of the object that you want to remove (i.e., /raid/path/temp) or the object ID as it exists in the database.DBMGR(8) manual page Name
dbmgr - program for managing the WebNative Venture databaseSynopsis
dbmgr [ options ] [ actions ]
dbmgr [ options ] [ actions ] [ target ]Description
The dbmgr utility for WebNative Venture can be used to do general database maintenance as well as specific administrative tasks from the command line. Most of these operations are generally done automatically according to settings in the Database tabs of the WebNative nativeadmin GUI. The dbmgr utility also includes flags to remove duplicates, and orphans from the database, as well as no-longer-needed entries.Options
- -d dblev
- Turns on debugging at a certain level, represented by dblev (in hex).
- -D
- Turns on full debugging.
- -v
- Turns on verbose reporting mode.
Actions
- -addindexes
- Checks for and adds/rebuilds any missing/damaged essential standard indexes. It will not, however, touch the FileName column FullText index in the file table.
- -addnativeadmin
- Adds the user "nativeadmin" to the MySQL database's user table (called during installation).
- -addshowdata
- Adds "browse" to the permsetfield table. (This option can only be called from a browser.)
- -archivemerge
- Merges together archivemedia table entries for media that have more than one entry.
- -checkindexes
- Equivalent to -addindexes.
- -checkmissingtables
- Parses the dbtables.sql file inside /usr/etc/venture/scripts to determine which tables are missing. Also see -fixmissingtables.
- -checktables
- Runs mysqlcheck on the DataBase tables.
- -checkuniconst
- Makes sure the UNI_CONSTRAINT index on the file table is in place. The UNI_CONSTRAINT index is used to prevent duplicates in the file table.
- -cleanbefore MM/DD/YYYY
- Removes offline database file entries with a time earlier than MM/DD/YYYY. (The date must have this format.)
- -ctindexdump path | file_id
- Dump records in the content index.
- -ctindexrebuild
- Rebuilds the wnvcontent database FullText indexes.
- -dbclean
- Used to clean unnecessary or orphaned records in the database. Includes the following: -archivemerge, -fixpathdups path, -fixfiledups, -fixoffline path, -fixorphans, -pathclean, -removeorphans, -removearchiveorphans, -removedeadarchives. Each may be run on an individual basis.
- -dbretrigger [ -onlyremove ]
- Rebuilds the necessary WebNative Suite database Triggers. The -onlyremove flag doesn't recreate new Triggers after deletion.
- -fixfiledups
- Removes files from the file table that have both online and offline entries.
- -fixlocaljs
- Repairs broken local.js changes from version 16.0.
- -fixmissingtables
- Parses the dbtables.sql file inside /usr/etc/venture/scripts to determine which tables are missing, then runs the dbtables.sql create table command to recreate any missing table(s).
- -fixoffline path
- Updates online state for files and folders, as appropriate based on filesystem.
- -fixorphans
- Removes files that do not have valid parent paths from the database.
- -fixpathdups path
- Remove paths with multiple file table entries.
- -fixpathfileid
- Rebuilds the fileid column in the path table.
- -fixprivileges
- Adds MySQL database privilege rights.
- -fticheckversion
- Checks each individual FTI table split for version upgrades.
- -fticreate data fields [ path ]
- Creates a FullText index for the given keywords. Optionally, a path can be provided to limit the FullText index to that path.
Available fields include: file.filename, file.aicomment, annotations.* and any combination of keyword1 string fields. The keyword1 fields can be specified in two formats, by field number (keyword1.field123) or by field name (keyword1.ByLine). Use of keyword1.* includes all string fields plus annotations in the database. It can cause slowdowns when updating new information. Select, instead, the fields used for searching in user templates or use it with caution. A single asterisk may be used to index all data fields described above.
The data fields parameter should be enclosed in double quotes if it contains any spaces or special characters.
- -ftidisable index name
- Disables the named FullText index, e.g., ftindex1.
- -ftidrop index name
- Drops the named FullText index, e.g., ftindex1.
- -ftidropall
- Drops all FullText indexes.
- -ftienable index name
- Enables the named FullText index, e.g., ftindex1.
- -ftirebalance
- Rebalances all existing indexes.
- -ftiretrigger index name
- Rebuilds Triggers for an index.
- -ftiretriggerall
- Rebuilds all Triggers for all existing indexes.
- -ftisync
- Resyncs all FTIs with the rest of the database.
- -fullbackup
- Runs a full backup of database tables.
- -makepathsdecomp
- Fixes issues with composed/decomposed Unicode path duplication.
- -mergetrailingspaces [path ]
- Merges path table entries that are duplicated due to the existence of a trailing space in the foldername. In the past, when folders with trailing spaces were renamed, duplicate entries were made, one for each version of the path name. This command will fix that problem for live paths.
- -optimize table
- Runs the MySQL optimize command on the specified table. The action is "split table" aware, meaning that when run on bigwebdata, smallwebdata, or fpodata, a single invocation will optimize each subtable within the table specified. For example, dbmgr -optimize bigwebdata, will check each of the 256 bigwebdata subtables within the database.
- -pass password -newpass newpassword
- Changes the current MySQL database password (password) to a new password (newpassword).
- -pathclean path
- Removes paths that no longer exist from the database.
- [ -progress ] -temp -path path
- Moves the WebNative Venture temp directory to path. (This option can only be called from a browser. It displays a progress bar to the user.)
- -purgeallevents
- Deletes all events in event table.
- -purgebackupevents
- Deletes backup events from event table.
- -purgedeleted [ -countonly ] | -limited | -skiparch
- Removes deleted (and unarachived) files from the database. (Using -countonly will return the number of files effected without actually removing the files, giving some idea of the usefulness of using the flag. The -limited flag deletes only up to 100k files; -skiparch skips archive flag update.) Also see -slowpurgedeleted.
- -purgeemptykeys [ -countonly ]
- Removes empty or NULL valued rows in metadata data table. Using -countonly will return the number of files effected without actually removing the files, giving some idea of the usefulness of using the flag.
- -purgeevents
- Deletes expires events in event table.
- -purgenullkeys [ -countonly ]
- Removes NULL valued rows in metadata table (keyword1). Using -countonly will return the number of files effected without actually removing the files, giving some idea of the usefulness of the flag.
- -purgeunusedevents | -cleanupevents
- Removes all "read" and "setfileparms" events from the event table.
- -quickbackup
- Run a quick backup of the database, which does a backup of all tables EXCEPT those that store previews.
- -fullbackup
- Run a full backup of the database, which does a backup of all tables.
- -remove [-offlineonly ]
-v|-p|-f|-u|-g|-t|-s|-k|-m objectname |
-remove [ -offlineonly ]
-vid|-pid|-fid|-uid|-gid|-tid|-sid|-kid|-mid object db id
(single letter removes an object by name,
letter plus "id" removes an object by id)
v = volume
p = path
f = file
u = user
g = group
t = template
s = permset
k = keyword
m = media
Examples:
dbmgr -remove -v MyVolume
dbmgr -remove -vid 20