CINXE.COM
Modify the MariaDB data directory
<!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Modify the MariaDB data directory</title> <meta name="description" content=""> <meta name="generator" content="Hugo 0.80.0" /> <meta name="twitter:card" content="summary"> <meta name="twitter:title" content="Modify the MariaDB data directory"> <meta name="twitter:description" content=""> <meta property="og:title" content="Modify the MariaDB data directory"> <meta property="og:type" content="documentation"> <meta property="og:description" content=""> <meta property="article:published_time" content="2023-02-09" /> <meta name="addsearch-custom-field" content="app=wordpress"/> <meta name="addsearch-custom-field" content="type=apps"/> <script async src="https://www.googletagmanager.com/gtag/js?id=G-9R2174SWXR"></script> <script type="text/plain" class="optanon-category-2"> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'G-9R2174SWXR', { 'page_path': location.pathname + location.search + location.hash }); </script> <link href='https://d33np9n32j53g7.cloudfront.net/fonts/overpass.css' media="screen" rel="stylesheet"> <link href='//d1d5nb8vlsbujg.cloudfront.net/hex/4.0.0/hex.min.css' media="screen" rel="stylesheet"> <link rel="stylesheet" href="https://docs.bitnami.com/css/bds.faf8b14f3c76e6860c8727547b073e6516fcda727e0e96aaffb6be74ac913dbe.css" integrity="sha256-+vixTzx25oYMhydUewc+ZRb82nJ+Dpaq/7a+dKyRPb4=" media="screen"> <script src='//d1d5nb8vlsbujg.cloudfront.net/hex/4.0.0/hex.min.js'></script> <script src="https://code.jquery.com/jquery-1.12.4.min.js" integrity="sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ=" crossorigin="anonymous"></script> <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js" integrity="sha256-VazP97ZCwtekAsvgPBSUwPFKdrwD3unUfSGVYrahUqU=" crossorigin="anonymous"></script> <script src="https://docs.bitnami.com/js/bds.min.532022ed4c220659e9491eb3a1169af6c952894fee385f048eaa68dc9a518097.js"></script> <link href='https://docs.bitnami.com/images/img/favicon.png' rel='shortcut icon'> <link rel="alternate" type="application/rss+xml" title="Bitnami Documentation" href="https://docs.bitnami.com/index.xml"/> </head> <body class="aws apps"> <div class="addsearch__index" data-addsearch="include">awswordpress</div> <div class="topnav container topnav-no-hero headbloc"> <header class="header"> <script src="https://cdn.cookielaw.org/scripttemplates/otSDKStub.js" type="text/javascript" charset="UTF-8" data-domain-script=018ee37f-861a-71d5-8408-7a1202512048></script> <script type="text/javascript"> function OptanonWrapper() { var events = window.dataLayer.filter(function(element) { return element.event === "OneTrustGroupsUpdated" && element.OnetrustActiveGroups != null; }); { window.dataLayer.push({ event: 'OneTrustGroupsUpdated' }); } if (events.length > 0) { var latestEvent = events[events.length - 1]; var previousEvent = events.length === 1 ? latestEvent : events[events.length - 2]; if (latestEvent.OnetrustActiveGroups != previousEvent.OnetrustActiveGroups) { location.reload(); } } } </script> <div class="header__logo"> <a href="https://docs.bitnami.com/"><img alt="Bitnami by VMware logo" src="https://docs.bitnami.com/images/logo.svg"/></a> </div> <nav class="header__nav"> <button aria-expanded="false" aria-haspopup="true" aria-label="Toggle menu" class="header__nav__hamburguer"> <div></div> <div></div> <div></div> </button> <ul class="header__nav__menu" role="list" aria-label="Main navigation"> <li> <a class="header__nav__menu__item" href="https://bitnami.com/stacks">Applications</a> </li> <li> <a aria-expanded="false" aria-haspopup="true" class="header__nav__menu__item" href="#" tabindex="0">Kubernetes</a> <ul aria-label="Kubernetes" class="header__nav__submenu header__nav__kubernetes" role="menu" aria-expanded="false"> <div class="header__nav__list"> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://kubeapps.dev/" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Kubeapps</h3> <p>Your Application Dashboard for Kubernetes</p> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://docs.bitnami.com/kubernetes/" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Kubernetes Tutorials</h3> <p>Move Your Containers to Production</p> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://kube.academy/" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Kubeacademy</h3> <p>Unlock your full potential with Kubernetes courses designed by experts</p> </div> </a> </li> <li role="none" class='header-hide-mobile'> <a class="header__nav__list__item" role="menuitem" href="https://tanzu.vmware.com/education" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>VMware Tanzu Education</h3> <p>Invest in your future and build your cloud native skills</p> </div> </a> </li> </div> <div class="header__nav__kubernetes__others"> <li role="none"> <a role="menuitem" class="header__nav__kubernetes__other" href="https://github.com/bitnami-labs/sealed-secrets" target="_blank" rel="noopener noreferrer"> <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-lock"><rect x="3" y="11" width="18" height="11" rx="2" ry="2"></rect><path d="M7 11V7a5 5 0 0 1 10 0v4"></path></svg> Sealed Secrets </a> </li> <li role="none"> <a role="menuitem" class="header__nav__kubernetes__other" href="https://github.com/bitnami/charts" target="_blank" rel="noopener noreferrer"> <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-disk"><circle cx="12" cy="12" r="10"></circle><circle cx="12" cy="12" r="3"></circle></svg> Helm Charts </a> </li> <li role="none"> <a role="menuitem" href="https://bitnami.com/kubernetes" class="header__nav__kubernetes__all" target="_blank" rel="noopener noreferrer">See all projects</a> </li> </div> </ul> </li> <li> <a aria-expanded="false" aria-haspopup="true" class="header__nav__menu__item" href="#" tabindex="0">Developers</a> <ul aria-label="Developers" class="header__nav__submenu header__nav__developers" role="menu" aria-expanded="false"> <div class="header__nav__list"> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://docs.bitnami.com/"> <div class="header__nav__list__item__info"> <h3>Documentation</h3> </div> </a> </li> <li role="none" class='header-hide-mobile'> <a class="header__nav__list__item" role="menuitem" href="https://docs.vmware.com/en/VMware-Tanzu-Application-Catalog/services/tutorials/GUID-index.html" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Tutorials</h3> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://bitnami.com/support" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Support</h3> </div> </a> </li> </div> <div class="header__nav__list"> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://github.com/bitnami" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Open Source</h3> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://www.broadcom.com/company/careers" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>We're Hiring</h3> </div> </a> </li> </div> </ul> </li> <li> <a aria-expanded="false" aria-haspopup="true" class="header__nav__menu__item" href="#" tabindex="0">Company</a> <ul aria-label="Company" class="header__nav__submenu header__nav__company" role="menu" aria-expanded="false"> <div class="header__nav__company__links"> <div class="header__nav__list"> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://tanzu.vmware.com/content/tanzu-application-catalog-resources" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Resources</h3> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://blog.bitnami.com" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Blog</h3> </div> </a> </li> </div> <div class="header__nav__list"> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://www.broadcom.com/company/careers" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Careers</h3> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://www.vmware.com/company/news.html" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>VMware Newsroom</h3> </div> </a> </li> </div> </div> <div class="header__nav__company__contact"> Do you want to talk? <a role="menuitem" href="https://bitnami.com/contact" target="_blank" rel="noopener noreferrer">Contact Us</a> </div> </ul> </li> <div class='tocify header__nav__menu__toc'></div> </ul> <div class="header__nav__user"> <div class="search search-overlay margin-t-small"> <div class="input-group type-small"> <div class="search__input"> <input type="search" name="q" autocomplete="on" placeholder="Search" /> </div> </div> <div class='search__results elevation-2 padding-big'></div> </div> </div> </nav> </header> </div> <main> <section> <div class="container"> <nav class="breadcrumb margin-t-big"> <a href="https://docs.bitnami.com/">Bitnami Documentation</a> > <a href="https://docs.bitnami.com/aws/">AWS Cloud</a> > <a href="https://docs.bitnami.com/aws/apps/">Bitnami Stacks for AWS Cloud</a> > <a href="https://docs.bitnami.com/aws/apps/wordpress/">Bitnami package for WordPress for AWS Cloud</a> > <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/">Administration</a> > <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/change-data-directory-mariadb/">Modify the MariaDB data directory</a> </nav> </div> </section> <div class="container"> <div class="row collapse-on-phone collapse-on-phone-landscape"> <div class="col-3"> <div class="category__Navigation menu-foldable padding-big margin-t-bigger margin-b-enormous"> <nav> <h4 class="margin-t-reset margin-b-normal category__navtitle">Bitnami package for WordPress for AWS Cloud</h4> <h4 class="margin-t-small category__title page"> Getting started </h4> <ul class="margin-reset remove-style padding-l-reset"> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/first-steps/">Obtain application and server credentials</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/understand-default-ports/">Understand the default port configuration</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/wordpress-automattic/">Compare different Bitnami and Automattic WordPress solutions</a> </li> <div class="component margin-t-small">apache</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/understand-config/">Understand the default Apache configuration</a> </li> <div class="component margin-t-small">mariadb</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/understand-default-config-mariadb/">Understand the default MariaDB configuration</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/find-credentials-link-mariadb/">Obtain MariaDB credentials</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/connect-mariadb/">Connect to MariaDB</a> </li> <div class="component margin-t-small">mysql</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/understand-default-config-mysql/">Understand the default MySQL configuration</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/find-credentials-link-mysql/">Obtain MySQL credentials</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/connect-mysql/">Connect to MySQL</a> </li> <div class="component margin-t-small">php</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/understand-default-config-php/">Understand the default PHP configuration</a> </li> <div class="component margin-t-small">phpmyadmin</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/access-phpmyadmin/">Connect to phpMyAdmin</a> </li> </ul> <h4 class="margin-t-small category__title page"> Configuration </h4> <ul class="margin-reset remove-style padding-l-reset"> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/change-language/">Modify the interface language</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-plugins/">Install plugins</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/use-jetpack/">Configure and use the Jetpack plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/enable-installed-plugins/">Enable preinstalled plugins</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-smtp/">Configure SMTP for outbound emails</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-plugins-amp/">Install the Accelerated Mobile Pages (AMP) plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-plugins-allinone/">Install the All-in-One WP migration plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-plugins-wpdbmanager/">Install the WP-DBManager plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-plugins-polly/">Install the Amazon Polly plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/enable-cors-wordpress/">Enable CORS</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/wordpress-aws-s3/">Configure WordPress for cloud storage on Amazon S3</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/disable-wordpress-cron/">Disable the WordPress cron script</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-varnish/">Configure Varnish (TM) for WordPress</a> </li> <div class="component margin-t-small">apache</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/enable-modules/">Enable different Apache modules</a> </li> <div class="component margin-t-small">mariadb</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/create-database-mariadb/">Create a new MariaDB database and user</a> </li> <div class="component margin-t-small">mysql</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/create-database-mysql/">Create a new MySQL database and user</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-workbench/">Configure MySQL Workbench</a> </li> <div class="component margin-t-small">php</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-timezone/">Modify the default PHP timezone</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-modules-php/">Install different PHP modules</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-phpfpm-options/">Configure PHP-FPM options</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-phpfpm-processes/">Configure PHP-FPM processes</a> </li> <div class="component margin-t-small">phpmyadmin</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/enable-basic-auth/">Secure phpMyAdmin</a> </li> </ul> <h4 class="margin-t-small category__title page"> Administration </h4> <ul class="margin-reset remove-style padding-l-reset focus"> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/control-services/">Start or stop services</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/reset-wp-admin-email-address/">Reset the WordPress administrator email address</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/reset-wp-admin-password/">Reset the WordPress administrator password</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/reset-wp-admin-permissions/">Reset the WordPress administrator permissions</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/understand-file-permissions/">Understand WordPress filesystem permissions</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/configure-domain/">Configure the WordPress domain name</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/backup-restore-jetpack/">Create and restore application backups with the Jetpack plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/upgrade/">Upgrade WordPress</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/backup-restore/">Create and restore application backups</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/upload-files/">Upload files using SFTP</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-wpcli/">Use the WP-CLI command line tool</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-maintenance-mode/">Activate or deactivate maintenance mode</a> </li> <div class="component margin-t-small">apache</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/check-installed-modules/">List installed Apache modules</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-single-domain/">Access an application using only a single domain with Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/redirect-custom-domains/">Redirect custom domains to the Apache server</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/configure-port/">Modify the Apache port</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-htpasswd/">Password-protect access to an application with Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/publish-pages/">Publish web pages</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/create-ssl-certificate-apache/">Create an SSL certificate for Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/enable-https-ssl-apache/">Enable HTTPS support with Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/force-https-apache/">Force HTTPS redirection with Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/enable-http2-apache/">Enable HTTP/2 support with Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/check-ssl-certificate/">Troubleshoot SSL certificates and keys</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-htaccess/">Understand default .htaccess file configuration</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-pagespeed/">Use PageSpeed with Apache</a> </li> <div class="component margin-t-small">gonit</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/configure-use-gonit/">Configure and use Gonit</a> </li> <div class="component margin-t-small">mariadb</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/recover-database-mariadb/">Recover a MariaDB database</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/connect-remotely-mariadb/">Connect to MariaDB from a different machine</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/change-reset-password-mariadb/">Modify the default MariaDB administrator password</a> </li> <li class="margin-b-normal focus"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/change-data-directory-mariadb/">Modify the MariaDB data directory</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/secure-server-mariadb/">Secure MariaDB</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/backup-restore-mysql-mariadb/">Create and restore MySQL/MariaDB backups</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/encrypt-tables-mariadb/">Encrypt a MariaDB database table</a> </li> <div class="component margin-t-small">mysql</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/recover-database-mysql/">Recover a MySQL database</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/connect-remotely-mysql/">Connect to MySQL from a different machine</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/change-reset-password-mysql/">Modify the MySQL administrator password</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/change-data-directory-mysql/">Modify the MySQL data directory</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/secure-server-mysql/">Secure MySQL</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/backup-restore-mysql-mariadb/">Create and restore MySQL/MariaDB backups</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/encrypt-tables-mysql/">Encrypt a MySQL database table</a> </li> <div class="component margin-t-small">php</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/phpinfo/">Check PHP configuration</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/create-custom-application-php/">Create a custom PHP application</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/deploy-php-application/">Deploy a PHP application</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/increase-upload-limit-php/">Modify the PHP file upload limit</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/disable-phpfpm/">Disable PHP-FPM</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/enable-phpfpm/">Enable PHP-FPM</a> </li> <div class="component margin-t-small">phpmyadmin</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/export-database/">Export a database with phpMyAdmin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/increase-upload-limit-phpmyadmin/">Modify the phpMyAdmin file upload limit</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/modify-execution-time/">Modify the phpMyAdmin script execution time</a> </li> <div class="component margin-t-small">varnish</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/configure-use-varnish/">Configure and use Varnish(TM)</a> </li> </ul> <h4 class="margin-t-small category__title page"> Troubleshooting </h4> <ul class="margin-reset remove-style padding-l-reset"> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors/">Debug WordPress errors</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/optimize-bitnami-wordpress/">Optimize WordPress</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/enforce-security/">Secure WordPress</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/xmlrpc-and-pingback/">Re-enable XML-RPC pingback</a> </li> <div class="component margin-t-small">apache</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-apache/">Debug Apache errors</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/deny-connections-bots-apache/">Deny connections from bots/attackers using Apache</a> </li> <div class="component margin-t-small">mariadb</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-mariadb/">Check the MariaDB log files</a> </li> <div class="component margin-t-small">mysql</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-mysql/">Check the MySQL log file</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/disable-binary-logging-mysql/">Disable binary logging in MySQL</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/install-mysqltuner/">Install and run mysqltuner</a> </li> <div class="component margin-t-small">php</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-php-fpm/">Debug PHP-FPM errors</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/modify-execution-time/">Modify PHP script execution time</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/send-mail/">Send email with PHP using an external SMTP account</a> </li> <div class="component margin-t-small">phpmyadmin</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-phpmyadmin/">Debug phpMyAdmin errors</a> </li> <div class="component margin-t-small">varnish</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/deny-connections-bots/">Deny connections from bots/attackers using Varnish(TM)</a> </li> </ul> <h4 class="margin-t-small category__title related"> <a href="https://docs.bitnami.com/aws/apps/wordpress/related-how-tos/">Related guides for WordPress</a> </h4> </nav> </div> </div> <div class="col-7"> <article class="margin-t-bigger margin-b-enormous padding-h-normal"> <h1> Modify the MariaDB data directory </h1> <section class="category__Content change-data-directory-mariadb"> <blockquote> <p>NOTE: We are in the process of modifying the configuration for many Bitnami stacks. On account of these changes, the file paths and commands stated in this guide may change depending on whether your Bitnami stack uses MySQL or MariaDB. To identify which database server is used in your stack, run the command below:</p> <pre><code> $ test -d /opt/bitnami/mariadb && echo "MariaDB" || echo "MySQL" </code></pre> <p>The output of the command indicates which database server (MySQL or MariaDB) is used by the installation, and will allow you to identify which guides to follow in our documentation for common database-related operations.</p> </blockquote> <ul> <li> <p>Bitnami installations that use system packages contain the MariaDB data at the <em>/bitnami/mariadb/data</em> directory, by default. Check it by running the following command:</p> <pre><code> $ cat /opt/bitnami/scripts/mariadb-env.sh | grep DB_DATA_DIR export DB_DATA_DIR="${DB_VOLUME_DIR}/data" </code></pre> <blockquote> <p>NOTE: The <em>DB_VOLUME_DIR</em> environment variable is set to <em>/bitnami/mariadb</em>.</p> </blockquote> </li> <li> <p>To change the location of the MariaDB data directory, modify the <em>/opt/bitnami/scripts/mariadb-env.sh</em> file as shown below:</p> <pre><code> ... export DB_DATA_DIR=/bitnami/mariadb/data ... </code></pre> </li> <li> <p>Finally, move the <em>data/</em> directory to the new location and restart the database.</p> </li> </ul> </section> </article> </div> <div class="col-2"> <aside class="documentable__sidebar padding-big margin-t-bigger"> <h4 class="margin-t-reset">In this article</h4> <div class="tocify documentable__sidebar__toc"></div> </aside> <section class="documentable__lastmod padding-big padding-l-bigger margin-v-enormous"> Last modification <span class="date">February 9, 2023</span> </section> </div> </div> </div> </main> <footer class='footer bg-dark type-color-reverse-anchor-reset'> <div class='container padding-v-bigger'> <div class='row collapse-b-desktop'> <div class='col-3 footer__copyright'> <h4 class="inverse"> <img src="https://d33np9n32j53g7.cloudfront.net/assets/logos/bitnami-by-vmware-dark-bg.svg" alt="Bitnami by VMware Logo" class=logo /> </h4> <a href="https://twitter.com/Bitnami" class="socialIcon margin-r-small"><svg role=img aria-label="See Bitnami's Twitter profile" viewBox="0 0 54 54" xmlns="http://www.w3.org/2000/svg"> <title id="twitter_title">See Bitnami's Twitter profile.</title> <desc id="twitter_desc">Twitter icon</desc> <circle fill=currentColor cx=27 cy=27 r=27 /> <path d="M14 35.618A15.166 15.166 0 0 0 22.177 38c9.904 0 15.498-8.313 15.162-15.77A10.761 10.761 0 0 0 40 19.485c-.957.422-1.985.707-3.063.834a5.314 5.314 0 0 0 2.344-2.932 10.729 10.729 0 0 1-3.386 1.287A5.344 5.344 0 0 0 32 17c-3.442 0-5.973 3.193-5.195 6.51a15.17 15.17 0 0 1-10.994-5.54 5.288 5.288 0 0 0 1.65 7.078 5.33 5.33 0 0 1-2.417-.663c-.057 2.456 1.714 4.753 4.279 5.265-.751.204-1.573.25-2.408.09a5.33 5.33 0 0 0 4.982 3.683A10.767 10.767 0 0 1 14 35.618" fill=currentColor /> </svg> </a><a href="https://github.com/bitnami" class="socialIcon margin-r-small"><svg role=img aria-label="See Bitnami's Github profile" viewBox="0 0 54 54" xmlns="http://www.w3.org/2000/svg"> <title id="github_title">See Bitnami's Github profile.</title> <desc id="github_desc">Github icon</desc> <circle fill=currentColor cx=27 cy=27 r=27 /> <path d="M27.5 14C20.044 14 14 19.968 14 27.33c0 5.888 3.868 10.885 9.233 12.647.675.122.921-.289.921-.642 0-.317-.011-1.155-.018-2.268-3.755.806-4.547-1.786-4.547-1.786-.614-1.54-1.5-1.95-1.5-1.95-1.225-.827.094-.81.094-.81 1.355.094 2.067 1.373 2.067 1.373 1.204 2.038 3.16 1.45 3.93 1.108.122-.861.47-1.449.856-1.782-2.997-.336-6.149-1.48-6.149-6.588 0-1.455.526-2.644 1.39-3.576-.14-.337-.603-1.693.132-3.527 0 0 1.133-.36 3.712 1.366a13.085 13.085 0 0 1 3.38-.449c1.146.005 2.301.153 3.38.449 2.577-1.725 3.708-1.366 3.708-1.366.737 1.834.273 3.19.134 3.527.865.932 1.388 2.121 1.388 3.576 0 5.12-3.156 6.248-6.164 6.578.485.411.917 1.225.917 2.468 0 1.782-.017 3.22-.017 3.657 0 .356.243.77.928.64C37.135 38.21 41 33.218 41 27.33 41 19.968 34.955 14 27.5 14" fill=currentColor /> </svg> </a><a href="https://www.youtube.com/user/bitrock5" class="socialIcon margin-r-small"><svg role=img aria-label="See Bitnami's Youtube profile" viewBox="0 0 54 54" xmlns="http://www.w3.org/2000/svg"> <title id="youtube_title">See Bitnami's Youtube profile.</title> <desc id="youtube_desc">Youtube icon</desc> <circle fill=currentColor cx=27 cy=27 r=27 /> <path d="M24.2 31.286v-8.572L31.474 27 24.2 31.286zm16.215-11.163a3.543 3.543 0 0 0-2.476-2.526C35.756 17 27 17 27 17s-8.755 0-10.938.597a3.544 3.544 0 0 0-2.476 2.526C13 22.351 13 27 13 27s0 4.649.585 6.877a3.543 3.543 0 0 0 2.476 2.526C18.244 37 27 37 27 37s8.756 0 10.94-.597a3.543 3.543 0 0 0 2.475-2.526C41 31.649 41 27 41 27s0-4.649-.585-6.877z" fill=currentColor /> </svg> </a><a href="https://www.linkedin.com/company/bitnami" class=socialIcon><svg role=img aria-label="See Bitnami's LinkedIn profile" viewBox="0 0 54 54" xmlns="http://www.w3.org/2000/svg"> <title id="linkedin_title">See Bitnami's LinkedIn profile.</title> <desc id="linkedin_desc">LinkedIn icon</desc> <circle fill=currentColor cx=27 cy=27 r=27 /> <path d="M20.6 17.8c0 1.542-1.253 2.8-2.8 2.8S15 19.35 15 17.8c0-1.542 1.253-2.8 2.8-2.8s2.8 1.258 2.8 2.8zm0 5.2h-4.8v16h4.8V23zm7.889-.303H23.8V39h4.689v-8.553c0-2.295 1.024-3.656 2.979-3.656 1.802 0 2.666 1.309 2.666 3.656V39H39V28.676c0-4.364-2.395-6.476-5.755-6.476-3.351 0-4.765 2.697-4.765 2.697v-2.2h.009z" fill=currentColor /> </svg> </a><p class='type-color-light type-small'> Copyright © 2005-2024 Broadcom. All Rights Reserved. The term "Broadcom" refers to Broadcom Inc. and/or its subsidiaries. </p> </div> <div class="col-9"> <div class='row collapse-3-on-phone-land collapse-2-on-phone'> <div class="col-2"> <ul class='remove-style padding-reset'> <h3>Products</h3> <li><a href="https://bitnami.com/stacks">Application Catalog</a></li> <li> <a href="https://bitnami.com/enterprise" target="_blank" aria-label="Open in new tab" > VMware Tanzu App Catalog </a> </li> </ul> </div> <div class=col-2> <ul class='remove-style padding-reset'> <h3>Projects</h3> <li><a href="https://kubeapps.dev">Kubeapps</a></li> </ul> </div> <div class=col-2> <ul class='remove-style padding-reset'> <h3>Solutions</h3> <li><a href="https://bitnami.com/kubernetes">Kubernetes</a></li> </ul> </div> <div class=col-2> <ul class='remove-style padding-reset'> <h3>Company</h3> <li><a href="https://www.broadcom.com/company/careers">Careers</a></li> <li><a href="https://tanzu.vmware.com/content/tanzu-application-catalog-resources">Resources</a></li> <li><a href="https://blog.bitnami.com">Blog</a></li> <li><a href="https://bitnami.com/contact">Contact</a></li> </ul> </div> <div class=col-2> <ul class='remove-style padding-reset'> <h3>Legal</h3> <li><a href="https://www.vmware.com/help/legal.html">Terms of Use</a></li> <li><a href="https://bitnami.com/trademark">Trademark</a></li> <li><a href="https://www.vmware.com/help/privacy.html">Privacy</a></li> <li><a href="https://www.vmware.com/help/privacy/california-privacy-rights.html">Your California Privacy Rights</a></li> </ul> </div> <div class=col-2> <ul class='remove-style padding-reset'> <h3>Support</h3> <li><a href="https://docs.bitnami.com/">Docs</a></li> <li><a href="https://github.com/bitnami/vms/issues">Bitnami Images</a></li> <li><a href="https://github.com/bitnami/charts/issues">Helm Charts</a></li> <li><a href="https://github.com/bitnami/containers/issues">Containers</a></li> </ul> </div> </div> </div> </div> </div> </footer> <script>build_search_menu('aws', 'wordpress', 'apps')</script> </body> </html>