Knowledge Base

Managing Databases with phpMyAdmin

phpMyAdmin provides a visual interface for managing MySQL databases.

Accessing phpMyAdmin

1. Log into DirectAdmin
2. Click MySQL Management
3. Click phpMyAdmin link next to your database

Common phpMyAdmin Tasks

Browsing Data

1. Click your database name (left sidebar)
2. Click a table name
3. Click Browse to see data

Running SQL Queries

1. Select your database
2. Click SQL tab
3. Enter your query
4. Click Go

Exporting (Backup)

1. Select your database
2. Click Export
3. Choose format (SQL recommended)
4. Click Go to download

Importing

1. Select your database
2. Click Import
3. Choose your SQL file
4. Click Go

Search and Replace

1. Select your database
2. Click Search tab
3. Enter search and replace values

Caution

Always backup your database before making changes. phpMyAdmin changes are permanent!