UBUNTU(MYSQL SERVER)

[reca]

Hi Sir Jllort,

i just want to verify in ubuntu mysql server is it running using the terminal??



Thanks and Regards.

[jllort]

Database okmdb seems is created. Should take a look into:

Code: Select all

use okmdb;
show tables;

To verify tables in database has been created.

[reca]

Hi Sir Jllort,

i try to open.. it means my table is okay.

thanks


mysql> use okmdb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

Code: Select all

mysql> show tables;
+----------------------------+
| Tables_in_okmdb            |
+----------------------------+
| JBPM_ACTION                |
| JBPM_BYTEARRAY             |
| JBPM_BYTEBLOCK             |
| JBPM_COMMENT               |
| JBPM_DECISIONCONDITIONS    |
| JBPM_DELEGATION            |
| JBPM_EVENT                 |
| JBPM_EXCEPTIONHANDLER      |
| JBPM_JOB                   |
| JBPM_LOG                   |
| JBPM_MODULEDEFINITION      |
| JBPM_MODULEINSTANCE        |
| JBPM_NODE                  |
| JBPM_POOLEDACTOR           |
| JBPM_PROCESSDEFINITION     |
| JBPM_PROCESSINSTANCE       |
| JBPM_RUNTIMEACTION         |
| JBPM_SWIMLANE              |
| JBPM_SWIMLANEINSTANCE      |
| JBPM_TASK                  |
| JBPM_TASKACTORPOOL         |
| JBPM_TASKCONTROLLER        |
| JBPM_TASKINSTANCE          |
| JBPM_TOKEN                 |
| JBPM_TOKENVARIABLEMAP      |
| JBPM_TRANSITION            |
| JBPM_VARIABLEACCESS        |
| JBPM_VARIABLEINSTANCE      |
| OKM_ACTIVITY               |
| OKM_AUTO_ACTION            |
| OKM_AUTO_ACTION_PARAMS     |
| OKM_AUTO_METADATA          |
| OKM_AUTO_RULE              |
| OKM_AUTO_VALIDATION        |
| OKM_AUTO_VALIDATION_PARAMS |
| OKM_BOOKMARK               |
| OKM_CONFIG                 |
| OKM_CRON_TAB               |
| OKM_CSS                    |
| OKM_DASHBOARD              |
| OKM_DASHBOARD_ACTIVITY     |
| OKM_DB_METADATA_SEQUENCE   |
| OKM_DB_METADATA_TYPE       |
| OKM_DB_METADATA_VALUE      |
| OKM_DROPBOX_TOKEN          |
| OKM_EXTENSION              |
| OKM_LANGUAGE               |
| OKM_MAIL_ACCOUNT           |
| OKM_MAIL_FILTER            |
| OKM_MAIL_FILTER_RULE       |
| OKM_MIME_TYPE              |
| OKM_MIME_TYPE_EXTENSION    |
| OKM_NODE_BASE              |
| OKM_NODE_CATEGORY          |
| OKM_NODE_DOCUMENT          |
| OKM_NODE_DOCUMENT_VERSION  |
| OKM_NODE_FOLDER            |
| OKM_NODE_KEYWORD           |
| OKM_NODE_MAIL              |
| OKM_NODE_MAIL_BCC          |
| OKM_NODE_MAIL_CC           |
| OKM_NODE_MAIL_REPLY        |
| OKM_NODE_MAIL_TO           |
| OKM_NODE_NOTE              |
| OKM_NODE_PROPERTY          |
| OKM_NODE_ROLE_PERMISSION   |
| OKM_NODE_SUBSCRIPTOR       |
| OKM_NODE_USER_PERMISSION   |
| OKM_OMR                    |
| OKM_OMR_PROPERTY           |
| OKM_PENDING_TASK           |
| OKM_PROFILE                |
| OKM_PROFILE_MSC_EXTENSION  |
| OKM_PROFILE_MSC_REPORT     |
| OKM_PROFILE_MSC_WORKFLOW   |
| OKM_PROFILE_WZRD_PROP_GRP  |
| OKM_PROFILE_WZRD_WORKFLOW  |
| OKM_QUERY_PARAMS           |
| OKM_QUERY_PARAMS_CATEGORY  |
| OKM_QUERY_PARAMS_KEYWORD   |
| OKM_QUERY_PARAMS_PROPERTY  |
| OKM_QUERY_PARAMS_SHARED    |
| OKM_REG_PROPERTY           |
| OKM_REG_PROPERTY_GROUP     |
| OKM_REPORT                 |
| OKM_ROLE                   |
| OKM_TRANSLATION            |
| OKM_TWITTER_ACCOUNT        |
| OKM_USER                   |
| OKM_USER_CONFIG            |
| OKM_USER_ITEMS             |
| OKM_USER_ROLE              |
| OKM_ZOHO_TOKEN             |
+----------------------------+
93 rows in set (0.00 sec)

mysql>

[jllort]

Seems is right. You can upload some document and see if appears into table OKM_NODE_BASE.
But I think is right.

[reca]

Thank you sir