Page 1 of 1 1
Topic Options
#204549 - 2012-03-23 01:10 AM mysqldump script
Jimay3677 Offline
Fresh Scripter

Registered: 2010-02-17
Posts: 9
Loc: Australia
Hi everyone, I've been trying to get Backupassist to remotely execute commands on our servers using psexec.

I was using batch files but psexec would freeze at the end of the remote batch file so I turned to kix scripts instead which all work fine and don't hang psexec except for the mysqldump script

The script has lines for each database like this
Shell '"d:\MySQL\MySQL Server 5.5\bin\mysqldump.exe" -uroot -hhost -p"password" database > "D:\MySQL\backups\database.sql"'

If run locally or from a batch file this works but from the kix script I get an error saying it cannot find a table called >

Any idea's?

Thanks.

Top
#204550 - 2012-03-23 02:02 AM Re: mysqldump script [Re: Jimay3677]
Allen Administrator Offline
KiX Supporter
*****

Registered: 2003-04-19
Posts: 4562
Loc: USA
Try

 Code:
Shell '%comspec% /c "d:\MySQL\MySQL Server 5.5\bin\mysqldump.exe" -uroot -hhost -p"password" database > "D:\MySQL\backups\database.sql"'

Top
#204551 - 2012-03-23 02:53 AM Re: mysqldump script [Re: Allen]
Jimay3677 Offline
Fresh Scripter

Registered: 2010-02-17
Posts: 9
Loc: Australia
Thank you!
That worked

Top
Page 1 of 1 1


Moderator:  Jochen, Allen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Arend_, Mart 
Hop to:
Shout Box

Who's Online
0 registered and 793 anonymous users online.
Newest Members
M_Moore, BeeEm, min_seow, Audio, Hoschi
17883 Registered Users

Generated in 0.054 seconds in which 0.027 seconds were spent on a total of 13 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org