mysqldump - MariaDB Knowledge Base

<!DOCTYPE html> <html> <head data-cookie-domain="" data-cookie-path="/"> <meta http-equiv="X-UA-Compatible" content="IE=edge, chrome=1"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="apple-touch-icon" sizes="180x180" href="/kb/static/images/favicons/apple-touch-icon.159e713979be.png"> <link rel="icon" type="image/png" sizes="32x32" href="/kb/static/images/favicons/favicon-32x32.bc0ac1d5d11e.png"> <link rel="icon" type="image/png" sizes="16x16" href="/kb/static/images/favicons/favicon-16x16.5801f8f0f34e.png"> <link rel="shortcut icon" href="/kb/static/images/favicons/favicon.d122d305dee4.ico" type="image/x-icon" /> <title>mysqldump - MariaDB Knowledge Base</title> <link href="/kb/static/css/main.f7633538c846.css" rel="stylesheet" type="text/css" />  <meta property="og:title" content="mysqldump" /> <meta property="og:type" content="article" /> <meta property="og:url" content="https://mariadb.com/kb/en/mysqldump/" /> <meta property="og:image" content="http://mariadb.comaskmonty-logo.png" /> <meta property="og:site_name" content="MariaDB KnowledgeBase" /> <meta property="fb:admins" content="514852603" /> <meta property="og:description" content="Old name for mariadb-dump." /> <meta name="description" content="Old name for mariadb-dump." /> <meta name="viewport" content="width=device-width, initial-scale=1" /> <link href="//fonts.googleapis.com/css?family=Montserrat:400,700" rel="stylesheet"/> </head> <body class="mpkb nodes products nodes_view jqui" id="nodes_view"> <div id="menu-mobile" class="visible-sm visible-xs"> <div> <div id="mobile-close-menu" class="text-right"> <a href="javascript:void(0)" title="Close Menu" id="back-main" class="toggle-menu">X<span></span></a> </div> </div> <div class="mainmenu-mobile"> <ul class="ls-none ul-menu"> <li data-sub="submenu5"><a class="open-form-search" href="/kb/search/" title="Search">Search </a></li> <li data-sub="submenu0"><a href="/products" title="Products">Products</a><span class="arrow-main"></span></li> <li data-sub="submenu1"><a href="/services" title="Services">Services</a><span class="arrow-main"></span></li> <li data-sub="submenu2"><a href="/resources" title="Resources">Resources</a><span class="arrow-main"></span></li> <li data-sub="submenu3"><a href="/about-us" title="About">About</a><span class="arrow-main"></span></li> <li data-sub="submenu4"><a href="/contact" title="Contact">Contact</a></li> </ul> </div> <div class="nav-top-mobile"> <div class="select-box form"> <ul class="inline-block-md mb-none top-nav"> <li> </li> <li> <a href="/kb/user/login?next=/kb/en/mysqldump/"> Login</a> </li> </ul> </div> <p class="text-center copyright">Copyright © 2025 MariaDB. All rights reserved.</p> </div> </div> <div class="violator-wrap d-none" id="top_violator"> <div class="container"> <div class="row"> <div class="col-xs-12 col-sm-12"> <div class="violator-outer"> <div class="violator-inner"> <div class="row"> <div class="col-xs-12 col-sm-9 col-lg-7 col-lg-offset-2" id="top_violator_content"> <a href="https://go.mariadb.com/high-availability-guide-MariaDB-whitepaper.html" class="content-link" target="_blank" rel="nofollow noreferrer"> <span>The Ultimate Guide to High Availability with MariaDB</span> </a> </div> <div class="col-xs-12 col-sm-3" id="top_violator_cta"> <a href="https://go.mariadb.com/high-availability-guide-MariaDB-whitepaper.html" class="btn btn-mariadb" target="_blank" rel="nofollow noreferrer">Download Now</a> </div> </div> </div> <button type="button" class="btn btn-link close-btn"> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24" width="15px" height="15px"><path d="M 4.9902344 3.9902344 A 1.0001 1.0001 0 0 0 4.2929688 5.7070312 L 10.585938 12 L 4.2929688 18.292969 A 1.0001 1.0001 0 1 0 5.7070312 19.707031 L 12 13.414062 L 18.292969 19.707031 A 1.0001 1.0001 0 1 0 19.707031 18.292969 L 13.414062 12 L 19.707031 5.7070312 A 1.0001 1.0001 0 0 0 18.980469 3.9902344 A 1.0001 1.0001 0 0 0 18.292969 4.2929688 L 12 10.585938 L 5.7070312 4.2929688 A 1.0001 1.0001 0 0 0 4.9902344 3.9902344 z"/></svg> </button> </div> </div> </div> </div> </div> <div id="wrapper"> <div id="top-nav"> <div class="container"> <ul class="hidden-sm hidden-xs" > <li><a href="https://mariadb.com/kb/">Knowledge Base</a></li> <li><a href="https://mariadb.com/contact/">Contact</a></li> <li> <a href="/kb/user/login?next=/kb/en/mysqldump/" rel="nofollow">Login</a> </li> <li id="search-form"> <form action="/kb/en/+search/" method="get" id="search-block-form" accept-charset="UTF-8"> <input id="search" title="Enter the terms you wish to search for." placeholder="Search . . ." type="text" name="q" value="" size="15" maxlength="128" class="form-text" data-autocomplete-url="/kb/en/+search/autocomplete/"> <input type="hidden" name="quick" value="1" /> <input type="hidden" name="source" value="kb" /> </form> </li> <li><a id="search-toggler" href="/kb/search/">Search</a></li> </ul> </div> </div> <div id="navbar-bottom" class="navbar"> <div class="container"> <div class="row"> <div class="col-md-3 col-sm-9 col-xs-9"> <a class="brand" href="/" title="MariaDB"> <img src="/kb/static/images/logo-2018-black.95f5978ae14d.png"> </a> </div> <div class="col-md-9 hidden-sm hidden-xs"> <div class="main-menu"> <ul id="main-menu" class="nav navbar-nav inline-block-sm"> <li class="has-sub full-menu"> <a href="/products" title="Products">Products</a> </li> <li class="has-sub full-menu active"> <a href="/services" title="Services">Services</a> </li> <li class="has-sub full-menu active"> <a href="/pricing" title="Pricing">Pricing</a> </li> <li class="has-sub full-menu"> <a href="/resources" title="Resources">Resources</a> </li> <li class="has-sub full-menu"> <a href="/about-us" title="About Us">About Us</a> </li> <li class=""> <a class="button electric-eel small top-bar-right-download" href="/downloads/">Download</a> </li> </ul> </div> </div> <div class="col-md-3 visible-sm visible-xs col-sm-3 col-xs-3 ps-rv"> <div class="navbar-header text-right pull-right"> <button type="button" class="menu-control toggle-menu" id="open-menu"> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> </div> </div> </div> </div> </div> <div id="main"> <div class="container"> <div id="subheader1" class="clearfix"> <div class="pull-left"> <div id="breadcrumbs" class="breadcrumb"> <a href="/kb/en/">Knowledge Base</a> » <a class="crumb" href="/kb/en/documentation/">MariaDB Server Documentation</a> » <a class="crumb" href="/kb/en/using-mariadb-server/">Using MariaDB Server</a> » <a class="crumb" href="/kb/en/clients-utilities/">Clients & Utilities</a> » <a class="crumb" href="/kb/en/legacy-clients-and-utilities/">Legacy Clients and Utilities</a> » <a class="node_link crumb" href="/kb/en/mysqldump/">mysqldump</a> </div> </div> </div> </div> <div class="container" id="container-main"> <div class="row"> <aside id="sidebar-first" class="sidebar col-md-2 hidden-xs hidden-sm hidden-print"> <ul id="category_menu" class="nav nav-pills nav-stacked"> <li><a href="/kb/en/">Home</a></li> <li><a href="/kb/en/+questions/">Open Questions</a></li> <li><a href="/kb/en/documentation/">MariaDB Server</a></li> <li><a href="/kb/en/maxscale/">MariaDB MaxScale</a></li> <li><a href="/kb/en/mariadb-columnstore/">MariaDB ColumnStore</a></li> <li><a href="/kb/en/connectors/">Connectors</a></li> </ul> <div> <div class="well well-small box actions"><div> <a class="btn btn-block btn-blue btn-sm" href="/kb/en/mysqldump/+history" rel="nofollow">History</a> <a class="btn btn-block btn-blue btn-sm" href="/kb/en/mysqldump/+source/">Source</a> <a class="btn btn-block btn-blue btn-sm flag" href="/kb/en/mysqldump/+flag" data-flag-url="/kb/en/mysqldump/+flag" rel="nofollow"> Flag as Spam / Inappropriate</a> <a class="btn btn-block btn-blue btn-sm" href="/kb/en/mysqldump/+translate/"> Translate</a> </div> </div> <div class="well well-small box node_info"><div> <dl> <dt>Created</dt> <dd> <span class="datetime" title="2010-09-01 19:25">14 years, 6 months ago</span></dd> <dt>Modified</dt> <dd> <span class="datetime" title="2024-06-26 09:09">9 months ago</span></dd> <dt>Type</dt> <dd>article</dd> <dt>Status</dt> <dd>active</dd> <dt>License</dt> <dd> <a href="/kb/en/mysqldump/+license/">GPLv2</a> </dd> </dl> <ul class="rss_feeds"> <li><a href="/kb/en/mysqldump/+history/feed/"> History</a> </li> <li><a href="/kb/en/mysqldump/+comments/feed/"> Comments</a> </li> </ul> </div> </div> <div class="well well-small box attachments"><div><div class="edit_link pull-right"><a href="/kb/en/mysqldump/+edit/attachments/">Edit</a></div><h5>Attachments</h5></div><div> <div class="no_data">No attachments exist</div> </div> </div> <div class="well well-small box"><div><h5>Localized Versions</h5></div><div> <ul> <li><a href="/kb/it/mysqldump/">mysqldump</a> [it]</li> <li><a href="/kb/zh-cn/mysqldump/">mysqldump</a> [zh-cn]</li> </ul> </div> </div> <div class="well well-small box"><div><h5>Product Versions</h5></div><div> <ul id="product_chooser"> <li class="mariadb_from_11_0_1"> <label><input type="checkbox" data-product-class="mariadb_from_11_0_1" >MariaDB starting with 11.0.1</label> </li> </ul> </div> </div> </div> </aside> <section id="content" class="limited_width col-md-8 clearfix"> <h1>mysqldump</h1> <div> <div class="node creole"> <div class="answer formatted"> <p>mysqldump is used to dump a database or a collection of databases for backup or transfer to another database server.</p> <p>From <a href="/kb/en/what-is-mariadb-105/">MariaDB 10.5</a>, the client is called <code>mariadb-dump</code>. It can still be accessed under its original <code>mysqldump</code> name via a symlink in Linux, or an alternate binary in Windows.</p> <div class="mariadb_from_11_0_1 mariadb from_11_0_1 product"><h5 class="product_title">MariaDB starting with <a href="/kb/en/mariadb-1101-release-notes/">11.0.1</a></h5><p>From <a href="/kb/en/mariadb-11-0-1-release-notes/">MariaDB 11.0.1</a>, <code>mysqldump</code> (the symlink) is deprecated and removed from the <code>mariadb</code> Docker Official Image. Use <code><a href="/kb/en/mariadb-dump/">mariadb-dump</a></code> instead.</p> </div><p>See <a href="/kb/en/mariadb-dump/">mariadb-dump</a> for details.</p> </div> <div id="subscribe" class="well well-small hide hidden-print" data-subscribe-url="/kb/en/mysqldump/+subscriptions/add" data-unsubscribe-url="/kb/en/mysqldump/+subscriptions/remove"> </div> <div class="simple_section_nav"> <ul class="nav nav-pills"> <li><a href="/kb/en/mysqlcheck/"> ← mysqlcheck </a> </li> <li><a href="/kb/en/legacy-clients-and-utilities/"> ↑ Legacy Clients and Utilities ↑ </a> </li> <li class="pull-right"><a href="/kb/en/mysqldumpslow/"> mysqldumpslow → </a> </li> </ul> </div> <h2>Comments</h2> <div id="comments" data-node-id="906" data-comments-url="/kb/en/mysqldump/+comments" data-reply-url="/kb/en/mysqldump/comments/post/"> Comments loading... </div> </div> <div id="content_disclaimer" class="graybox"> Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party. </div> </div> </section> <div id="right_bar" class="col-md-2"> <ul class="section_navigation well well-small hidden-xs hidden-sm"> <li class="parent"><a href="/kb/en/legacy-clients-and-utilities/"> ↑ Legacy Clients and Utilities ↑ </a> </li> <li> <a href="/kb/en/backing-up-and-restoring-databases-percona-xtrabackup/"> Percona XtraBackup </a> </li> <li> <a href="/kb/en/mysql-sandbox/"> MySQL Sandbox </a> </li> <li> <a href="/kb/en/mysqlaccess/"> mysqlaccess </a> </li> <li> <a href="/kb/en/mysqladmin/"> mysqladmin </a> </li> <li> <a href="/kb/en/mysqlcheck/"> mysqlcheck </a> </li> <li class="active"> <span>mysqldump</span> </li> <li> <a href="/kb/en/mysqldumpslow/"> mysqldumpslow </a> </li> <li> <a href="/kb/en/mysqld_multi/"> mysqld_multi </a> </li> <li> <a href="/kb/en/mariadbd_safe/"> mysqld_safe </a> </li> <li> <a href="/kb/en/mysqlhotcopy/"> mysqlhotcopy </a> </li> <li> <a href="/kb/en/mysqlimport/"> mysqlimport </a> </li> <li> <a href="/kb/en/mysqlreport/"> mysqlreport </a> </li> <li> <a href="/kb/en/mysqlshow/"> mysqlshow </a> </li> <li> <a href="/kb/en/mysqlslap/"> mysqlslap </a> </li> <li> <a href="/kb/en/mysql_convert_table_format/"> mysql_convert_table_format </a> </li> <li> <a href="/kb/en/mysql_embedded/"> mysql_embedded </a> </li> <li> <a href="/kb/en/mysql_find_rows/"> mysql_find_rows </a> </li> <li> <a href="/kb/en/mysql_fix_extensions/"> mysql_fix_extensions </a> </li> <li> <a href="/kb/en/mysql_install_db/"> mysql_install_db </a> </li> <li> <a href="/kb/en/mysql_plugin/"> mysql_plugin </a> </li> <li> <a href="/kb/en/mysql_secure_installation/"> mysql_secure_installation </a> </li> <li> <a href="/kb/en/mysql_setpermission/"> mysql_setpermission </a> </li> <li> <a href="/kb/en/mysql_tzinfo_to_sql/"> mysql_tzinfo_to_sql </a> </li> <li> <a href="/kb/en/mysql_upgrade/"> mysql_upgrade </a> </li> <li> <a href="/kb/en/mysql_waitpid/"> mysql_waitpid </a> </li> <li> <a href="/kb/en/mysql_zap/"> mysql_zap </a> </li> </ul> </div> </div> </div> </div>  <footer id="footer"> <div class="footer"> <div class="container"> <div class="row"> <div class="col-xs-12"> <ul class="list-inline text-center footer-nav"> <li> <h5> <a href="https://mariadb.com/products" title="Products">Products</a> </h5> </li> <li> <h5> <a href="https://mariadb.com/services" title="Services">Services</a> </h5> </li> <li> <h5> <a href="https://mariadb.com/pricing" title="Pricing">Pricing</a> </h5> </li> <li> <h5> <a href="https://mariadb.com/resources" title="Resources">Resources</a> </h5> </li> <li> <h5><a href="https://mariadb.com/about-us" title="About MariaDB">About Us</a></h5> </li> <li> <h5><a href="https://mariadb.com/download" title="Download">Download MariaDB</a></h5> </li> </ul> </div> </div> <div class="row row-10"> <div class="col-md-4 col-xs-12 item col-md-offset-4"> <div id="block-footerformcontact" class="block block-block-content block-block-contentd754ee1b-3cc9-40e7-9ef4-f504f1197fb1"> <h5 style="font-weight: 400;">Subscribe to our newsletter!</h5> <script src="//app-sj15.marketo.com/js/forms2/js/forms2.min.js"></script><form id="mktoForm_1498"></form> <script> <![CDATA[// ><!]]]]><![CDATA[> //--><!]]> </script> </div> </div> </div> <div class="row"> <div class="col-md-4 col-xs-12 item col-md-offset-4"> <div class="footer-copyright"> <div class="text-center"> <ul class="list-inline no-margin"> <li> <a href="/legal" title="Legal">Legal</a> </li> <li> <a href="/privacy-policy" title="Privacy Policy">Privacy Policy</a> </li> <li> <a href="/cookie-policy/" title="Cookies">Cookie Policy</a> </li> </ul> <p>Copyright © 2025 MariaDB. All rights reserved.</p> </div> </div> </div> </div> </div> </div> </footer> </div> <div id="ajax_loading"> <img src="/kb/static/images/ajax-loader.a51c5608d01a.gif" /> </div>  <noscript><iframe src="//www.googletagmanager.com/ns.html?id=GTM-MK2847" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript> <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= '//www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-MK2847');</script>  </body> <script type="text/javascript" src="/kb/static/js/main.1587e3a666fc.js" charset="utf-8"></script> </html>

CINXE.COM

mysqldump - MariaDB Knowledge Base