Help with database / image backups

[satya1234]

Hi All,

Sorry if my two queries are very simple, but this topic has frustrated me a fair amt...

(1) Backing up database - I tried to take a backup of the database by clicking on "backup database" option. Prior to that, I specified a directory for backups as:

/usr/www/users/sacoins/photopost/backups

Then, based on Chuck's advice in a previous thread, I set directory permissions for above directory to 777. However, I still get this error message...

Command being used to execute dumps (specific tables are executed individually):

/usr/bin/mysqldump --opt -h db67a.pair.com -u**** -p**** ****

Results:

Warning: pp_categories.sql is 0 bytes or did not get created.

You should double-check your .sql files to be sure the backup completed successfully.

Can anyone kindly help??

(2) Backing up images - Is the only way to FTP back the "data" directory to some place periodically?

Many thanks in advance for your help!

[Chuck S]

1. You can not use the backup utility if your using an external mysql database. mysql needs to be on the same server to use that utility and yours is not.

2. That would depend on some external script or your sites backup features. I use a program called automysqlbackup.sh to backup my mysql databases daily weekly and monthly and then I usually backup my site through my control panel which tar zips my files and downloads it to my home computer

[satya1234]

Hi Chuck, many thanks for replying. I am trying to understand your 1) comment better...

I host my website at pair.com. Seems like server for my database is db67.pair.com, and photopost & scripts are located on diaf.pair.com... Are you saying this is what is causing the problem (i.e., database being on a different server)?

Since I am in a webhosting situation, I don't have flexibility of changing this... Is there any workaround or script that you / other members can suggest?? I'd really appreciate it...

Thanks again!

[satya1234]

My host Pair.com provides me a way to backup the database, that I was able to use... Hence didn't need to use the script provided by Photopost software...

Rgds,

Satya

[Chuck S]

Satya yes if your mysql is on another server you can not use the script to back things up.