task

CREATE-article# #

[previously]

1. [2017-03-14][00:00] NEW task IN ?
1. i] # 7135 - CREATE-article# # 
2. [00:00] NEW article IN 
1. ] # # - enviro migration - db ( db18 ) 

[currently]

1. [00:00] NEW procedure(site-migration)
1. x] # # - [db] tab - add new - mysql db 
2. *] dbname is partially generated by system
3. x] add max 7 char suffix to dbname ( x] used enviro, VS replacing db18)
4. x] "Server=MYSQL5005.SmarterASP.NET;Database=db_a19eea_enviro;Uid=a19eea_enviro;Pwd=YOUR_DB_PASSWORD"
2. [00:00] NEW task 
1. ] # # - x] TRY import db IN USING latest back up of db_1, 2017-03-11
2. x] upload db FILE to cp, 
3. x] unzip using cp unzip (had .sql dload)
4. x] USING cp database function "restore db" to generate/populate new db from backup, 
5. *] job goes into Q, 
6. x] ERROR  - Bad command found in your .sql file. You need (at least one of) the SUPER privilege(s) for this operation. Please remove it.
3. [18:30] NEW task IN FIX-PRB
1. x] USE: phpadmin panel 
2. x] VERIFY: looks like db and records are there, has tables, views, articles records are there, tasks also
3. ] CHECK a closer look to see what is missing 

[next]

1. [00:00] NEW tasks 
1. ] EDIT web config IN sospep.org -  to point at NEW db here VS to old db at arvixe.com
2. [00:00] NEW task
1. ] ADD new db user: dbed, pw=pw, perms = select, insert, update, delete, 
2. *] USING db user auto created when creating db  (NOTE) that this user likely has full permissions, 
3. [00:00] NEW task
1. ] # # - point dns servers to new domain name
4. [00:00] SITE enviro
1. ] # # - web.config POINTS to server=basil, db=, user=dons2, pw=
2. ] # # - EDIT server=smarter, db=db_###_enviro, user=###_enviro, pw=  

Details

ID: 7135

NAME: CREATE-article

DESCRIPTION: enviro - migration DB -

START DATE TIME: 2017-03-14 18:00:28

EST DURATION: 01:00:00

END DATE TIME: 2017-03-14 19:00:28

STATUS: To-Do

PRIORITY: -5

OWNER ID: 1

photos

actions

Agenda Email task SMS task Priorities