Run MYSQLDUMP with QP2SHELL

["Jack Tucky" <jacktucky@xxxxxxxxx>]

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.