Exporting a recoverable database backup in phpMyAdmin

Identify the database from the application’s configuration and confirm you have access to every required table. For a busy transactional application, use its supported maintenance or consistent-backup approach so related records are captured coherently.

1. Open phpMyAdmin and select the intended database. Review its table names to confirm it belongs to the correct application.
2. Choose Export and select SQL. A quick export suits a straightforward full database copy; use Custom when you need to inspect table selection and options.
3. Include both structure and data for a full recovery copy. Include relevant triggers, routines or events only when the application uses them and your export permissions support them.
4. Download the file, using supported compression for a large export if helpful. Record the database name, application version and creation time separately.
5. Check that the file is nonempty and readable, then test restoration into an isolated database when the backup will support a significant change.

A useful backup can recreate the expected tables and representative records. Verify important text encoding and any required objects rather than relying on filename or archive size alone.

If export fails or times out, use a supported server-side backup method or contact support. A database export does not include website uploads, configuration files or mailboxes. Keep the matching website backup when planning a full application recovery.

• Importing a database backup with phpMyAdmin
• Editing one database row safely in phpMyAdmin
• Creating and downloading a full SiteWorx backup
• Can phpMyAdmin repair a damaged database table?

• phpMyAdmin: Import Export