Importing and exporting databases

Database Backup & Restore

Export databases for backup or migration, and import to restore.

Exporting a Database

1. Open phpMyAdmin
2. Select your database
3. Click Export
4. Choose Quick method
5. Format: SQL
6. Click Go
7. Save the .sql file

Custom Export Options

Select Custom for more control:

• Choose specific tables
• Add DROP TABLE statements
• Include CREATE DATABASE
• Compress output (gzip)

Importing a Database

1. Create an empty database first (if needed)
2. Open phpMyAdmin
3. Select the target database
4. Click Import
5. Click Choose File
6. Select your .sql file
7. Click Go

Large Database Imports

phpMyAdmin has size limits. For large databases:

1. Upload .sql file via File Manager
2. Use cPanel → MySQL Databases → Import
3. Or contact support for assistance