20140224

How to login to the IEDB-sever

mysql --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p

username: rdamle
password: iedb123

use table: Table4_20140226  as the updated table 4

mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed pubmed_information > pubmed_information.sql 

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed t4_tokenized_pubmed_information > t4_tokenized_pubmed_information.sql

mysql> show tables;
+---------------------------------+
| Tables_in_pubmed                |
+---------------------------------+
| pubmed_information              |
| t4_tokenized_pubmed_information |
| table4_reference                |
| table4_reference_latest         |
| table_4_reference_last_updated  |
| temp_pubmed_data                |
| temp_stemmed_for_svm            |
+---------------------------------+
7 rows in set (0.00 sec)

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed table4_reference > table4_reference.sql 

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed table4_reference_latest > table4_reference_latest.sql 

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed table_4_reference_last_updated > table_4_reference_last_updated.sql   

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed temp_pubmed_data > temp_pubmed_data.sql   

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed temp_stemmed_for_svm > temp_stemmed_for_svm.sql