mysql - What is the best approach to use when upgrading a Database -


We have a system in which there is a MySQL database with 2Gigs of data.

Conversations for PC application databases have just been updated.

There are several tables whose structure has changed and we need to run a conversion script.

The system is used only at office hours

Question:

What is the best way to upgrade this?

  1. Wait until no one is using the system (because it's a one for you Option, I was planning to do it after hours).
  2. Database Backup
  3. Make sure to check your backup to do this
  4. Double-check backup
  5. Run the update script.
  6. Ensure that your daily backup work is still needed (usually there is no problem, but worth the energy to check).

Comments

Post a Comment