Using PHPMyAdmin: Difference between revisions
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
== Basic Usage == | == Basic Usage == | ||
Once you've logged in, you will see your username on the left, you can click the plus sign to reveal all your databases. You can then view databases and tables. For each table you can view the records, view and change the structure, add records, take backups, etc. Detailed documentation is available on the PHPMyAdmin [https://www.phpmyadmin.net/docs/ official documentation website] | |||
== Taking Backups == | == Taking Backups == | ||
Revision as of 16:37, 9 September 2019
You can access your MySQL databases using PHPMyAdmin. This application can be found on https://phpmyadmin.ulyssis.org. To login you need to use your MySQL password, this password is different from your account password for security reasons as well as convenience. In case you've forgotten your MySQL password you can get it from your websites configuration file. This is usually called config.php, wp-config.php, settings.php or something similar.
Basic Usage
Once you've logged in, you will see your username on the left, you can click the plus sign to reveal all your databases. You can then view databases and tables. For each table you can view the records, view and change the structure, add records, take backups, etc. Detailed documentation is available on the PHPMyAdmin official documentation website
Taking Backups
To take a backup of all your databases you simple select "Export" on the main menu and press start. You can later restore backups by uploading the file to the "Import" page.
