Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
10.8.3
-
None
Description
mariadb-dump --help includes:
The following groups are read: mysqldump mariadb-dump client client-server client-mariadb
|
The following specify which files/extra groups are read (specified before remaining options):
|
--defaults-file=# Only read default options from the given file #.
|
--defaults-extra-file=# Read this file after the global files are read.
|
The documentation for max_statement_time indicates it can be set dynamically for a session.
However attempts to set this variable in any of the listed groups result in 'unknown variable' error:
eg
root@ubuntu-server~# cat custom.cnf
|
|
|
[mysqldump]
|
max_statement_time = 0
|
|
|
root@ubuntu-server~# mysqldump --defaults-extra-file=custom.cnf my_database >/dev/null
|
mysqldump: unknown variable 'max_execution_time=0'
|
Where the client and server are hosted on different servers and the user lacks SUPER, I'm not aware of any workaround available.
Attachments
Issue Links
- duplicates
-
MDEV-18702 mysqldump should use max_statement_time=0 and/or allow setting one
-
- Closed
-