How to Create, Manage, Backup, and Restore Databases in CloudPanel?

[Nemesis]

I'm getting started with CloudPanel and need some guidance on managing databases. Could you explain how to create/delete databases and database users, manage databases with phpMyAdmin, and also how to safely export/import databases? Additionally, how does CloudPanel handle automatic database backups?

 

[Rootali]

CloudPanel provides straightforward tools for managing your databases:

Creating a Database:​

• Click on "Add Database".
• Enter your Database Name, Database User Name, and Password.
• Click "Add Database".

Deleting a Database:​

• Click on "Delete" next to the database.
• Confirm the action.

Managing Database Users:​

• Adding a User:
  • Click on "Add Database User".
  • Enter User Name, Password, select the Database, and set Permissions.
• Deleting a User:
  
  • Click "Delete" next to the user and confirm.

---

phpMyAdmin:​

• Click "Manage" to access your database via phpMyAdmin.

Attention:
Avoid using phpMyAdmin for exporting/importing databases, as it can lead to corruption or data loss. Instead, use CloudPanel's built-in commands as explained below.

---

Exporting Databases (Recommended Method):​

Export your database safely via SSH using mysqldump:

1. Login via SSH:
2. Navigate to your preferred backup directory, e.g.:
3. Export the database (compressed/uncompressed): # Compressed (.gz)

   clpctl db:export --databaseName=my-database --file=dump.sql.gz

   # Uncompressed

---

Importing Databases:​

Use CloudPanel’s built-in import tool via SSH:

1. Login via SSH:
2. Go to your database dump directory and run:

---

Automatic Database Backups:​

CloudPanel automatically creates database backups every night at 3:15 AM, keeping them for 7 days.

• Backup location:
• To adjust backup frequency or retention:
  1. Login via SSH as root:
  2. Edit the cron job:
  3. Modify schedule or retention: # Default schedule (daily at 03:15 AM)

---

Database Master Credentials:​

• To view your master database credentials:

Remote Database Access:​

• If you need remote access, go to the Firewall section in CloudPanel's Admin Area and whitelist your IP address for MySQL port 3306.

This setup ensures secure, reliable, and convenient database management with CloudPanel.