phpMyAdmin is a PHP-based interface for managing MySQL databases, much more preferred than others. It is offered for free and allows performing many tasks through a simple interface that does not require knowledge of complex SQL codes.
What Can Be Done
- Records of operations performed can be viewed
- Tables in the database can be created, their properties changed, deleted
- New variables can be added to tables, their properties changed, deleted
From the database tab, you can view your existing databases. With Import and Export options, you can back up and download your database.
Import
To perform this operation, we need to create a new, empty database from the cPanel – Databases section. Select your database from the left section and then click the Import tab from the top menu. In the screen that appears, click Browse to select the database we will import from our computer. We do not make changes in the file character set, format, and compatibility type sections, and click “Go” from the bottom option to complete the operation.
Export
The “Export” option is used to back up or transfer the current database to another system. Click “Go” to download the SQL database to your computer.
Leave a Comment
* Your comment will be published after approval.
Comments
0No comments yet. Be the first to comment!