How to Upload Sql File to Wordpress

Import a WordPress Database

This article will comprehend how to import a database file into your WP Engine surround; accessing phpMyAdmin through our User Portal (our version of the cPanel), clearing out the electric current default database, and importing your database file. For this article you lot will need to already accept exported and saved your database file as a .sql on your local computer. If you do non have a database file all the same:

• Follow this article to export a database from another host
• Or, check out this article to get your database file from a WP Engine backup

If you are following forth on the Migration Checklist in the User Portal or need a little more data, this is the first task in the Import phase.

---

Access phpMyAdmin

At WP Engine we utilize the phpMyAdmin utility to allow our customers to easily view and access their database directly from the browser. With one click y'all can securely login and access the database from the User Portal.

1. Login to the User Portal
2. Select the surround proper name to wish to import the database to
3. Click phpMyAdmin at the tiptop

---

Select Database

Expand the database name where you'd like to import the new database content by clicking the database name on the left.

• The primary database for the environment will be titled: wp_environmentname
  • All Production, Staging, and Evolution environments volition use this naming convention.
• If you accept created a legacy staging site, you lot volition see a second database called:snapshot_environmentname
  • Only legacy staging uses this naming convention. If you're not sure, yous likely need to employ the wp_ database instead.

---

Drop Database Tables

Before importing your database you must create a make clean slate and brand room for your incoming database.

1. Click onCheck All
2. From the dropdown, select Drib
3. Click Go

4. Some other screen will display confirming the alter, click Yes

Typically all tables should be dropped before attempting a database import. These steps may demand to be performed several times, until no tables show and the interface reads "No tables found in database."

---

Import New Database

At present that the previous database has been cleared, we tin can import the new database file.

1. Click on the tab Import almost the top
2. Click on Choose File
3. Locate the new database file on your local system and select it
   • In many cases this file is called something like wp_environmentname.sql
4. ClickBecome

5. You volition at present see the new tables in the database, forth with a report stating that the import has been successfully finished.

If your site contains existing revisions, please contact our support team from your User Portal prior to migrating or importing your content to avoid a loss of data. WP Engine disables revisions by default and onetime revisions may be removed automatically.

Note

phpMyAdmin is limited to 50MB database imports. If you demand to import a larger database, skip down to the Failed Import department for further options.

---

Confirm Database Prefix

In one case you have successfully imported your database, you will need to check if your table prefixes are not default. A database using the default table prefix looks like the following. Annotation how each tabular array begins with: wp_

If your tables do non start with wp_, please read How to change the table prefix to ensure your site works properly on our organisation.

If your expected row count inside php MyAdmin doesn 't match what' s on display, it may be due to how the table 's data is handled within MySQL. To become more information on the desired table, run the post-obit commands from the SQL tab within PHPMyAdmin afterwards selecting a database:

View verbal count of rows for a tabular array:
SELECT COUNT(*) FROM wp_posts;
View information from PHPMyAdmin table condition:
Evidence Tabular array STATUS;

---

Failed Import

If your database import failed, in that location could be a few different reasons for this.

1. Your database is too large, the maximum database import size is 50M. This limit is manufacture standard and cannot be increased. At that place are three alternatives:
   • Upload the file to _wpeprivate using SFTP and achieve out to Support to have it imported.
   • Connect using SSH Gateway and import the database using WP CLI.
   • Export the database from the previous host as groups of fewer tables, rather than the whole database.
2. In that location was an event with the exported content.
   • Attempt the export again, but this time with just a few tables. If this works continue importing tables a scattering at a fourth dimension until an event is institute.
3. WP Engine runs daily maintenance processes that enforce limits on database options to preserve the stability of the site and the platform. Autoloaded rows (generally located within the wp_options tabular array) are express to 1MB of data per choice. Database rows that are not automatically loaded are express to 4MB of data per selection.

If your import failed, and you're unable to deduce why, please contact our support team at WP Engine Support. We are more than happy to help!

---

Adjacent Step: Import your wp-content directory

papederming.blogspot.com

Source: https://wpengine.com/support/importing-database/

Share this post