Two questions about backing up your website (mysql and files) [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question may be able to be answered.

开发者_Go百科

Closed 9 years ago.

Improve this question

So the only method i like using and think is the simplest to use is mysqldump to backup mysql databases. Right now, im using phpmyadmin to backup the tables. Is there any way i can code a script that does it automatically (preferably everyday).

And how do i back up files exactly on my server. I have an images file that i need to back up. I'm not sure exactly how to go about backing those up.

---

Of course -- use MySQL Dumper. You can automatically backup your databases to another host if you like!

Features

• Send dumpfiles via FTP to up to 3 different server. This is also working using the multipart feature.
• Automatic file-deletion: set your own rules to delete old backups. Specify the number of backups you want to hold and let MySQLDumper automatically delete the older ones to save server webspace.
• MySQLDumper can do Multipart-Backups. That means: it can automatically split the dumpfile if it gets bigger than your chosen size. When you want to restore a backup and choose the wrong part - it doesn' matter: MySQLDumper will notice that and will get the correct startfile automatically.
• Security: MySQLDumper can generate a .htaccess-file to protect itself and all of your backup-files

---

Good reading resource for alternatives

• 10 Ways to Automatically & Manually Backup MySQL Database

---

Since Gary answered your first question, I'll answer your second.

For backing up the server:

I'm assuming you are talking about your web applications and the images contained in folders used by those applications. Source control will work for this. Set up a Subversion server or something like it.

http://subversion.tigris.org/

Hope this helps. Good luck.