backup: mysqldump or mysqlhotcopy ?

don't like to adapt my script regulary. Which tool do you recommend ? mysqldump or mysqlhotcopy ? Can i backup all databases with mysqlhotcopy using mysqlhotcopy --regexp=[a-zA-Z0-9]\+ ? Can i restore from this backup only some databases just copying the saved directories of the backuped

use mysqldump and mysqlhotcopy together?

Greetings, I've been looking at the backup/recover related discussions in the list archives for a while. Seems to me most people use either mysqldump or mysqlhotcopy. We don't have a good MySQL backup scheme in place yet. Now I have some questions based on my reading. How do I know how each

RE: use mysqldump and mysqlhotcopy together?

Hi, I'm a relative newbie at MySQL (Oracle DBA implementing MySQL in a production environment). There does seem to be a lack of 'Best Practice' documentation for MySQL in a production environment. I opted for using both mysqldump and mysqlhotcopy. Disk is cheap and everything is automated so

Re: use mysqldump and mysqlhotcopy together?

Bing Du wrote: Greetings, I've been looking at the backup/recover related discussions in the list archives for a while. Seems to me most people use either mysqldump or mysqlhotcopy. We don't have a good MySQL backup scheme in place yet. Now I have some questions based on my reading. We use

mysqldump or mysqlhotcopy?

Greetings, I would like to set up cron jobs on my servers to make backups of my databases: 1. The reference manual recommends mysqlhotcopy over mysqldump. Any opinions? 2. What format does mysqlhotcopy save in? sql files? csv? 3. Anyone else doing this with cron? I'd like to see