Forums
This topic is locked
MySQL Backup
Posted 23 May 2003 11:07:29
1
has voted
23 May 2003 11:07:29 Julio Taylor posted:
Does anyone know of a good, free and reliable tool that does automatic schedules backups of MySQL databases? I found MySQL Watch, but it's a paid program and i have no will to pay any money for anything at the moment.... :Sare there any opensource tools out there? or maybe some other solution?
thanks!
------------------------
Julio
PHP | MySQL | DWMX
ICQ: 19735247
MSN:
Replies
Replied 23 May 2003 12:35:19
23 May 2003 12:35:19 Allan Kent replied:
two options that come with mysql:
1. use the mysqldump program to dump your database to a SQL script, or better,
2. use the mysqlhotcopy script to backup the database. it's a perl script, so you'll have to have perl and the DBI package installed
you can use cron to call the script periodically.
allan
1. use the mysqldump program to dump your database to a SQL script, or better,
2. use the mysqlhotcopy script to backup the database. it's a perl script, so you'll have to have perl and the DBI package installed
you can use cron to call the script periodically.
allan
Replied 23 May 2003 21:20:55
23 May 2003 21:20:55 le xu replied:
<img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle><img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle><img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>