AAPANEL: HOW TO CUSTOMIZE, MANAGE & BACKUP DATABASE – SIDEBAR MENU

aaPanel: Everything about Database & sidebar menu

Table of Contents

If you are looking for a powerful and easy-to-use database management solution, aaPanel is the perfect choice. Whether you are managing a simple website with just a few files and pages, or more complex content with dynamic functionality, aaPanel makes it easy to manage everything within one system. In this article, we will show you how to manage your aaPanel database – as well as how to customize and back up your database. Let’s get started!

What is aaPanel database?

aaPanel is a powerful yet easy to use web hosting control panel that lets you manage your website’s files (content, images, etc.), email accounts and more. With aaPanel, you can easily create, modify, and backup your database to ensure that it runs smoothly and efficiently.

 

Several different types of databases can be managed using aaPanel, including MySQL for storing dynamic content, flat file databases for storing static content like HTML or CSS files, and MongoDB for storing complex datasets. Additionally, aaPanel enables you to customize settings according to your specific needs and preferences. For example, you can adjust database permissions to control which users have access to certain data.

Why is it important to manage aaPanel database properly?

Learning to manage aaPanel database properly is important for several reasons. First, it ensures that everything on your website runs smoothly and efficiently, preventing data loss and performance issues.

 

Additionally, it allows you to customize settings based on your preferences or specific needs. This helps improve usability and ensures that you are getting the most out of your database system.

 

Finally, proper database management also enables you to back up your database regularly, which helps protect against data loss in the event of an unexpected issue or outage.

How to customize & backup aaPanel database

 

Here, we will show you how to set up aaPanel database – including all of the most frequently asked actions step-by-step. Every instruction below followed with captured images from 1Byte dashboard for demonstration. Let’s dive in now!

1) Add database

 

To successfully create a database, first input the database name, then pick the encoding type, enter the password, and configure the access rights.

  • DBname: the name of the new database; pick the encoding format, which is UTF-8 by default.

  • Password: The default password is a random password that you may change.

 

  • Permission: The local server permission is the default. Everyone or provide an IP address are the possibilities.

  • Force SSL: Force the user to utilize an SSL connection, which may render the client unreachable if it lacks a certificate (the certificate can be downloaded in the SSL tag of the MySQL manager)

2) Change root password

 

If you are unable to add data or are being prompted for an incorrect password, you can try to change the root password to resolve the issue.

 

Note that the default password is random, and root is the password for the highest-privilege account. Please proceed with care.

3) Backup Database

Manual backup

 

  1. In the Database session, find the Backup column.

  2. Click on Backup exists, then click Backup button in pop-up.

 

Automatic backup

 

  1. In the Database session, find the Backup column.

  2. Click on Backup exists, then click Backup button in pop-up.

 
AAPANEL: HOW TO CUSTOMIZE DATABASE – SIDEBAR MENu

 

  1. Go to the Cron session on the sidebar.

  2. At Type of Task field, choose Backup Database.

  3. At Backup database field, type name of database you want to backup.

  4. Click on the Add Task button.

4) Restore & Import

Restore

  1. In the Database session, find the Backup column.

  2. Click on Backup exists to show Database Backup Details pop-up.

  3. Find Operation column, click on Restore.

Import

AAPANEL: HOW TO CUSTOMIZE DATABASE – SIDEBAR MENu
  1. In the Database session, find the Backup column.

  2. Click on Import to show a pop-up.

  3. Click on Upload from local.

Side facts

 

  • You have the option of uploading locally or restoring the backed-up files.

  • By default, the database is located in /www/backup/database.

  • All of the backup imports above make use of mysqldump.

  • The imported sql file’s format must be consistent with the standard. If you utilize the sql file exported by phpmyadmin.

  • Information such as the version code may be missing, preventing the file from being successfully imported by mysqldump.

  • If you are unable to import normally, you can use phpmyadmin to import.

5) Permission Management

  1. In the Database session, find the Operation column.

  2. Click on Permission to show a pop-up

  3. Set Permission and Force SSL, then Submit.

Additional information

 

  • Local server: Restricts access to the current database to this server.

  • Anyone: Anyone can connect remotely to the database.

  • IP address: Only specified IP addresses are supported; only one IP address is supported.

  • If you require external network connectivity, you must still open the MySQL port in the firewall (default 3306).

  • Forcing SSL: Forcing the user to use an SSL connection, which may render the client without a certificate unreachable (the certificate can be downloaded in the SSL tag of the MySQL manager)

6) Change Database password

  1. In the Database session, find the Operation column.

  2. Click on CHG PW to show a pop-up

  3. Type your new password, then Submit

 

Note: This password is not the root password; so that you need to modify the root password.

Conclusion

That’s it! That’s all the information about how to customize, manage & backup aaPanel Database. You can also check these articles about FTP management in aaPanel and monitor the sidebar menu in aaPanel as well.

 

Thanks!

OTHER RESOURCES YOU MIGHT BE INTERESTED IN:

+ aaPanel RoundCube Mail Server: How to set up

+ aaPanel FTP: How to manage & customize

+ Upload website to aaPanel: How to do it right

+ Create a website with aaPanel

+ Common settings of aaPanel