Managing Database Using phpMyAdmin
phpMyAdmin is a web-based tool for administering MariaDB and MySQL. This article describes how you can manage your database using phpMyAdmin in the Control Panel.
1. Locate your target deployment
Log in to the Control Panel and locate your target deployment on the Home page or the My Applications page.
2. Navigate to the “phpMyAdmin” page
Click the "Manage" button on the Home page or the My Applications page to go to the phpMyAdmin page.
3. Access phpMyAdmin
Click “Launch” to go to the login interface of phpMyAdmin.
On the phpMyAdmin interface, you will see the database of your Moodle on the left panel. Click on the database you want to manage.
On this new page, you will see a list of the database tables, the allowed actions with them, the number of the records, the storage engine, the collation,etc.
4. Perform Common Functions in phpMyAdmin
In the top menu, you’ll see various options for the database you’re working with, such as: Structure, SQL, Search, Query, Export, Import, Operations, Privileges, Routines, etc.
Note: when you import files using phpMyAdmin, the file size can not excess 100M.