List:General Discussion« Previous MessageNext Message »
From:Bernd Lentes Date:April 22 2010 9:22am
Subject:backup: mysqldump or mysqlhotcopy ?
View as plain text  

i'm new to MySQL, so i have currently some basic questions.

I have a MySQL-Server with 15 users. Every User can create databases. I expect that the
amount of data which has to be backuped will increase constantly. What i want:
I'd like to have a backup on a regular basis. I think i will create two cronjobs, one
running daily, the other running weekly.
Initially, we will have just MyISAM tables, later on maybe InnoDB tables.
I'd like to backup _all_ databases, but having the possibility to restore only some
databases. And the number and names of the databases change often, but i 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 databases to the MySQL-directory ? 

Thanks in advance.


Bernd Lentes
Institut für Entwicklungsgenetik
HelmholtzZentrum münchen
phone: +49 89 3187 1241
fax:   +49 89 3187 3826
Im Kampf um das Unerreichbare verliert das
Erreichte seinen Wert
backup: mysqldump or mysqlhotcopy ?Bernd Lentes22 Apr