[PHP] Automatic Backup MySQL database
$10-15 USD
Paid on delivery
Hello,
I need a programmer who can create a script for automatic backup and weekly from my MySQL database.
Currently, I use a small script that I run manually.
Here's the code:
<?php
echo "Votre base de données est en cours de sauvegarde.....<br /><br />";
system("mysqldump --host=server_sql --user=login --password=the_password > [url removed, login to view]");
echo "<b>Sauvegarde effectuée avec Succès !</b><br />";
echo "Vous pouvez récupérer le backup par FTP.";
?>
The script saves the database to the FTP site in the form: [url removed, login to view]
I like the script is executed automatically after 1 week (cron job) and it saves the database with the current date (date in French: DD-MM-YY).
For example:
01-03-10 - [url removed, login to view]
07-03-10 - [url removed, login to view]
14-03-10 - [url removed, login to view]
etc.
The goal is to have an archive of ALL backups from the beginning.
- Information -
Hosting:
SAS OVH
2, rue Kellermann
BP 80157
59100 Roubaix
FRANCE
My hosting package: [url removed, login to view]
--------------------------------
Thank you to apply only if you are sure to do so.
P.S. It took me 10 days to carry out this task to have time to test the automatic backup before confirming your good work.
## Deliverables
I insist: Automated backup of my database needs to be automatic. I do NOT have to start or take care of anything that the backup is done. I do not give you the passwords you create the code, you send me and I test.
Project ID: #3228286