How To Export And Import A WordPress Database

Are you switching web hosting providers?

Are you switching domain names?

Whatever the reason may be, I am going to show you exactly how to export your wordpress database, change your domain name (if needed) and import to your web server.

Let’s get started.

1. Exporting Your WordPress Database

To begin the exporting process, you will need to sign into your web hosting account and go to your phpMyAdmin. Then, you will need to click on the database you want to export. If you have more than 1 database, you’ll have to select it from a drop down menu.

To click on the database, see pic below, the database is highlighted red.

After you have clicked/selected your database, you should see the name of your database at the top and click on the Export tab.

To see the database name and export tab, see the highlighted areas on the pic below.

After you have clicked on the Export tab, your screen should look like the pic below. This is the most important part, make sure you check the “Add DROP TABLE“, “Save as file” checkboxes and click the “Go” button.

When you have clicked on the Go button, a new window will open, make sure you save it as a file.

That’s it! You have successfully exported your wordpress database.

2. Changing the URLS in your Database

When changing your URL in your SQL Database, make sure you use a text editor, or your database will be corrupt. You should always make a copy of your database, in case something does go wrong. You can use Wordpad or TextPad as a text editor. Don’t worry, TextPad, is FREE.

Open your text editor or TextPad, select the Search and then the Replace option. Next, enter, and then, click “Replace All“.

If you are not sure, then refer to the pic below:

3. Importing Your WordPress Database

To import your database, you will need to go back into your phpMyAdmin, and select the database you want to import to. After you have clicked on the database, you will need to click on the “Import” tab at the top.

If you are not sure, then refer to the pic below:

Now, you will have to click on the “Browse” button and go to where your database .SQL file is saved. Once you have located your database .SQL file, you can click on “Go” and upload it.

If you are not sure, then refer to the pic below:

Moreover, uploading your database could take several minutes, depending on the size of your .SQL file.

When your database has successfully uploaded, you will see the wordpress details on the left of your phpMyAdmin and a message of queries executed.

The message will look like this:

That’s it!

You’re done!

Powered by WordPress and created by Rich Hamilton, Jr.