autobackup ?

clogfan

Is there a possibility to schedule an automatic backup of the mysql database, and have it sent to some emailaddress once a month ?

How should I do this ?

Thanks in advance for your help !

Rhysige

Step 1/ Design a PHP script that will backup your databases into a file.
Step 2/ Add a mail function to the end
Step 3/ Add the running of this script to a Cron Job

Daniel15

I suggest you don't do this though, as it puts a huge load on the server.

Instead, just log in to DirectAdmin once a month and make a backup yourself Wink

clogfan

Why is there such a load in the case of php ?
If I create a backup once a month, isn't this the same in both solutions (php or myadmin) ? What's the difference then ?

phx777

i dont think backuing up a small database and emailing it once per 24h will put a "huge" load on the server really Razz

the only problem is with which email client to use, since we dont know whats installed.... (or at least i dont, sendmail and another one i tried kinda didnt work for me)