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 Server

Version 7.12.0, built on 20 April, 2018. 85,1 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.

Version 7.12.0, built on 20 April, 2018
85,1 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

support@handybackup.net

sales@handybackup.net

Term of the Day

  • CD replication
    “CD replication is a process of manufacturing a CD from scratch using a single original disc. The result of the CD replication process is a CD...”

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

Other “Databases” Terms

  • Foreign Key
    “Foreign key is a field in a “child” table of a database that is used to refer to a record in a “parent” table of the same...”
  • InnoDB: Definition of InnoDB, Target Uses of the InnoDB Storage Engine
    “InnoDB is a data storage engine used by default in MySQL database since version 5.5. It has a strong focus on reliability and performance, and...”
  • Shared-Nothing Architecture
    “Shared-nothing architecture (SNA) is a pattern used in distributing computing in which a system is based on multiple self-sufficient nodes that have...”

Who uses our backup software?