Practical setup, management and troubleshooting guides for Phpmyadmin.

Articles

Can phpMyAdmin repair a damaged database table?

Only some storage engines support the SQL REPAIR TABLE operation. InnoDB tables are not...

Deleting an unused database table with phpMyAdmin

Dropping a table permanently removes its structure and stored rows. Use this only for a table...

Editing one database row safely in phpMyAdmin

phpMyAdmin can change individual records, but direct edits bypass an application’s validation...

Exporting a recoverable database backup in phpMyAdmin

An SQL export saves database structure and data in a form that can be restored later. Download...

Importing a database backup with phpMyAdmin

phpMyAdmin can import an SQL backup into a selected database. The file may create, replace or...

When and how to optimise a table in phpMyAdmin

Table optimisation can reclaim or reorganise storage after substantial data changes, depending...