Topic: Backing up mysql databases

[msilkjr]

I have 2 mysql databases that I need to back up, How do I do that.

[ergozd]

Hi!

You can try

Code: [Select]

mysqldump -c YOURDBNAME > /path/yourdbname.sql

if it was horde you want to backup to your /opt/backups/

Code: [Select]

mysqldump -c horde > /opt/backups/horde.sql

OR even better, if you want to put a date

Code: [Select]

date=date -I
mysqldump -c horde > /opt/backups/horde-$date.sql

Best rgds, Ergin

[Damian]

To automate it have a look at http://sourceforge.net/projects/automysqlbackup/

Damian

[Garfield]

Just yesterday I installed Michel van Hees's Crontab Manager in order to create some cron jobs to perform the backups.
The backups themselves can be done via very simple sql statements from within a script.

http://www.vanhees.cc/modules.php?op=modload&name=Downloads&file=index&req=viewsdownload

[jeroenm]

Or you could do it the sme way:
- /etc/e-smith/events/actions/mysql-delete-dumped-tables
- /etc/e-smith/events/actions/mysql-dump-tables
the full dump is located in: /home/e-smith/db/mysql