task

title

[previously]

  1. ] SOME IDIOT ran this query trying to update 2 records
  2. ] UPDATE articles set created = '2014-04-04 13:00:00' where id_article = 3056 OR 3059
  3. ] rESULT = 2641 row(s) affected. ( Query took 0.0476 sec ), DESTROYING our new ='nav by date' feature and losing an important part

[currently]

  1. [PLAN]
  2. ] import table articles from last backup
  3. ] add new records SET from current articles to last backup to
  4. ] DATE new records
  5. ] drop/rename original articles table ( DROP after backup copy created with both sets)
  6. ]

[next]

  1. x] backup is 1 file,
    1. compressed 7.5, decomp 36mb 
  2. x] import into db1616
    1. ** doesnt appear to be doing anything ***
    2. > Import has been successfully finished, 167,774 queries executed. (10 minutes, BUT no sigh
  3. x] EXPORT articles from db1616
    1. ] 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
    2. *] have to check the box to x] create file
  4. x] renamed orig .articles table to articles2
    1. x] using /Operations
    2. *] * ops to ] copy, ] move tables w/structure and data
  5. x] import articles from backup-export
    1. ] Import has been successfully finished, 172 queries executed.
  6. x] export articles from 'articles2' to file
    1. x] #16 articles added since backup created ( id > 3053)
  7. x]  import articles from file(=articles-new) into articles 
    1. x] succesfull, now at 2641,
  8. x] BACKDATE articles
    1. x] all articles dated 2014-04-04 (23)
    2. x] UPDATE articles SET created ='2014-05-10 13:00:00' WHERE id_article > 3054 (12)
    3. x] BACKDATE 04-02, ( 3056, 3059, 3065) 

 

 

 

  1. x] installed workbench local
  2. ] idea is to ...
  3. x] reverse engineer db from backup db file
  4. x] have db schema,
  5. ] has NO data
  6. ] no mysql installed on local machine,
  7. ] installed mysql

 

Details Photos Edit more

Details

ID: 3952

NAME: FIX-PRB-3952

DESCRIPTION: {"PRB:":"DATA changed by stupidity"}

START DATE TIME: 2014-04-22 13:04:14

EST DURATION: 01:00:00

END DATE TIME: 2014-04-22 14:04:14

STATUS: Completed

PRIORITY: -5

OWNER ID: 75

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities