Do you need to transfer your WordPress site from your old host to Nixihost? This guide will show you how.
Note: Be sure that the old WordPress install and the new one are the same version. If the versions do not match, the databases may not properly sync.
A. Back Up WordPress With phpMyAdmin
- Log in to phpMyAdmin.
- Select the WordPress database from the list.
- Select "Export" from the menu.
- Select "Quick", underneath "Export Method".
- Click "Go".
- When the backup is completed, you will be able to save the file. Click "Save As File" and you will download "wordpress.sql" to your desktop.
B. Download and Upload All Files
- Using your preferred FTP client, download the complete file structure of your old WordPress install - including the themes and plugins folders, or any folders not part of the default install but referred to in posts or pages.
C. Create A New Database & Edit wp-config.php
Create The New Database
- In cPanel, click "MySQL Databases".
- Create a new database.
- Create a user and password, and assign them to the new database.
- Grant the user "All Privileges".
- In cPanel, select the "File Manager" icon.
- Open the document root for the domain you're transferring to.
- Open the "wp-config.php" file. Edit these lines to match your database name, user name, password, and hostname.
/** The name of the database for WordPress */
/** MySQL database username */
/** MySQL database password */
/** MySQL hostname */
Your WordPress install now has an empty database.
D. Import WordPress
If your database if over 10mb, it may be best for you to use BigDump to import it. If not, you can do it via phpMyAdmin:
- When logged in to phpMyAdmin, select the blank database.
- Click "Import".
- Select the SQL backup file that you save to your computer in Part A.
- If you intend to skip a set number of code rows, you can use "Partial Import".
- Leave "Format" and "Format Specific Options" sections default.
- Click "Go".