RE: Run MYSQLDUMP with QP2SHELL

["Jack Tucky" <jacktucky@xxxxxxxxx>]

Thanks Brian.

The STRQSH Command is the right way to do it.  Works great.

Jack

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of BMay@xxxxxxxxx
Sent: Wednesday, March 23, 2011 3:53 PM
To: Midrange Systems Technical Discussion
Subject: Re: Run MYSQLDUMP with QP2SHELL

At first glance I notice a couple of things.  First, you have your parms 
in the wrong order.  You have defined your first parm to be the database 
name and the second for your "-u" switch.  The user switch needs to come 
immediately after the command.  Secondly, on your CHGVAR for Parm3, you 
are populating it with Parm2 and NULL not Parm3 and NULL.

Just to simplify things for you, mysqldump will run just fine in QShell as 
well.  So the following CL statement should get the job done:

STRQSH CMD('mysqldump -u root SUGARCRM > 
/usr/local/mysql/bin/backup_SUGARCRM.sql')

HTH,

Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi



"Jack Tucky" <jacktucky@xxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/23/2011 02:37 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

Subject
Run MYSQLDUMP with QP2SHELL






I've never used QP2SHELL.  I'm able to successfully backup my MYSQL 
database
using QP2TERM with this command:

 

mysqldump -u root SUGARCRM > /usr/local/mysql/bin/backup_SUGARCRM.sql

 

I'm trying to get this to run with QP2SHELL.  I read that I need to
terminate my parms with *Null, I found examples on the IBM website.    My
CLP looks like this:

 

PGM 

             DCL        VAR(&CMD) TYPE(*CHAR) LEN(80) + 

                          VALUE('/usr/local/mysql/bin/mysqldump') 

             DCL        VAR(&PARM1) TYPE(*CHAR) LEN(65) + 

                          VALUE('SUGARCRM') 

             DCL        VAR(&PARM2) TYPE(*CHAR) LEN(65) + 

                          VALUE('-user root') 

             DCL        VAR(&PARM3) TYPE(*CHAR) LEN(65) + 

                          VALUE(' > + 

                          /usr/local/mysql/bin/backup_SUGARCRM.sql') 

             DCL        VAR(&NULL) TYPE(*CHAR) LEN(1) VALUE(X'00') 

 

             CHGVAR     VAR(&CMD) VALUE(&CMD *TCAT &NULL) 

             CHGVAR     VAR(&PARM1) VALUE(&PARM1 *TCAT &NULL) 

             CHGVAR     VAR(&PARM2) VALUE(&PARM2 *TCAT &NULL) 

             CHGVAR     VAR(&PARM3) VALUE(&PARM2 *TCAT &NULL) 

             CALL       PGM(QP2SHELL) PARM(&CMD &PARM1 &PARM2 &PARM3) 

 

ENDPROGRAM: ENDPGM 

 

My results are as follows.  I see that I'm not providing the user 
parameter
properly.  How can I run this?  For testing I have no password but I will
need to provide that parm as well.

 

TIA, Jack

 

 

-- Host: localhost    Database: SUGARCRM


-- ------------------------------------------------------


-- Server version       5.1.50


 


/*!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 */;


mysqldump: Got error: 1044: Access denied for user ''@'localhost' to
database

'sugarcrm' when selecting the database  

Press ENTER to end terminal session.