{"id":238,"date":"2013-07-23T10:12:42","date_gmt":"2013-07-23T15:12:42","guid":{"rendered":"http:\/\/thenoyes.com\/littlenoise\/?p=238"},"modified":"2013-08-12T10:01:51","modified_gmt":"2013-08-12T15:01:51","slug":"238","status":"publish","type":"post","link":"https:\/\/thenoyes.com\/littlenoise\/?p=238","title":{"rendered":"mysqldump privileges required"},"content":{"rendered":"

“mysqldump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, and LOCK TABLES if the –single-transaction option is not used. Certain options might require other privileges as noted in the option descriptions.”
\n– http:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/mysqldump.html<\/a><\/p>\n\n\n\n\n\n\t<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Format<\/th>\nDefault<\/th>\nPrivileges Required<\/th>\n<\/tr>\n<\/thead>\n
–add-drop-database<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–add-drop-table<\/a><\/td>\nOn in –opt<\/td>\n <\/td>\n<\/tr>\n
–add-drop-trigger<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–add-locks<\/a><\/td>\nOn in –opt<\/td>\n <\/td>\n<\/tr>\n
–all-databases<\/a><\/td>\nOff<\/td>\nSELECT, SHOW DATABASES ON *.*<\/td>\n<\/tr>\n
–allow-keywords<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–apply-slave-statements<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–bind-address=ip_address<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–comments<\/a><\/td>\nOn<\/td>\n <\/td>\n<\/tr>\n
–compact<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–compatible=name[,name,…]<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–complete-insert<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–create-options<\/a><\/td>\nOn in –opt<\/td>\n <\/td>\n<\/tr>\n
–databases<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–debug[=debug_options]<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–debug-check<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–debug-info<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–default-auth=plugin<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–default-character-set=charset_name<\/a><\/td>\nutf8\/latin1<\/td>\n <\/td>\n<\/tr>\n
–delayed-insert<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–delete-master-logs<\/a><\/td>\nOff<\/td>\nSUPER ON *.*<\/td>\n<\/tr>\n
–disable-keys<\/a><\/td>\nOn in –opt<\/td>\n <\/td>\n<\/tr>\n
–dump-date<\/a><\/td>\nOn in –comments<\/td>\n <\/td>\n<\/tr>\n
–dump-slave[=value]<\/a><\/td>\nOff<\/td>\nSUPER or REPLICATION CLIENT ON *.*<\/td>\n<\/tr>\n
–events<\/a><\/td>\nOff<\/td>\nEVENT<\/td>\n<\/tr>\n
–extended-insert<\/a><\/td>\nOn in –opt<\/td>\n <\/td>\n<\/tr>\n
–fields-enclosed-by=string<\/a><\/td>\n” in –tab<\/td>\n <\/td>\n<\/tr>\n
–fields-escaped-by<\/a><\/td>\n‘\\\\’ in –tab<\/td>\n <\/td>\n<\/tr>\n
–fields-optionally-enclosed-by=string<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–fields-terminated-by=string<\/a><\/td>\n‘\\t’ in –tab<\/td>\n <\/td>\n<\/tr>\n
–flush-logs<\/a><\/td>\nOff<\/td>\nRELOAD ON *.*<\/td>\n<\/tr>\n
–flush-privileges<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–help<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–hex-blob<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–host<\/a><\/td>\nlocalhost<\/td>\n <\/td>\n<\/tr>\n
–ignore-table=db_name.tbl_name<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–include-master-host-port<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–insert-ignore<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–lines-terminated-by=string<\/a><\/td>\n‘\\n’ in –tab<\/td>\n <\/td>\n<\/tr>\n
–lock-all-tables<\/a><\/td>\nOff<\/td>\nLOCK TABLES\tON *.*<\/td>\n<\/tr>\n
–lock-tables<\/a><\/td>\nOn in –opt<\/td>\nLOCK TABLES<\/td>\n<\/tr>\n
–log-error=file_name<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–login-path=name<\/a><\/td>\nOff<\/td>\ncontrolled at OS level<\/td>\n<\/tr>\n
–master-data<\/a><\/td>\nOff<\/td>\nRELOAD ON *.*
SUPER or REPLICATION CLIENT ON *.*<\/td>\n<\/tr>\n
–max_allowed_packet=value<\/td>\n24MB<\/td>\n <\/td>\n<\/tr>\n
–net_buffer_length=value<\/a><\/td>\n1022KB<\/td>\n <\/td>\n<\/tr>\n
–no-autocommit<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–no-create-db<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–no-create-info<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–no-data<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–no-set-names<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–no-tablespaces<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–opt<\/a><\/td>\nOn<\/td>\n <\/td>\n<\/tr>\n
–order-by-primary<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–password[=password]<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–pipe<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–plugin-dir=path<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–port=port_num<\/a><\/td>\n3306<\/td>\n <\/td>\n<\/tr>\n
–quick<\/a><\/td>\nOn in –opt<\/td>\n <\/td>\n<\/tr>\n
–quote-names<\/a><\/td>\nOn<\/td>\n <\/td>\n<\/tr>\n
–replace<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–result-file=file<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–routines<\/a><\/td>\nOff<\/td>\nSELECT ON mysql.proc<\/td>\n<\/tr>\n
–set-charset<\/a><\/td>\nOn<\/td>\n <\/td>\n<\/tr>\n
–set-gtid-purged=value<\/a><\/td>\nAuto<\/td>\n <\/td>\n<\/tr>\n
–single-transaction<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–skip-add-drop-table<\/a><\/td>\nOff in –opt<\/td>\n <\/td>\n<\/tr>\n
–skip-add-locks<\/a><\/td>\nOff in –opt<\/td>\n <\/td>\n<\/tr>\n
–skip-comments<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–skip-compact<\/a><\/td>\nOn<\/td>\n <\/td>\n<\/tr>\n
–skip-disable-keys<\/a><\/td>\nOff in –opt<\/td>\n <\/td>\n<\/tr>\n
–skip-extended-insert<\/a><\/td>\nOff in –opt<\/td>\n <\/td>\n<\/tr>\n
–skip-opt<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–skip-quick<\/a><\/td>\nOff in –opt<\/td>\n <\/td>\n<\/tr>\n
–skip-quote-names<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–skip-set-charset<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–skip-triggers<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–skip-tz-utc<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–ssl-ca=file_name<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–ssl-capath=dir_name<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–ssl-cert=file_name<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–ssl-cipher=cipher_list<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–ssl-crl=file_name<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–ssl-crlpath=dir_name<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–ssl-key=file_name<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–ssl-verify-server-cert<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–tab=path<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–tables<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–triggers<\/a><\/td>\nOn<\/td>\nTRIGGER since 5.1.23, SUPER ON *.* earlier<\/td>\n<\/tr>\n
–tz-utc<\/a><\/td>\nOn<\/td>\n <\/td>\n<\/tr>\n
–user=user_name<\/a><\/td>\nsystem user on Linux, ‘ODBC’ on Windows<\/td>\n <\/td>\n<\/tr>\n
–verbose<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–version<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–where=’where_condition’<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n
–xml<\/a><\/td>\nOff<\/td>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

“mysqldump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, and LOCK TABLES if the –single-transaction option is not used. Certain options might require other privileges as noted in the option descriptions.” – http:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/mysqldump.html Format Default Privileges Required –add-drop-database Off   –add-drop-table On in –opt   […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[8],"tags":[],"class_list":["post-238","post","type-post","status-publish","format-standard","hentry","category-mysql-faq"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/s2IBF1-238","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts\/238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=238"}],"version-history":[{"count":14,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts\/238\/revisions"}],"predecessor-version":[{"id":248,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts\/238\/revisions\/248"}],"wp:attachment":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}