Knowledge Base

Importing or exporting databases are common tasks when managing your website, especially when moving to a new server or backing up data. Using phpMyAdmin in cPanel, these processes become simple and straightforward.

✅ Why Import/Export Databases?

• Backup: Safeguard your database to prevent data loss.
• Migration: Move your website’s content between different hosts or environments.
• Restoration: Restore a database to a previous version after an issue or change.

🛠 Step-by-Step: Exporting a Database in cPanel

1. Log in to cPanel
   • Navigate to: yourdomain.com/cpanel
   • Enter your login credentials
2. Access phpMyAdmin
   • Scroll to the Databases section and click on phpMyAdmin
3. Select the Database to Export
   • In phpMyAdmin, find the database you want to export on the left panel and select it
4. Export the Database
   • Click on the Export tab at the top of the screen
   • Choose the Quick export method for a basic backup or Custom for advanced options
   • Select the file format (SQL is recommended)
   • Click Go to download the database to your computer

🛠 Step-by-Step: Importing a Database in cPanel

1. Log in to cPanel
   • Navigate to: yourdomain.com/cpanel
   • Enter your login credentials
2. Access phpMyAdmin
   • Scroll to the Databases section and click on phpMyAdmin
3. Select the Database to Import Into
   • In phpMyAdmin, select the database you want to import data into. If needed, create a new database by clicking on the Databases tab and entering a name
4. Import the Database
   • Click on the Import tab at the top
   • Click Choose File and select the database file you want to import (typically .sql or .sql.gz)
   • Click Go to begin the import process

💡 Pro Tips

• Backup First: Always back up your database before performing any import or export operation to avoid potential data loss.
• Large Files: If your database file is too large, consider using SSH or your host’s file management tools to import it.
• Check File Format: Ensure the file you’re importing is in the correct format, such as .sql, .sql.gz, or .zip

In need for further guidance, contact our 24/7 support team.