backup database issue with multiple IIS accounts

Hi,

First off… let me say what a fantastic product you have developed. I originally messed around with osC for about 3 weeks and although I found it looks slightly better I found it was buggy as F***. I then switched to ZC and installed first go without any glitches. You have also more support for music related shops (which is great considering we are a well known record shop starting to venture into the world of online sales)


To the problem at hand...

Our hosting provider has a control panel that allows only 1 db per account... they told me that as a workaround I could make another account and have the database for ZC running from that account.

Everything seems to be working fine apart from when I try to make a backup of the database.

The error msg I get is basically saying it can’t write to X directory (which is a path to the account ZC is installed from not the path to the account the DB is running from) if this makes sense.


Is there any way I can change the path just for the database backup to point to the account which is running our database???

Thanks

D.

1. "how" are you performing this backup?
2. is the folder it's trying to write into set with read/write permissions for your "Internet Guest Account" ?

Hi DrByte,

Thanks for the reply.

I am using the backup Mysql option from the backup mysql module.

I have checked the directory in question and have tried giving read/ write access but nothing.

Here's the error msg I get when trying to run a backup. I am using a windows server. How would I go about altering permissions on cmd.exe to allow Special Access to the Internet Guest Account to read/execute.?

The backup failed because there was an error starting the backup program (mysqldump or mysqldump.exe).
If running on Windows 2003 server, you may need to alter permissions on cmd.exe to allow Special Access to the Internet Guest Account to read/execute.
You should talk to your webhost about why exec() commands are failing when attempting to run the mysqldump binary/program.

Thx

D.

It's been ages since I did that on cmd.exe ... but I suspect it's the same as for marking any other file read/write ...

• right-click the file
• go to Security properties
• find Internet Guest Account
• grant it Execute permissions

... or maybe hit the MS KB for additional ideas... ?

thanks m8, will have a look...

D.