edit-task

Task Description: {"PRB:":"DATA changed by stupidity"}

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;">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>