-
Notifications
You must be signed in to change notification settings - Fork 15
Home
To clear the db:
(at sql prompt):
drop database abstrackr;
create database abstrackr;
Now, to recreate and empty tables in the db:
websetup.py contains the table definitions. Just invoke:
paster setup-app development.ini
To export database to a .sql file:
mysqldump -u root -p abstrackr > dump.sql (you will be prompted for a password)
To import a database from a .sql file:
mysql -u root -p abstrackr < file.sql // (you'll be prompted for a password)
NOTES
On OS X, you need to use mysqld_safe, ie.,
/usr/local/mysql/bin/mysqld_safe
To activate virtual env on OS X, use
source bin/activate
Alternatively, just run commands from within the bin subdirectory. e.g.,
sudo env/bin/paster serve --reload development.ini
MySql note for myself:
select count() from Labels l left join Citations c on l.study_id=c.citation_id where l.review_id=XXX group by study_id having count()<2;