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...

HTML to Office Word header and footer generation

Here is an HTML to Office Word header and footer generation code Below: fwrite($oFile, <html xmlns="http://www.w3.org/TR/REC-html40" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word"> <head> <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> <title> </title> <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Print</w:View> <w:Zoom>100</w:Zoom> </w:WordDocument> </xml><![endif]--> <style> <!-- /* Style Definitions */ p.MsoHeader, li.MsoHeader, div.MsoHeader{ margin:0in; margin-top:.0001pt; mso-pagination:widow-orphan; tab-stops:center 3.0in right 6.0in; } p.MsoFooter, li.MsoFooter, div.MsoFooter{ margin:0in 0in 1in 0in; margin-bottom:.0001pt; mso-pagination:widow-orpha...

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"> ...