Comment 2 for bug 784414

Revision history for this message
Jimmy (jimmyattime) wrote :

in case someone else needs to remove graphs from sqlite and is new to sqlite:

1) # sqlite3 /opt/graphite/storage/graphite.db
2) To see tables

sqlite> .databases
seq name file
--- --------------- ----------------------------------------------------------
0 main /opt/graphite/storage/graphite.db
sqlite> .tables
account_mygraph auth_user
account_profile auth_user_groups
account_variable auth_user_user_permissions
account_view dashboard_dashboard
account_window dashboard_dashboard_owners
auth_group django_admin_log
auth_group_permissions django_content_type
auth_message django_session
auth_permission

3) to see URLs

sqlite> select * from account_mygraph;

4) to delete graphs

sqlite> delete from account_mygraph where name = '<graph_name>';