[MSNoise] How to delete old records?

[hsy119 at mail.ustc.edu.cn]

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" <thomas.lecocq at oma.be>
> 发送时间: 2017-03-14 21:19:17 (星期二)
> 收件人: msnoise at 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 at 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 at mailman-as.oma.be
> > http://mailman-as.oma.be/mailman/listinfo/msnoise
> 
> _______________________________________________
> MSNoise mailing list
> MSNoise at mailman-as.oma.be
> http://mailman-as.oma.be/mailman/listinfo/msnoise