(public).sospep.systems ~ view step ~ LIST-outline-all

<h1 style="text-align: center;">LIST-outline-all</h1>
<h1 style="text-align: center;">migration-db</h1>
<h2>[previously]</h2>
<ol style="font-size: 10px; font-weight: normal; text-align: start;">
<li><strong>[2017-03-13][00:00] NEW task IN ?</strong></li>
<ol>
<li>i] # 7129 -&nbsp;<a href="/view/task?id=7129" target="_blank">CREATE-article# #</a>&nbsp;</li>
</ol>
<li><strong>[00:00] NEW article IN&nbsp;</strong></li>
<ol>
<li>] # # - dons migration - db ( db_1 )&nbsp;</li>
</ol></ol>
<h2>[currently]</h2>
<ol style="font-size: 10px; font-weight: normal; text-align: start;">
<li><strong>[00:00] NEW procedure(site-migration)</strong></li>
<ol>
<li><strong>] # # - db setup on new server</strong></li>
<li>] CP [db] tab -&nbsp;x] add new mysql db</li>
<li>] dbname = {'dons'}</li>
<li>*] @host(smarterasp.net) dbname is partially generated by system</li>
<li>x] add max 7 char suffix to name ( x] used dons, VS using db_1)</li>
<li>] "Server=MYSQL5005.SmarterASP.NET;Database=db_a19eea_dons;Uid=a19eea_dons;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>
<li>x] USING latest back up of db_1, 2017-03-11</li>
<li>x] upload to dir /db,&nbsp;</li>
<li>] unzip using control panel unzip (had .sql dload)</li>
<li>x] USING cp database function "restore db" to generate db via 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>
<li><strong>[00:00] NEW tasks&nbsp;</strong></li>
<ol>
<li>x] 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></ol>
<h2>[next]</h2>
<ol style="font-size: 10px; font-weight: normal; text-align: start;">
<li><strong>[00:00] NEW task</strong></li>
<ol>
<li>] # # - point dns servers to new domain name</li>
</ol></ol>

~ view step ~ Procedure] migration-site FROM [ App] management IN [ servers] prj-022-sospep