phpMyAdmin Definition

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.

Overview of phpMyAdmin Capabilities

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.

General Features

With phpMyAdmin you can:

  • Create and remove users, manage user permissions
  • Create, alter and drop databases, tables, fields and rows
  • Search objects in the entire database or any particular tables
  • Import and export data in different formats, including SQL, XML and CSV
  • Monitor processes and track performance of different queries
  • Execute custom SQL queries
  • Back up your MySQL databases in manual mode

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.

Administering MySQL DBMS

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.

Data Backup Problems of phpMyAdmin

The export/import functionality of phpMyAdmin lacks a lot of the features that you would expect to find in a backup software solution:

  • Scheduling. With phpMyAdmin there is no way to export database data automatically.
  • Storage media support. Since phpMyAdmin is a web-based software, you can work with it via browser only. This means that you can save backups only to local drives available on your system, via the Save As... dialog of your browser.
  • Compression, encryption, and other options. The files exported with phpMyAdmin are saved as common text files, without any additional processing. Storing them in the original form usually occupies a lot of disk space, and is not secure.

Recommended Backup Solution

Handy Backup Small Business

Version 8.1.2, built on 21 February 2020. 106 MB
Backup Software from Novosoft LLC. 249 USD per license.

Handy Backup Small Server

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!

Dumping MySQL Databases with phpMyAdmin

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.

Download Handy Backup

Version 8.1.2, built on 21 February 2020
106 MB

Read about how to back up with one more management tool that has all the features of phpMyAdmin - HeidiSQL backup.

See also:

See all terms from Databases...

Backup Terms Glossary

Contact Us

Term of the Day

  • MMC Memory Card
    “A flash memory card that provides storage for cellphones, PDAs and other handheld devices. Introduced in 1997 with a 4MB capacity, the 32x24x1.4mm...”

Backup Software 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 173 terms. The current section Databases contains 18 terms.

Other “Databases” Terms

  • Logical Backup
    “Logical backup is a copy of objects used in an application (e.g. database tables), that is made by accessing them through the application’s...”
  • What Is 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...”
  • How to Replicate MySQL Database on Linux
    “MySQL replication on Linux is an important task for several users, as the growing world of Linux actively includes MySQL data in many individual and...”

Who uses our backup software?