Skip to main content

Conncecting the Processmaker MYSQL using Command Prompt(windows server)

/*
* Conncecting the Processmaker MYSQL using Command Prompt(windows server)
*/

C:\Bitnami\processmaker-3.1-1\mysql\bin>mysql -u root -p
Enter password: **
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 865
Server version: 5.5.53 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bitnami_pm         |
| mysql              |
| performance_schema |
| test               |
| wf_backup1         |
| wf_business        |
| wf_crm             |
| wf_finance         |
+--------------------+
9 rows in set (0.00 sec)

mysql> exit;
Bye

C:\Bitnami\processmaker-3.1-1\mysql\bin>mysqldump --user="root" --password="sa"
DB_NAME > DBNAME.SQL
mysqldump: Got error: 1049: Unknown database 'db_name' when selecting the databa
se

C:\Bitnami\processmaker-3.1-1\mysql\bin>mysqldump --user="root" --password="sa"
wf_crm > wf_crm.SQL

C:\Bitnami\processmaker-3.1-1\mysql\bin>mysqldump --user="root" --password="sa"
bitnami_pm > bitnami_pm.SQL

C:\Bitnami\processmaker-3.1-1\mysql\bin>mysqldump --verbose  --user="root" --pas
sword="sa" wf_finance > bitnami_pm.SQL
-- Connecting to localhost...
-- Disconnecting from localhost...

C:\Bitnami\processmaker-3.1-1\mysql\bin>mysqldump --verbose  --user="root" --pas
sword="sa" wf_finance < bitnami_pm.SQL
-- Connecting to localhost...
-- MySQL dump 10.13  Distrib 5.5.53, for Win32 (AMD64)
--
-- Host: localhost    Database: wf_finance
-- ------------------------------------------------------
-- Server version       5.5.53

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES UTF8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Disconnecting from localhost...
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017-06-14 13:16:07


Comments

Popular posts from this blog

vagrant up not working windows 10 | Stderr: VBoxManage.exe: error: Failed to get device handle and/or partition

 vagrant up not working windows 10 If you get an error message during  vagrant up  or when starting a VirtualBox machine, telling you that VT-x is not available, a reason may be that you have enabled Hyper-V on your Windows 10 machine: VirtualBox and Hyper-V cannot share the VT-x CPU: $ vagrant up Bringing machine 'default' up with 'virtualbox' provider... ==> default: Checking if box 'thesteve0/openshift-origin' is up to date... ==> default: Clearing any previously set network interfaces... ==> default: Preparing network interfaces based on configuration... default: Adapter 1: nat default: Adapter 2: hostonly ==> default: Forwarding ports... default: 8443 (guest) => 8443 (host) (adapter 1) default: 22 (guest) => 2222 (host) (adapter 1) ==> default: Running 'pre-boot' VM customizations... ==> default: Booting VM... There was an error while executing `VBoxManage`, a CLI used by Vagrant for controlling VirtualBox. The command an...

Extjs Dynamically Update Panel content html

To add html to an EXTJS panel after it has been rendered you can use. Ext.getCmp(''the I.D of your panel'').body.update(''your HTML"); new Ext.Panel({             border: false,             frame: false,             width: 200,             region: 'west',             id: 'panel-id',             bodyStyle: "background: #fff"         } //and I want in another module change panel content... so use this: Ext.getCmp('panel-id').body.update('html content for example'); Example 2: {     xtype: 'panel',     title: 'Testing',     id: 'taskpanel',     html: 'testing' } //to update the panel content. For html use body.update 3 Ways to render HTML inside of a ExtJS container Ext.onReady(function() {     new Ext.Panel({  ...

Add footer page number in Microsoft (Word) using PHP

Here is an example of adding a footer page number in a word document( .docx, .doc ) using PHP in ProcessMaker tool.  Sometimes we would like to add the footer connect via styles or tag attributes to enable the footer on pages.  View:          Below screen the output screen to display the custom footer with few lines of code Example: <table border="0" cellpadding="0" cellspacing="0" id="test" style="width: 100%;"> <tbody> <tr> <td> <!--footer starts--> <div id="f1" style="position: fixed; bottom: 5mm; left: 0mm; width: 100%; mso-element: footer;"> <table border="0" cellpadding="0" cellspacing="0" style="width: 100%;"> <tbody> <tr> <td class="footer"> ...