MySQL Forums
Forum List  »  Backup

hotbackup ALL databases
Posted by: Meni Milstein
Date: February 23, 2006 04:17PM

Hi.

I was wondering whether there is a way to use hotbackup in order to completely backup a server, without the need to specify every database manually.

So far, I have tried:
mysqlhotcopy -u=root -p=****** --regexp=a* --addtodest /hotcopy/
mysqlhotcopy -u=root -p=****** --regexp=b* --addtodest /hotcopy/
.....

But I fount it to work on several servers only. (didn't look into it but too much but i think that if you have more than one Database that starts with a certain Letter then this is worthless...)

Thanks for the help,
Meni Milstein

Options: ReplyQuote


Subject
Views
Written By
Posted
hotbackup ALL databases
3182
February 23, 2006 04:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.