(public).sospep.events ~ view task ~ CREATE-article

<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] # 7135 - <a href="/view/task?id=7135" target="_blank">CREATE-article# #</a>&nbsp;</li>
</ol>
<li><strong>[00:00] NEW article IN&nbsp;</strong></li>
<ol>
<li>] # # - enviro migration - db ( db18 )&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 enviro, VS replacing db18)</li>
<li>x] "Server=MYSQL5005.SmarterASP.NET;Database=db_a19eea_enviro;Uid=a19eea_enviro;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>] # # - x] TRY import db IN USING latest back up of db_1, 2017-03-11</li>
<li>x] upload db FILE to cp,&nbsp;</li>
<li>x] unzip using cp unzip (had .sql dload)</li>
<li>x] 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;- Bad command found in your .sql file. You need (at least one of) the SUPER privilege(s) for this operation. Please remove it.</li>
</ol>
<li><strong>[18:30] NEW task IN FIX-PRB</strong></li>
<ol>
<li>x] 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>
</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>
<li><strong>[00:00] SITE enviro</strong></li>
<ol>
<li>] # # - web.config POINTS to server=basil, db=, user=dons2, pw=</li>
<li>] # # - EDIT server=smarter, db=db_###_enviro, user=###_enviro, pw= &nbsp;</li>
</ol></ol>

~ view task ~ TaskGroup] PROJECT-5545 FROM [ Plan] plan-projects IN [ calendars] prj-024-sospep-business