MySQL Databases

Migrating a MySQL Database from dbm1 to dbm2

[Nov 23, 2009 14:09] Web access to Microsoft Live@edu accounts now works.

Export the database on dbm1 to a local file on your workstation.

  • Login to phpMyAdmin on dbm1.itc.virginia.edu using your MySQL account name and password.
  • Select the database to export.
  • Select the Export option.
  • Check the Save as file option.
  • Click the Go button.
  • Your browser will display a window asking you what to do with the file. Select save and specify the name of the local file.

Import the database on dbm2 from the local file on your workstation.

  • Go to MySQL Self Service on dbm2.itc.virginia.edu.
  • If you do not have a MySQL account on dbm2 then selectCreate MySQL Account and create your account.
  • Select Create Database and create your database.
  • Select Administer Databases with phpMyAdmin. Log in with your MySQL account name and password.
  • Select your database.
  • Select the Import tab.
  • Under File to import -> Location of the text file, specify the local file on your workstation.
  • Under Format of imported files -> Options -> SQL compatibility mode, select MYSQL323.
  • Click the Go button.

Modify Your Web Site to Use the New Database

You will need to change the configuration of your web site (or any other software) to use your new database.

  • Change the MySQL server name from dbm1.itc.virginia.edu to dbm2.itc.virginia.edu.
  • Change the MySQL account name if it has changed.
  • Change the MySQL account password if it has changed.
  • Change the database name if it has changed.

Clean Up Old Databases on dbm1

When you no longer need the old database on dbm1, please clean it up.

  • Use phpMyAdmin on dbm1 to drop the database.
  • When you have dropped all of your databases on dbm1, please send email to systems@virginia.edu to let us know that you no longer need your MySQL account on dbm1.

© 2009 by the Rector and Visitors of the University of Virginia.

The information contained on the University of Virginia’s Department of Information Technology and Communication (ITC) website is provided as a public service with the understanding that ITC makes no representations or warranties, either expressed or implied, concerning the accuracy, completeness, reliability or suitability of the information, including warrantees of title, non-infringement of copyright or patent rights of others. These pages are expected to represent the University of Virginia community and the State of Virginia in a professional manner in accordance with the University of Virginia’s Computing Policies.