Migrate your Legacy MySQL-based Wordpress site to New MySQL

Note:
Support for the Legacy MySQL for Webserve environment is ending May 31, 2018. If you have a Legacy MySQL account, you should migrate your service to the New MySQL for Webserve environment before that date. For more, see Migrate from Legacy to New MySQL for Webserve service.
Note:
Before proceeding with migration, read the following steps carefully.
  1. Backup 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 download site and wait for it to download.
  2. Migrate your website as instructed in Migrate from Legacy to New MySQL for Webserve service.
    Note:
    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 folder:
    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 mysql-test.uits.iu.edu:3306 (Test) or mysql.uits.iu.edu:3306 (Production).
    5. Save changes to the server.
  4. Test your site.

This is document apmh in the Knowledge Base.
Last modified on 2018-04-11 08:01:44.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.