API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 11th, 2017
81
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.93 KB | None | 0 0
raw download clone embed print report
  1. -bash-3.2# MKDEBUG=1 mk-parallel-dump --no-flush-lock -- mysqlcheck --user root --password mypassword --optimize '%D' '%N'
  2. # /usr/bin/perl 5.008008
  3. # Linux aspnagios.hosted.exlibrisgroup.com 2.6.22.19-vs2.3.0.34.1 #1 SMP Mon Mar 17 02:33:42 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
  4. # /usr/bin/mk-parallel-dump Ver @VERSION@ Distrib @DISTRIB@ Changeset line 1325
  5. # Arguments: _[--no-flush-lock]_ _[--]_ _[mysqlcheck]_ _[--user]_ _[root]_ _[--password]_ _[mypassword]_ _[--optimize]_ _[%D]_ _[%N]_
  6. # OptionParser:680 28430 Option rule: --lock-tables and --[no]flush-lock are mutually exclusive.
  7. # OptionParser:680 28430 Option rule: --sets and --set-per-database are mutually exclusive.
  8. # OptionParser:689 28430 =item --ask-pass
  9. # OptionParser:703 28430 Option has no attributes
  10. # OptionParser:711 28430 Short help: Prompt for a password when connecting to MySQL
  11. # OptionParser:689 28430 =item --base-dir
  12. # OptionParser:711 28430 Short help: The base directory in which files will be stored
  13. # OptionParser:689 28430 =item --[no]biggest-first
  14. # OptionParser:711 28430 Short help: Process tables in descending order of size (biggest to smallest)
  15. # OptionParser:689 28430 =item --[no]bin-log-position
  16. # OptionParser:711 28430 Short help: Dump the master/slave position
  17. # OptionParser:689 28430 =item --charset
  18. # OptionParser:711 28430 Short help: Default character set
  19. # OptionParser:689 28430 =item --chunk-size
  20. # OptionParser:711 28430 Short help: Number of rows or data size to dump per file
  21. # OptionParser:689 28430 =item --config
  22. # OptionParser:711 28430 Short help: Read this comma-separated list of config files; if specified, this must be the first option on the command line
  23. # OptionParser:689 28430 =item --csv
  24. # OptionParser:703 28430 Option has no attributes
  25. # OptionParser:711 28430 Short help: Do --tab dump in CSV format (implies --tab)
  26. # OptionParser:689 28430 =item --databases
  27. # OptionParser:711 28430 Short help: Dump only this comma-separated list of databases
  28. # OptionParser:689 28430 =item --databases-regex
  29. # OptionParser:711 28430 Short help: Dump only databases whose names match this Perl regex
  30. # OptionParser:689 28430 =item --defaults-file
  31. # OptionParser:711 28430 Short help: Only read mysql options from the given file
  32. # OptionParser:689 28430 =item --[no]default-set
  33. # OptionParser:703 28430 Option has no attributes
  34. # OptionParser:711 28430 Short help: When --sets given, dump tables not in any set
  35. # OptionParser:689 28430 =item --dry-run
  36. # OptionParser:703 28430 Option has no attributes
  37. # OptionParser:711 28430 Short help: Print commands instead of executing them
  38. # OptionParser:689 28430 =item --[no]flush-lock
  39. # OptionParser:703 28430 Option has no attributes
  40. # OptionParser:711 28430 Short help: Use FLUSH TABLES WITH READ LOCK
  41. # OptionParser:689 28430 =item --flush-log
  42. # OptionParser:703 28430 Option has no attributes
  43. # OptionParser:711 28430 Short help: Execute FLUSH LOGS when getting binlog positions
  44. # OptionParser:689 28430 =item --[no]gzip
  45. # OptionParser:711 28430 Short help: Compress files with gzip
  46. # OptionParser:689 28430 =item --help
  47. # OptionParser:703 28430 Option has no attributes
  48. # OptionParser:711 28430 Short help: Show help and exit
  49. # OptionParser:689 28430 =item --host
  50. # OptionParser:711 28430 Short help: Connect to host
  51. # OptionParser:689 28430 =item --ignore-databases
  52. # OptionParser:711 28430 Short help: Ignore this comma-separated list of databases
  53. # OptionParser:689 28430 =item --ignore-engines
  54. # OptionParser:711 28430 Short help: Dump no data for this comma-separated list of storage engines
  55. # OptionParser:689 28430 =item --ignore-tables
  56. # OptionParser:711 28430 Short help: Ignore this comma-separated list of table names
  57. # OptionParser:689 28430 =item --lock-tables
  58. # OptionParser:703 28430 Option has no attributes
  59. # OptionParser:711 28430 Short help: Use LOCK TABLES (disables --[no]flush-lock)
  60. # OptionParser:689 28430 =item --lossless-floats
  61. # OptionParser:703 28430 Option has no attributes
  62. # OptionParser:711 28430 Short help: Dump float types with extra precision for lossless restore (requires --tab)
  63. # OptionParser:689 28430 =item --password
  64. # OptionParser:711 28430 Short help: Password to use when connecting
  65. # OptionParser:689 28430 =item --port
  66. # OptionParser:711 28430 Short help: Port number to use for connection
  67. # OptionParser:689 28430 =item --progress
  68. # OptionParser:703 28430 Option has no attributes
  69. # OptionParser:711 28430 Short help: Display progress messages
  70. # OptionParser:689 28430 =item --quiet
  71. # OptionParser:711 28430 Short help: Quiet output; disables --verbose
  72. # OptionParser:689 28430 =item --set-per-database
  73. # OptionParser:703 28430 Option has no attributes
  74. # OptionParser:711 28430 Short help: Dump each database as a separate set
  75. # OptionParser:689 28430 =item --sets
  76. # OptionParser:711 28430 Short help: Dump this comma-separated list of backup sets
  77. # OptionParser:689 28430 =item --set-table
  78. # OptionParser:711 28430 Short help: The database.table in which backup sets are kept
  79. # OptionParser:689 28430 =item --set-vars
  80. # OptionParser:711 28430 Short help: Set these MySQL variables
  81. # OptionParser:689 28430 =item --since
  82. # OptionParser:711 28430 Short help: Dump only tables modified since this long ago, or not dumped since this long ago
  83. # OptionParser:689 28430 =item --socket
  84. # OptionParser:711 28430 Short help: Socket file to use for connection
  85. # OptionParser:689 28430 =item --stop-slave
  86. # OptionParser:703 28430 Option has no attributes
  87. # OptionParser:711 28430 Short help: Issue STOP SLAVE on server before dumping data
  88. # OptionParser:689 28430 =item --tab
  89. # OptionParser:703 28430 Option has no attributes
  90. # OptionParser:711 28430 Short help: Dump tab-separated (sets --umask 0)
  91. # OptionParser:689 28430 =item --tables
  92. # OptionParser:711 28430 Short help: Dump only this comma-separated list of table names
  93. # OptionParser:689 28430 =item --tables-regex
  94. # OptionParser:711 28430 Short help: Dump only tables whose names match this Perl regex
  95. # OptionParser:689 28430 =item --threads
  96. # OptionParser:711 28430 Short help: Number of threads to dump concurrently
  97. # OptionParser:689 28430 =item --umask
  98. # OptionParser:711 28430 Short help: Set the program's umask to this octal value
  99. # OptionParser:689 28430 =item --user
  100. # OptionParser:711 28430 Short help: User for login if not current user
  101. # OptionParser:689 28430 =item --verbose
  102. # OptionParser:711 28430 Short help: Be verbose; can specify multiple times
  103. # OptionParser:689 28430 =item --version
  104. # OptionParser:703 28430 Option has no attributes
  105. # OptionParser:711 28430 Short help: Show version and exit
  106. # OptionParser:689 28430 =item --wait
  107. # OptionParser:711 28430 Short help: Wait limit when the server is down
  108. # OptionParser:756 28430 Parsing opt spec: group => default spec => ask-pass desc => Prompt for a password when connecting to MySQL
  109. # OptionParser:794 28430 ask-pass type: undef
  110. # OptionParser:756 28430 Parsing opt spec: group => default spec => base-dir=s desc => The base directory in which files will be stored
  111. # OptionParser:794 28430 base-dir type: s
  112. # OptionParser:756 28430 Parsing opt spec: group => default spec => biggest-first! desc => Process tables in descending order of size (biggest to smallest) (default yes)
  113. # OptionParser:794 28430 biggest-first type: undef
  114. # OptionParser:810 28430 biggest-first default: 1
  115. # OptionParser:756 28430 Parsing opt spec: group => default spec => bin-log-position! desc => Dump the master/slave position (default yes)
  116. # OptionParser:794 28430 bin-log-position type: undef
  117. # OptionParser:810 28430 bin-log-position default: 1
  118. # OptionParser:756 28430 Parsing opt spec: group => default spec => charset|A=s desc => Default character set
  119. # OptionParser:794 28430 charset type: s
  120. # OptionParser:756 28430 Parsing opt spec: group => default spec => chunk-size=s desc => Number of rows or data size to dump per file
  121. # OptionParser:794 28430 chunk-size type: s
  122. # OptionParser:756 28430 Parsing opt spec: group => default spec => config=A desc => Read this comma-separated list of config files; if specified, this must be the first option on the command line
  123. # OptionParser:794 28430 config type: A
  124. # OptionParser:756 28430 Parsing opt spec: group => default spec => csv desc => Do --tab dump in CSV format (implies --tab)
  125. # OptionParser:794 28430 csv type: undef
  126. # OptionParser:756 28430 Parsing opt spec: group => default spec => databases|d=h desc => Dump only this comma-separated list of databases
  127. # OptionParser:794 28430 databases type: h
  128. # OptionParser:756 28430 Parsing opt spec: group => default spec => databases-regex=s desc => Dump only databases whose names match this Perl regex
  129. # OptionParser:794 28430 databases-regex type: s
  130. # OptionParser:756 28430 Parsing opt spec: group => default spec => defaults-file|F=s desc => Only read mysql options from the given file
  131. # OptionParser:794 28430 defaults-file type: s
  132. # OptionParser:756 28430 Parsing opt spec: group => default spec => default-set! desc => When --sets given, dump tables not in any set
  133. # OptionParser:794 28430 default-set type: undef
  134. # OptionParser:756 28430 Parsing opt spec: group => default spec => dry-run desc => Print commands instead of executing them
  135. # OptionParser:794 28430 dry-run type: undef
  136. # OptionParser:756 28430 Parsing opt spec: group => default spec => flush-lock! desc => Use FLUSH TABLES WITH READ LOCK
  137. # OptionParser:794 28430 flush-lock type: undef
  138. # OptionParser:756 28430 Parsing opt spec: group => default spec => flush-log desc => Execute FLUSH LOGS when getting binlog positions
  139. # OptionParser:794 28430 flush-log type: undef
  140. # OptionParser:756 28430 Parsing opt spec: group => default spec => gzip! desc => Compress files with gzip (default yes)
  141. # OptionParser:794 28430 gzip type: undef
  142. # OptionParser:810 28430 gzip default: 1
  143. # OptionParser:756 28430 Parsing opt spec: group => default spec => help desc => Show help and exit
  144. # OptionParser:794 28430 help type: undef
  145. # OptionParser:756 28430 Parsing opt spec: group => default spec => host|h=s desc => Connect to host
  146. # OptionParser:794 28430 host type: s
  147. # OptionParser:756 28430 Parsing opt spec: group => default spec => ignore-databases=H desc => Ignore this comma-separated list of databases
  148. # OptionParser:794 28430 ignore-databases type: H
  149. # OptionParser:756 28430 Parsing opt spec: group => default spec => ignore-engines=H desc => Dump no data for this comma-separated list of storage engines (default FEDERATED,MRG_MyISAM)
  150. # OptionParser:794 28430 ignore-engines type: H
  151. # OptionParser:810 28430 ignore-engines default: FEDERATED,MRG_MyISAM
  152. # OptionParser:756 28430 Parsing opt spec: group => default spec => ignore-tables=H desc => Ignore this comma-separated list of table names
  153. # OptionParser:794 28430 ignore-tables type: H
  154. # OptionParser:756 28430 Parsing opt spec: group => default spec => lock-tables desc => Use LOCK TABLES (disables --[no]flush-lock)
  155. # OptionParser:794 28430 lock-tables type: undef
  156. # OptionParser:819 28430 Deferring check of disables rule for HASH(0xd63710) disables --[no]flush-lock)
  157. # OptionParser:756 28430 Parsing opt spec: group => default spec => lossless-floats desc => Dump float types with extra precision for lossless restore (requires --tab)
  158. # OptionParser:794 28430 lossless-floats type: undef
  159. # OptionParser:756 28430 Parsing opt spec: group => default spec => password|p=s desc => Password to use when connecting
  160. # OptionParser:794 28430 password type: s
  161. # OptionParser:756 28430 Parsing opt spec: group => default spec => port|P=i desc => Port number to use for connection
  162. # OptionParser:794 28430 port type: i
  163. # OptionParser:756 28430 Parsing opt spec: group => default spec => progress desc => Display progress messages
  164. # OptionParser:794 28430 progress type: undef
  165. # OptionParser:756 28430 Parsing opt spec: group => default spec => quiet|q desc => Quiet output; disables --verbose
  166. # OptionParser:794 28430 quiet type: undef
  167. # OptionParser:819 28430 Deferring check of disables rule for HASH(0xb94680) disables --verbose
  168. # OptionParser:756 28430 Parsing opt spec: group => default spec => set-per-database desc => Dump each database as a separate set
  169. # OptionParser:794 28430 set-per-database type: undef
  170. # OptionParser:756 28430 Parsing opt spec: group => default spec => sets=a desc => Dump this comma-separated list of backup sets
  171. # OptionParser:794 28430 sets type: a
  172. # OptionParser:756 28430 Parsing opt spec: group => default spec => set-table=s desc => The database.table in which backup sets are kept
  173. # OptionParser:794 28430 set-table type: s
  174. # OptionParser:756 28430 Parsing opt spec: group => default spec => set-vars=s desc => Set these MySQL variables (default wait_timeout=10000)
  175. # OptionParser:794 28430 set-vars type: s
  176. # OptionParser:810 28430 set-vars default: wait_timeout=10000
  177. # OptionParser:756 28430 Parsing opt spec: group => default spec => since=m desc => Dump only tables modified since this long ago, or not dumped since this long ago
  178. # OptionParser:794 28430 since type: m
  179. # OptionParser:756 28430 Parsing opt spec: group => default spec => socket|S=s desc => Socket file to use for connection
  180. # OptionParser:794 28430 socket type: s
  181. # OptionParser:756 28430 Parsing opt spec: group => default spec => stop-slave desc => Issue STOP SLAVE on server before dumping data
  182. # OptionParser:794 28430 stop-slave type: undef
  183. # OptionParser:756 28430 Parsing opt spec: group => default spec => tab desc => Dump tab-separated (sets --umask 0)
  184. # OptionParser:794 28430 tab type: undef
  185. # OptionParser:756 28430 Parsing opt spec: group => default spec => tables|t=h desc => Dump only this comma-separated list of table names
  186. # OptionParser:794 28430 tables type: h
  187. # OptionParser:756 28430 Parsing opt spec: group => default spec => tables-regex=s desc => Dump only tables whose names match this Perl regex
  188. # OptionParser:794 28430 tables-regex type: s
  189. # OptionParser:756 28430 Parsing opt spec: group => default spec => threads=i desc => Number of threads to dump concurrently (default 2)
  190. # OptionParser:794 28430 threads type: i
  191. # OptionParser:810 28430 threads default: 2
  192. # OptionParser:756 28430 Parsing opt spec: group => default spec => umask=s desc => Set the program's umask to this octal value
  193. # OptionParser:794 28430 umask type: s
  194. # OptionParser:756 28430 Parsing opt spec: group => default spec => user|u=s desc => User for login if not current user
  195. # OptionParser:794 28430 user type: s
  196. # OptionParser:756 28430 Parsing opt spec: group => default spec => verbose|v+ desc => Be verbose; can specify multiple times (default 1)
  197. # OptionParser:794 28430 verbose type: undef
  198. # OptionParser:810 28430 verbose default: 1
  199. # OptionParser:756 28430 Parsing opt spec: group => default spec => version desc => Show version and exit
  200. # OptionParser:794 28430 version type: undef
  201. # OptionParser:756 28430 Parsing opt spec: group => default spec => wait|w=m desc => Wait limit when the server is down (default 5m)
  202. # OptionParser:794 28430 wait type: m
  203. # OptionParser:810 28430 wait default: 5m
  204. # OptionParser:825 28430 Parsing rule: --lock-tables and --[no]flush-lock are mutually exclusive.
  205. # OptionParser:876 28430 Participants for --lock-tables and --[no]flush-lock are mutually exclusive. : lock-tables flush-lock
  206. # OptionParser:833 28430 lock-tables flush-lock are mutually exclusive
  207. # OptionParser:825 28430 Parsing rule: --sets and --set-per-database are mutually exclusive.
  208. # OptionParser:876 28430 Participants for --sets and --set-per-database are mutually exclusive. : sets set-per-database
  209. # OptionParser:833 28430 sets set-per-database are mutually exclusive
  210. # OptionParser:876 28430 Participants for disables --verbose : verbose
  211. # OptionParser:862 28430 Option quiet disables verbose
  212. # OptionParser:876 28430 Participants for disables --[no]flush-lock) : flush-lock
  213. # OptionParser:862 28430 Option lock-tables disables flush-lock
  214. # OptionParser:970 28430 Cannot open /etc/maatkit/maatkit.conf: No such file or directory
  215. #
  216. # OptionParser:970 28430 Cannot open /etc/maatkit/mk-parallel-dump.conf: No such file or directory
  217. #
  218. # OptionParser:970 28430 Cannot open /root/.maatkit.conf: No such file or directory
  219. #
  220. # OptionParser:970 28430 Cannot open /root/.mk-parallel-dump.conf: No such file or directory
  221. #
  222. # OptionParser:938 28430 Got option flush-lock = 0
  223. # OptionParser:1133 28430 Nothing to validate for option chunk-size type s value undef
  224. # OptionParser:1133 28430 Nothing to validate for option since type m value undef
  225. # OptionParser:1133 28430 Nothing to validate for option set-table type s value undef
  226. # OptionParser:1133 28430 Nothing to validate for option tables type h value undef
  227. # OptionParser:1133 28430 Nothing to validate for option password type s value undef
  228. # OptionParser:1133 28430 Nothing to validate for option user type s value undef
  229. # OptionParser:1133 28430 Nothing to validate for option charset type s value undef
  230. # OptionParser:1133 28430 Nothing to validate for option set-vars type s value wait_timeout=10000
  231. # OptionParser:1133 28430 Nothing to validate for option port type i value undef
  232. # OptionParser:1133 28430 Nothing to validate for option socket type s value undef
  233. # OptionParser:1133 28430 Nothing to validate for option base-dir type s value undef
  234. # OptionParser:1133 28430 Nothing to validate for option databases-regex type s value undef
  235. # OptionParser:1133 28430 Nothing to validate for option tables-regex type s value undef
  236. # OptionParser:1133 28430 Nothing to validate for option sets type a value undef
  237. # OptionParser:1133 28430 Nothing to validate for option databases type h value undef
  238. # OptionParser:1133 28430 Nothing to validate for option threads type i value 2
  239. # OptionParser:1133 28430 Nothing to validate for option defaults-file type s value undef
  240. # OptionParser:1133 28430 Nothing to validate for option host type s value undef
  241. # OptionParser:1079 28430 Parsing option wait as a time value
  242. # OptionParser:1093 28430 Setting option wait to 300
  243. # OptionParser:1133 28430 Nothing to validate for option umask type s value undef
  244. # DSNParser:313 28430 Setting setvars property
  245. # mk_parallel_dump:2844 28430 Args for mysqldump: mysqlcheck, --user, root, --password, mypassword, --optimize, %D, %N
  246. # DSNParser:384 28430 DSN string made from options:
  247. # DSNParser:322 28430 No DSN to parse
  248. # DSNParser:434 28430 DBI:mysql:;;mysql_read_default_group=client
  249. # DSNParser:465 28430 DBI:mysql:;;mysql_read_default_group=client undef undef { mysql_enable_utf8=>0, AutoCommit=>0, RaiseError=>1, PrintError=>0 }
  250. # DSNParser:500 28430 DBI connect(';;mysql_read_default_group=client','',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/bin/mk-parallel-dump line 468
  251. #
  252. # DSNParser:465 28430 DBI:mysql:;;mysql_read_default_group=client undef undef { mysql_enable_utf8=>0, AutoCommit=>0, RaiseError=>1, PrintError=>0 }
  253. # DSNParser:500 28430 DBI connect(';;mysql_read_default_group=client','',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/bin/mk-parallel-dump line 468
  254. #
  255. DBI connect(';;mysql_read_default_group=client','',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/bin/mk-parallel-dump line 468
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!