edit-task

Task Description: giants - migration DB -

Start Date:

Start Time:

Duration:

Priority:

Status: To Do Completed In Process

Add Photo:

Owner ID:

Content: use HTML Edit Content <h1 style="text-align: center;">CREATE-article# #</h1> <h2>[previously]</h2> <ol> <li><strong>[2017-03-14][00:00] NEW task IN ?</strong></li> <ol> <li>i] # 7138 - <a href="/view/task?id=7138" target="_blank">CREATE-article# #</a>&nbsp;</li> </ol> <li><strong>[00:00] NEW article IN&nbsp;</strong></li> <ol> <li>] # # - giants migration - db ( db5 )&nbsp;</li> </ol></ol> <h2>[currently]</h2> <ol> <li><strong>[00:00] NEW procedure(site-migration)</strong></li> <ol> <li>x] # # - [db] tab - add new - mysql db&nbsp;</li> <li>*] dbname is partially generated by system</li> <li>x] add max 7 char suffix to dbname ( x] used forest, VS replacing db4)</li> <li>x] "Server=MYSQL5005.SmarterASP.NET;Database=db_a19eea_giants;Uid=a19eea_giants;Pwd=<span style="color: #333333; font-family: monaco, courier, monospace; font-size: 13px; box-sizing: border-box; font-weight: bold;"><span style="box-sizing: border-box; color: red;">YOUR_DB_PASSWORD</span></span><span style="background-color: #dedede; color: #333333; font-family: monaco, courier, monospace; font-size: 13px;">"</span></li> </ol> <li><strong>[00:00] NEW task&nbsp;</strong></li> <ol> <li>] # # - &nbsp;</li> <li>x] TRY using phpadmin cp / import / .sql.zip - 1 error reported but looks successfull</li> <li>] upload db FILE to cp,&nbsp;</li> <li>] unzip using cp unzip (had .sql dload)</li> <li>] USING cp database function "restore db" to generate/populate new db from backup,&nbsp;</li> <li>*] job goes into Q,&nbsp;</li> <li>x] ERROR &nbsp;- see migration.txt file for details, ERROR re:permissions on view booksINChapter</li> </ol> <li><strong>[18:30] NEW task IN FIX-PRB</strong></li> <ol> <li>] USE: phpadmin panel&nbsp;</li> <li>x] VERIFY: looks like db and records are there, has tables, views, articles records are there, tasks also</li> <li>] CHECK a closer look to see what is missing&nbsp;</li> </ol></ol> <h2>[next]</h2> <ol> <li><strong>[00:00] NEW tasks&nbsp;</strong></li> <ol> <li>] EDIT web config IN sospep.org - &nbsp;to point at NEW db here VS to old db at arvixe.com</li> <li>] EDIT web config IN sospep.com -&nbsp;</li> </ol> <li><strong>[00:00] NEW task</strong></li> <ol> <li>] ADD new db user: dbed, pw=pw, perms = select, insert, update, delete,&nbsp;</li> <li>*] USING db user auto created when creating db &nbsp;(NOTE) that this user likely has full permissions,&nbsp;</li> </ol> <li><strong>[00:00] NEW task</strong></li> <ol> <li>] # # - point dns servers to new domain name</li> </ol></ol>