Re: [MSNoise] How to delete old records? - MSNoise - KSB-ORB Mailing Lists

14 Mar 2017

Hi, Thomas

Thank you for advice. 
I'll try MySQL workbench, or maybe just use mysql command line to clear my old
database.

Best wishes,

Shuye

...
  -----原始邮件-----
 发件人: "Thomas Lecocq" &lt;thomas.lecocq(a)oma.be&gt;
 发送时间: 2017-03-14 21:19:17 (星期二)
 收件人: msnoise(a)mailman-as.oma.be
 抄送: 
 主题: Re: [MSNoise] How to delete old records?

 Hi,

 Usually, you would create 1 database per "project" and either
"delete" 
 it or "empty" it at least, so when you run "msnoise install"
it'd 
 restart from scratch (creating empty tables etc).

 If you don't have many data_availability or jobs, you can delete them 
 from the admin interface. If you have lots, then you can delete them by 
 using MySQL workbench (if you use MySQL) or SQLManager (sqlite) to empty 
 the tables manually.

 Best regards,

 Thomas

 Le 14/03/2017 à 14:13, hsy119(a)mail.ustc.edu.cn a écrit :
  Dear everyone,

 I used to use MSnoise to do some calculation, and the work is done. Now I want to do
something new, but meet a problem

 After using 'msnoise populate' and 'msnoise sacan_archive --init' to
import new data, I found the 'data availability' and 'job' record in
database(in admin web-interface) still have old records, but I don't need them! And I
worry about if old ones wound disturb my new jobs.

 How can I delete old record in 'data availability' and 'job'? I
don't want to do it manually cause it's a realy a lot.

 Thanks for help！

 Shuye Huang
 _______________________________________________
 MSNoise mailing list
 MSNoise(a)mailman-as.oma.be
 http://mailman-as.oma.be/mailman/listinfo/msnoise

 _______________________________________________
 MSNoise mailing list
 MSNoise(a)mailman-as.oma.be
 http://mailman-as.oma.be/mailman/listinfo/msnoise