Groups > Novell > MySQL with Novell > Re: mysqldump [not multiple]




mysqldump [not multiple]

mysqldump [not multiple]
Fri, 04 Aug 2006 22:07:35 GMT
Hi,
after installing NW6.5 SP5 (earlier I had SP4) and MySQL 4.1.21 (earlier 
  I had 4.1.19) my script that backs up databases does not work.
The script is very simple:
mysqldump --user=usr --password=xxx --opt --single-transaction 
--databases mysql > data:/mysql.sql
mysqldump --user=usr --password=xxx --opt --single-transaction 
--databases jbrokermq silvermaster50 > data:/silver.sql
mysqldump --user=usr --password=xxx --opt --single-transaction 
--databases expressportal > data:/express.sql
I used it for a long time, but now, after patching NetWare and MySQL it 
only backs up the first database. There are three processes of mysqldump 
spawned, but the second and the third one are immediately closed with 
[not multiple] message. How can I fix that?

Post Reply
Re: mysqldump [not multiple]
Sat, 05 Aug 2006 02:10:31 GMT
Hi Pawel,
"Pawel O." <pawos@poczta.onet.pl> wrote in
news:HyPAg.5440$P35.4205@prv-
forum2.provo.novell.com:

> Hi,
> after installing NW6.5 SP5 (earlier I had SP4) and MySQL 4.1.21 (earlier 
>   I had 4.1.19) my script that backs up databases does not work.
> The script is very simple:
> mysqldump --user=usr --password=xxx --opt --single-transaction 
> --databases mysql > data:/mysql.sql
> mysqldump --user=usr --password=xxx --opt --single-transaction 
> --databases jbrokermq silvermaster50 > data:/silver.sql
> mysqldump --user=usr --password=xxx --opt --single-transaction 
> --databases expressportal > data:/express.sql
> I used it for a long time, but now, after patching NetWare and MySQL it 
> only backs up the first database. There are three processes of mysqldump 
> spawned, but the second and the third one are immediately closed with 
> [not multiple] message. How can I fix that?
hard to say since you did two updates at same time;
I would go back to mysql 4.1.19 since that's done very quickly in order to 
nail down the prob...

Guenter.
Post Reply
Re: mysqldump [not multiple]
Sat, 05 Aug 2006 02:15:10 GMT
Hi Pawel,
"Pawel O." <pawos@poczta.onet.pl> wrote in
news:HyPAg.5440$P35.4205@prv-
forum2.provo.novell.com:

> Hi,
> after installing NW6.5 SP5 (earlier I had SP4) and MySQL 4.1.21 (earlier 
>   I had 4.1.19) my script that backs up databases does not work.
> The script is very simple:
> mysqldump --user=usr --password=xxx --opt --single-transaction 
> --databases mysql > data:/mysql.sql
> mysqldump --user=usr --password=xxx --opt --single-transaction 
> --databases jbrokermq silvermaster50 > data:/silver.sql
> mysqldump --user=usr --password=xxx --opt --single-transaction 
> --databases expressportal > data:/express.sql
> I used it for a long time, but now, after patching NetWare and MySQL it 
> only backs up the first database. There are three processes of mysqldump 
> spawned, but the second and the third one are immediately closed with 
> [not multiple] message. How can I fix that?
how do you start the script -  what is it? Do you use it already from bash, 
or is it just a NCF? if the later then I would suggest to use a bash 
shellscript...

Guenter.
Post Reply
Re: mysqldump [not multiple]
Sat, 05 Aug 2006 13:19:19 GMT
> 
> how do you start the script -  what is it? Do you use it already from bash,

> or is it just a NCF? if the later then I would suggest to use a bash 
> shellscript...
> 
Thx Guenter for hint. It was just a NCF, since I replaced it with a bash 
script, it's been running perfectly.

Post Reply
about | contact