Using phpMyAdmin to manage your data

Using phpMyAdmin to manage your data

What you'll learn: how to open phpMyAdmin and use it to look at, edit, back up, or restore your database.

What's phpMyAdmin?

phpMyAdmin is a web-based tool for working with databases directly. You'd use it to:

  • Look up specific data (like find a user record)
  • Make small fixes (change one value)
  • Export a copy of your database (a backup)
  • Import a database (restore one, or move one in from another host)

Open phpMyAdmin

Sidebar → Databases → click your database → Open in phpMyAdmin (or a similar link).

It opens in a new tab and signs you in automatically — no extra password needed.

[screenshot here: phpMyAdmin interface]

A quick tour

  • Left sidebar: your databases (you'll usually see just one, the one you opened).
  • Tables: clicking a database shows its tables. WordPress, for example, has tables like wp_posts, wp_users, wp_options.
  • Click a table: see the rows it contains.
  • SQL tab: run SQL queries directly. Powerful but unforgiving — see "safety" below.
  • Export tab: download a copy of your database.
  • Import tab: upload a database file.

How to back up (export)

  1. Click your database in the left sidebar.
  2. Click Export at the top.
  3. Pick Quick for a simple backup, Custom if you need options.
  4. Format: SQL.
  5. Click Go.

A .sql file downloads. That's a complete backup of your database — keep it somewhere safe.

Do this before any risky change, and definitely before you upgrade an app like WordPress.

How to restore (import)

  1. Click your database in the left sidebar.
  2. Click Import at the top.
  3. Choose the .sql file from your computer.
  4. Click Go.

The data is read in. Existing data of the same name will be overwritten — so usually you'd import into a fresh, empty database.

Editing a row by hand

  1. Open a table.
  2. Find the row you want to change.
  3. Click the pencil icon next to it.
  4. Edit the value.
  5. Click Go.

A safety note

phpMyAdmin lets you do anything to your database — including delete everything in seconds.

  • Always export before making changes. A 30-second backup can save hours of recovery.
  • Don't run SQL you don't understand. "Just paste this" isn't a good plan if you don't know what it does.
  • Avoid deleting tables unless you're absolutely sure.

Tips

  • Use search. The Search tab inside a table is faster than scrolling.
  • Filter on a column by clicking the filter icon at the column header.
  • For very large databases, the browser interface can be slow — use SFTP and mysql from the command line if you're comfortable.

If something goes wrong

  • Import fails halfway — your file might be too large. Try splitting it, or ask your hosting provider to import it for you (they have command-line tools that handle big files easily).
  • "Access denied" — your account doesn't have permission for that database. You can only access databases on your own account.
  • You made a wrong edit — restore from your most recent export. (You did make one before editing… right?)

Related articles