Page History

...

Now, Connect to reports database on test-msr.geant.net: 

Run the following commands:

       mysql Command: mysql -ureportsUser -p -htest-msr.geant.net reports     ### Password for "reportsUser" user is on LastPass. Shared with Erik and Mark.

truncate        truncate table reports.infinera_dna_outages;

LOAD        LOAD DATA LOCAL INFILE '/var/tmp/filename.csv' INTO TABLE reports.infinera_dna_outages FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 10 LINES;

...