14 Mar
2017
14 Mar
'17
4:44 p.m.
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(a)oma.be>
发送时间: 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