task

CREATE-article# #

[previously]

  1. [2017-03-14][00:00] NEW task IN ?
    1. i] # 7138 - CREATE-article# # 
  2. [00:00] NEW article IN 
    1. ] # # - giants migration - db ( db5 ) 

[currently]

  1. [00:00] NEW procedure(site-migration)
    1. x] # # - [db] tab - add new - mysql db 
    2. *] dbname is partially generated by system
    3. x] add max 7 char suffix to dbname ( x] used forest, VS replacing db4)
    4. x] "Server=MYSQL5005.SmarterASP.NET;Database=db_a19eea_giants;Uid=a19eea_giants;Pwd=YOUR_DB_PASSWORD"
  2. [00:00] NEW task 
    1. ] # # -  
    2. x] TRY using phpadmin cp / import / .sql.zip - 1 error reported but looks successfull
    3. ] upload db FILE to cp, 
    4. ] unzip using cp unzip (had .sql dload)
    5. ] USING cp database function "restore db" to generate/populate new db from backup, 
    6. *] job goes into Q, 
    7. x] ERROR  - see migration.txt file for details, ERROR re:permissions on view booksINChapter
  3. [18:30] NEW task IN FIX-PRB
    1. ] USE: phpadmin panel 
    2. x] VERIFY: looks like db and records are there, has tables, views, articles records are there, tasks also
    3. ] CHECK a closer look to see what is missing 

[next]

  1. [00:00] NEW tasks 
    1. ] EDIT web config IN sospep.org -  to point at NEW db here VS to old db at arvixe.com
    2. ] EDIT web config IN sospep.com - 
  2. [00:00] NEW task
    1. ] ADD new db user: dbed, pw=pw, perms = select, insert, update, delete, 
    2. *] USING db user auto created when creating db  (NOTE) that this user likely has full permissions, 
  3. [00:00] NEW task
    1. ] # # - point dns servers to new domain name
Details Photos Edit more

Details

ID: 7138

NAME: CREATE-article

DESCRIPTION: giants - migration DB -

START DATE TIME: 2017-03-15 18:00:28

EST DURATION: 01:00:00

END DATE TIME: 2017-03-15 19:00:28

STATUS: To-Do

PRIORITY: -5

OWNER ID: 1

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities