Backing up…

[Cleo]

Originally posted by amber438
path_to_MYDATA.sql is the path to the sql database you are backing up, correct? (never did a cron thing before..)

No, that is the empty file that you created and then did a dump to or the file that you uploaded from your local backup that you kept in case your server took a shit.

So if your path to your web folder looks something like this, /home/cleo/web and you put your backup in your home folder the it would be /home/cleo/MYDATA.sql

There is no path involved with MySQL, just a call to it on your server.

On my server I have each of my databases do a dump at something like 3am into a file named after the day of the week. I then download these files to my local machine once a week. At most I would loose a few days of data if my server's drive died.