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, used by millions of users worldwide, and has won numerous awards and honors.
Version 8.2.2, built on February 24, 2021 112 MB
This PHP utility has all common functions that you may need when developing a MySQL-based application or website. It is also a reference for several similar products, for example, phpPgAdmin, which provides similar functions 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, and works with some other data formats.
The list of formats supported by phpMyAdmin 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 do such things as:
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 do not rely on network connectivity.
While phpMyAdmin is a perfect tool for browsing the database, managing user privileges and executing SQL queries, it is not a full-featured SQL administration tool. It lacks some protective measures for unpredictable situations, such as SQL injections, user mistakes and other cases of database corruption.
Tip: The only answer to these perils is 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 8.2.2, built on February 24, 2021. 112 MBBackup Software from Novosoft LLC. 249 USD per license.
The Small Business edition is an excellent example of small business backup software, capable for all backup tricks of phpMyAdmin and much more. Try it by downloading a 30 days free trial version!
A very useful feature of phpMyAdmin is that it make MySQL backup as database dumps, similarly to how Handy Backup and mysqldump utility. You can freely use the resulting files for disaster recovery, to conduct different experiments or to migrate from MySQL to another database management system.
Learn more about MySQL dump capabilities on the MySQL Recovery feature page.
You can schedule any Handy Backup task to run at an exactly predefined time, and repeat it with an exact interval from one minute to several months. In advanced mode, you can also trigger a task to run when some crucial system event (such as user logon/logoff) occurs.
Like phpMyAdmin, Handy Backup allows storing dumps as text files with SQL commands. In addition, it provides such functions as data compression and encryption by built-in algorithms, which can add greatly to security and reduce the size of backups in storage.
Unlike phpMyAdmin, Handy Backup allows directly placing MySQL backups to several different places, including local and external drives, network shared resources. FTP servers, S3 and WebDAV clouds (both private and commercial), and popular cloud storage like Amazon S3, Box, Google Drive or Dropbox.
Tip: Read about how to back up with one more management tool that has all the features of phpMyAdmin - HeidiSQL backup.
Copyright © 2004-2021 Novosoft LLC. All rights reserved. Handy Backup software.10685-B Hazelhurst Dr., Houston, TX 77043, United States Tel.: +1 (707) 703-13-11
Back to Top