Dong Shin 01.10.2011

  • PPM Database Update Procedures with the script,  DBUpdateSQLs.sql
    • backup the database using following command from command line
      • mysqldump -d -u root -p project_portfolio > project_portfolio_backup.sql
    • login to database from command line at the directory where the DBUpdateSQLs.sql is located
      • mysql -u root -p
    • select database to modify at the mysql prompt
      • use project_portfolio;
    • run the script from the mysql prompt
      • source DBUpdateSQLs.sql;
    • if anything goes wrong, you can revert to old database by restoring the database from the backed up file
      • mysql -u root -p to get mysql prompt from command line
      • drop database project_portfolio; in mysql prompt
      • create database project_portfolio; in mysql prompt
      • source project_portfolio_backup.sql; in mysql prompt
  • PPM Changes
    • changing code to work with new DB structure….
    • 1 Year projects support added
    • complete database schema created, but not implemented on the current database