Import SQL files into MySQL databases

Generic selectors
Exact matches only
Search in title
Search in content
Filter by Categories
Account Management Help
add photos, video and audio
Add-on features and social media
Advanced
Advanced campaign settings
All about analytics
All about images
Basic steps
Configure the Web Application Firewall (WAF)
Connect my Calendar and Online Storage to Workspace
contact support
copy files to my site
Create my email address
Customize campaign
Discover domains
discover linux hosting with cPanel
Discover Microsoft 365
Discover Online Storage
Discover Workspace Email
edit content
Email Marketing demo
expand your site with sections and pages
Explore email add-ons
Explore my account
Find server and port settings (IMAP/POP)
fine tune my website
get social
Get started with SSL certificates
Get the most out of Microsoft 365
help my site get found and monitor my metrics
Hosting & Servers
How to use WordPress
keep my account secure
Keep my email secure
know your privacy rights
Legacy
Manage your SSL certificate
Managed WordPress
Manual email configuration
Migrate and export my emails
My email account isn’t working (troubleshooting)
nameservers and DNS
organize
parking, forwarding and monetizing
privacy and protection
publish my site
Quick Shopping Cart
Renew my products and services
renewals
Security
Sell products and raise money (Online Store Builder)
Set up a campaign
Set up email on my devices
set up my payment methods
Set up my Workspace Email account
start with the basics
Stay productive anywhere with Office apps
Streamline email tasks to help my business
The WordPress LAB
transfer between accounts
transfer between registrars
Troubleshoot email and email setup
Troubleshooting
troubleshooting
Uncategorized
Upgrade and renewal options for email
Web & Classic Hosting
Website backups
Website Builder 7
Website Builder version 6
Website Security and Backups
Websites
work with databases
work with delegates
working with blogs

If you backed up or exported a database to a SQL file, you can import it into one of your hosting account’s MySQL databases through phpMyAdmin.

 Note: You do not need to include the CREATE DATABASE line in your MySQL database. If you do include it, your import might fail. We recommend removing the line before importing your database. The phpMyAdmin interface only lets you import 8MB of data at one time. If you need to import more than 8MB, we recommend breaking up the file into 8MB pieces.

Warning: If you are importing a database for Managed WordPress, you must make additional changes to your SQL file for your site to work properly.

To Import SQL Files into MySQL Databases Using phpMyAdmin

  1. Access your database via PHPMyAdmin (cPanel / Plesk / Managed WordPress).
  2. On the left, click the database you want to use.
  3. Select the Import tab.
  4. Click Browse, locate the SQL file on your computer, click Open, and then click Go.

This runs the SQL file and updates the database as specified in your SQL file. It might take several minutes to restore the database.

 Note: If you receive an error message stating “Script timeout passed, if you want to finish import, please resubmit same file and import will resume” you can immediately select the same file to import and continue the restore where it left off.

After the database restores, make sure your connection strings are up to date. For more information, see Update WordPress database connection string.

Changing the currency for the products.

Prices shown in US Dollars. You can convert to your own currency after selecting a product.