Archive Trac dn airavata mysql dump

Dn Airavata Mysql Dump

Legacy Trac archive page imported from dn_airavata_mysql_dump. Source: https://genapp.rocks/wiki/wiki/dn_airavata_mysql_dump. Review age, links, and examples before treating as current.

dump airavata's mysql database

• create dump_airavata.sql containing :

use airavata;

select * from ADVANCE_INPUT_DATA_HANDLING;
select * from ADVANCE_OUTPUT_DATA_HANDLING;
select * from APPLICATION_INPUT;
select * from APPLICATION_OUTPUT;
select * from COMMUNITY_USER;
select * from COMPUTATIONAL_RESOURCE_SCHEDULING;
select * from CONFIGURATION;
select * from CONFIG_DATA;
select * from CREDENTIALS;
select * from DATA_TRANSFER_DETAIL;
select * from ERROR_DETAIL;
select * from EXPERIMENT;
select * from EXPERIMENT_INPUT;
select * from EXPERIMENT_OUTPUT;
select * from GATEWAY;
select * from GATEWAY_WORKER;
select * from JOB_DETAIL;
select * from NODE_INPUT;
select * from NODE_OUTPUT;
select * from NOTIFICATION_EMAIL;
select * from OPENJPA_SEQUENCE_TABLE;
select * from PROJECT;
select * from PROJECT_USER;
select * from QOS_PARAM;
select * from QOS_PARAMS;
select * from STATUS;
select * from TASK_DETAIL;
select * from USERS;
select * from WORKFLOW_NODE_DETAIL;

use appcatalog;

select * from APPLICATION_DEPLOYMENT;
select * from APPLICATION_INPUT;
select * from APPLICATION_INTERFACE;
select * from APPLICATION_MODULE;
select * from APPLICATION_OUTPUT;
select * from APP_ENVIRONMENT;
select * from APP_MODULE_MAPPING;
select * from BATCH_QUEUE;
select * from COMPUTE_RESOURCE;
select * from COMPUTE_RESOURCE_FILE_SYSTEM;
select * from COMPUTE_RESOURCE_PREFERENCE;
select * from CONFIGURATION;
select * from DATA_MOVEMENT_INTERFACE;
select * from GATEWAY_PROFILE;
select * from GLOBUS_GK_ENDPOINT;
select * from GLOBUS_SUBMISSION;
select * from GRIDFTP_DATA_MOVEMENT;
select * from GRIDFTP_ENDPOINT;
select * from GSISSH_EXPORT;
select * from GSISSH_POSTJOBCOMMAND;
select * from GSISSH_PREJOBCOMMAND;
select * from GSISSH_SUBMISSION;
select * from HOST_ALIAS;
select * from HOST_IPADDRESS;
select * from JOB_MANAGER_COMMAND;
select * from JOB_SUBMISSION_INTERFACE;
select * from LIBRARY_APEND_PATH;
select * from LIBRARY_PREPAND_PATH;
select * from LOCAL_DATA_MOVEMENT;
select * from LOCAL_SUBMISSION;
select * from MODULE_LOAD_CMD;
select * from POSTJOB_COMMAND;
select * from PREJOB_COMMAND;
select * from RESOURCE_JOB_MANAGER;
select * from SCP_DATA_MOVEMENT;
select * from SSH_JOB_SUBMISSION;
select * from UNICORE_DATAMOVEMENT;
select * from UNICORE_SUBMISSION;
select * from WORKFLOW;
select * from WORKFLOW_INPUT;
select * from WORKFLOW_OUTPUT;

  $ mysql < dump_airavata.sql > output.txt

just dump schema

  mysqldump --no-data airavata > schema_airavata.txt
  mysqldump --no-data appcatalog > schema_appcatalog.txt