         | Did this page help you? Yes No Tell us about it... |
rds-reset-db-parameter-group
Description
Resets individual parameters or all parameters in a parameter group to engine defaults.
Syntax
rds-reset-db-parameter-group
DBParameterGroupName [-p (--parameters)
"name=value, method=value" ...]]
[--reset-all-parameters ] [General Options]
Options
| Name | Description | Required |
|---|---|---|
|
|
DB Parameter Group identifier. This value can also be passed using the
Constraints: Must contain from 1 to 255 alphanumeric characters or hyphens. First character must be a letter. Cannot end with a hyphen or contain two consecutive hyphens. |
Yes |
|
|
A string containing a series of parameter names and apply methods. A maximum of 20 parameters may be reset in a single call to the rds-reset-db-parameter-group command. Valid values (for apply method): Constraints: Cannot be specified if --reset-all-parameters is specified. |
Conditional |
|
|
Specifies that all parameters in the group should be reset to their defaults. Constraints: Cannot be specified if --parameters string is specified. |
Conditional |
Output
The command returns the following information:
Group Name—the name of the parameter group that was modified.
Examples
Reset Parameters in a Parameter Group
This example shows how to reset some parameters in a parameter group.
PROMPT> rds-reset-db-parameter-group mydbparametergroup
--parameters "name=max_user_connections, method=pending-reboot" "name=max_allowed_packet, method=immediate"
Reset Parameters in a Parameter Group
This example shows how to reset all parameters in a parameter group.
PROMPT> rds-reset-db-parameter-group mydbparamgrp --reset-all-parameters
