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

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

photos

actions

Agenda Email task SMS task Priorities