What Is phpMyAdmin
Backup Software / Backup Terms Glossary / Databases / phpMyAdmin
phpMyAdmin is a free web application that provides a convenient GUI for working with the MySQL database management system. It is the most popular MySQL administration tool that is used by millions of users worldwide and has won numerous awards and honors.
Written in PHP, it has all common functions that you may need when developing a MySQL-based application or website. It also gave birth to several similar products, for example phpPgAdmin which provides similar functionality for the PostgreSQL DBMS.
You can use phpMyAdmin for Windows or almost any other operating system ever existed. It can export and import database created and managed by MySQL DBMS, as well as work with some other data formats.
The list of supported formats includes SQL, CVS, CodeGen, CVS for Microsoft Excel, Microsoft Word 2000, JSON, LaTeX, MediaWiki Table, OpenDocument Spreadsheet, OpenDocument Text, PDF, PHP Array, Texy! Text and YAML data types.
With phpMyAdmin you can:
The tool is very simple to set up and use. It is usually installed on the same computer with MySQL database, so all commands are executed very quickly and don’t rely on network connectivity.
While phpMyAdmin is a perfect tool for browsing the database, managing user privileges and executing SQL queries, it can’t be considered a full-featured administration tool.
Administration expects you to not only be able to work with an object, but also deal with unpredictable situations, such as SQL injections, user mistakes and other cases of database corruption. Especially it touches the matter of automatic MySQL backup.
The export/import functionality of phpMyAdmin lacks a lot of the features that you would expect to find in a backup software solution:
Version 7.16.0, built on 31 July, 2018. 164 MBBackup Software from Novosoft LLC. 249 USD per license.
If you have a MySQL database that you need to administer, and searching for a MySQL backup tool, then you need the Small Server edition. Try our small business backup software for 30 days for free!
The good news about backing up MySQL tables with phpMyAdmin is that it saves data as database dumps, similarly to how Handy Backup and mysqldump work.
Resulting files can be used not only for disaster recovery, but also to conduct different experiments and migrate from MySQL to other database management systems. You can learn more about it on the MySQL Recovery feature page.
Version 7.16.0, built on 31 July, 2018
Read about how to back up with one more management tool that has all the features of phpMyAdmin - HeidiSQL backup.
See all terms from Databases...
Backup Terms Glossary
Current glossary explains various terms that you may come across while working with Handy Backup or other backup software.
Handy Backup is a backup utility for Windows Servers and PCs that is famous for its flexibility and ease of use.
The glossary contains 192 terms. The current section Databases contains 18 terms.
Copyright © 2004-2018 Novosoft LLC. All rights reserved. Handy Backup software.
United States, P.O.Box 535, Louisville, OH 44641 Tel.: +1 (707) 703-13-11
Back to Top