Manage and take full control of your WordPress database with ARI Adminer and Shifter.

ARI Adminer is a drop-in replacement to PhpMyAdmin offering an intuitive interface, support for the latest MySQL features with added performance and security. Built using Adminer, database management tool in a single PHP file, it’s a simple yet versatile tool for web developers or administrators.

There are plenty of reasons why Adminer became a go-to WordPress database management tool but you don’t have to take my word for it, check out the full list on their site.

Adminer and Shifter provide a powerful combination for managing and deploying WordPress websites. With Adminer, direct database changes can be handled easily and reliably, ensuring any updates remain stable. With the addition of Shifter, a WordPress static site generator, users can maintain the core features of WordPress while deploying their site securely. This provides an ideal and efficient solution for those seeking to manage and deploy their WordPress websites with confidence.

It is important to note that Adminer should be used with caution and at one’s own risk. To ensure that no data is lost in the event of an unexpected error, it is highly recommended to export the database for safe keeping both during and after using Adminer. Additionally, Shifter automates backups on each website deployment, providing an extra layer of security for data protection. Taking these safety measures will help to ensure that any data remains secure and protected.

Installing ARI Adminer

1. Navigate to the WordPress Plugins install page from within your WordPress site on Shifter and search “ARI Adminer”
2. Click Install and Activate
3. Accessing Ari Adminer: ARI Adminer will add its own tab navigation to your WordPress
4. Admin Dashboard. Navigate to this tab to get started.

​There are two options for running Adminer within WordPress. We recommend running Adminer with in a Modal window. This will keep your WordPress container active during use.

​This is the Adminer control panel. From here to can import, export, run commands, and navigate your database data.

​Exporting your database with ARI Adminer

1. Click the export option in the left control panel
2. Choose output file type such as zip
3. Choose your prefered file format
4. Choose other options if you need specific tables, and more
5. Click export and your download should begin

Dropping a database with ARI Adminer

Caution: This operation cannot be undone

1. Choose your database
2. Check the topmost checkbox to select all database rows
3. Click Drop

Import an existing database with ARI Adminer

 Caution: This operation cannot be undone

1. Click [Import]
2. Select file to import
3. Click [Execute]
4. Check imported data​

Running SQL Commands with ARI Adminer

Caution: this operation cannot be undone

1. Click [SQL command]
2. Input SQL command in text area in right page
3. Click [Execute]
4. Check output​