[Pyromanci]

Ok, I have been trying to do this my self, but i guess my linux shell program isn't all that good.

Basicly what i am looking for is a simple linux script that goes through and runs a mysqldump on a configurable database and then repeats in 6 hours.

basicly our hosting providor says we have to maintian backups our selfs cuase they have around 300k customers each with 6+ database. We have 20 databases.

I have been looking for atleast a simple looping linux shell script but havn't been able to find one.

If any one can point me in the right direction or assist in correcting my current script that be great.

[wirehopper]

Use a cron job to run this type of command

mysqldump --host=SOURCE_SERVER -uSOURCE_USER -pSOURCE_PASS SOURCE_DB > databasedumpfile

You may want to add tar to reduce the dumpfile size.

If you don't have cron jobs, you may be able to use a different server or PC with wget to run a PHP script that executes the above.

Good luck

[Pyromanci]

The problem with that is our host only allows localhost server connection. Other wise i would have SQL Migration running to my local computer more then just ever 6 hours.

Aswell i do not have privs to setup a cron job of the hosting server.

Thats why i as goign to do it in the way linux shell scripts that loops through the commands then waits X amount of time before it repeated the loop.

I have done these sorta scripts before for MUD's, but this one just doesn't see to want to function with mysql.