(public).sospep.events ~ view task ~ FIX-PRB-3952

<h1 style="text-align: center;">title</h1>
<h2>[previously]</h2>
<ol>
<li>] SOME IDIOT ran this query trying to update 2 records</li>
<li>] UPDATE articles set created = '2014-04-04 13:00:00' where id_article = 3056 OR 3059</li>
<li>] rESULT = 2641 row(s) affected. ( Query took 0.0476 sec ), DESTROYING our new ='nav by date' feature and losing an important part</li>
</ol>
<h2>[currently]</h2>
<ol>
<li>[PLAN]</li>
<li>]&nbsp;import table articles from last backup</li>
<li>] add new records SET from current articles to last backup to</li>
<li>] DATE new records</li>
<li>] drop/rename original articles table ( DROP after backup copy created with both sets)</li>
<li>]</li>
</ol>
<h2>[next]</h2>
<ol>
<li><strong>x] backup is 1 file,</strong></li>
<ol>
<li>compressed 7.5, decomp&nbsp;36mb&nbsp;</li>
</ol>
<li><strong>x] import into db1616</strong></li>
<ol>
<li>** doesnt appear to be doing anything ***</li>
<li>&gt; Import has been successfully finished, 167,774 queries executed. (10 minutes, BUT no sigh</li>
</ol>
<li><strong>x] EXPORT articles from db1616</strong></li>
<ol>
<li>] simple puts the contents of the sql file into a window, copied and pasted it to local but its 7.5 mb file, clipboard and notepad are choking</li>
<li>*] have to check the box to x] create file</li>
</ol>
<li><strong>x] renamed&nbsp;orig&nbsp;.articles table to articles2</strong></li>
<ol>
<li>x] using /Operations</li>
<li>*] * ops to ] copy, ] move tables w/structure and data</li>
</ol>
<li><strong>x] import articles from backup-export</strong></li>
<ol>
<li>] Import has been successfully finished, 172 queries executed.</li>
</ol>
<li><strong>x] export articles from 'articles2' to file</strong></li>
<ol>
<li>x] #16 articles added since backup created ( id &gt; 3053)</li>
</ol>
<li><strong>x] &nbsp;import articles from file(=articles-new) into articles</strong>&nbsp;</li>
<ol>
<li>x] succesfull, now at 2641,</li>
</ol>
<li><strong>x] BACKDATE articles </strong></li>
<ol>
<li>x] all articles dated 2014-04-04 (23)</li>
<li>x] UPDATE articles SET created ='2014-05-10 13:00:00' WHERE id_article &gt; 3054 (12)</li>
<li>x] BACKDATE 04-02, ( 3056, 3059, 3065)&nbsp;</li>
</ol></ol>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<ol>
<li><strong>x] installed workbench local</strong></li>
<li>] idea is to ...</li>
<li><strong>x] reverse engineer db from backup db&nbsp;file</strong></li>
<li>x] have db schema,</li>
<li>]&nbsp;has NO data</li>
<li>] no mysql installed on local machine,</li>
<li>] installed mysql</li>
</ol>
<p>&nbsp;</p>

~ view task ~ TaskGroup] PRODUCTION FROM [ Plan] doc-projects IN [ calendars] prj-022-sospep