× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.