ARCHIVED: Migrate your Legacy MySQL-based WordPress site to New MySQL

This content has been archived, and is no longer maintained by Indiana University. Resources linked from this page may no longer be available or reliable.

Before proceeding with migration, read the following steps carefully.

If you are using a multi-site WordPress instance, you will not be able to use All-in-One Migration. If you want to back up your site, you will have to find a different plugin or do it manually.

  1. Back up your MySQL database. You can do this using the All-in-One WP Migration plugin or a similar service that provides backup functions.

    To install the All-in-One WP Migration plugin:

    1. In WordPress plugins, search for All-in-One Migration.
    2. Select install plugin.
    3. Activate the plugin. All-in-One WP Migration should now appear in your left tool bar; click it.
    4. Under the green "export to" section, select file. It will take a few moments for the backup to be created. This can take much longer depending on the size of your site.
    5. Select the blinking download site button and wait for it to download.
  2. Migrate your website as instructed in Migrate from Legacy to MySQL for Webserve service.
    After this step, your WP admin page will be inaccessible.
  3. After your migration is complete, you will need to edit your wp-config.php file:
    1. Choose an SFTP client such as WinSCP or Cyberduck.
    2. In the editing, you will need to change your DB_Name to yourGroupName_dbnameYouPreviouslyUsedforWP.
    3. Change your DB_USER to yourGroupName_PreviousDbUsername.
    4. Change your DB_HOST to (Test) or (Production).
    5. Save changes to the server.
  4. Test your site.

This is document apmh in the Knowledge Base.
Last modified on 2018-08-28 07:38:14.

Contact us

For help or to comment, email the UITS Support Center.