backup: mysqldump or mysqlhotcopy ?

2010-04-22 Thread Lentes, Bernd 
hello,

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



--
Bernd Lentes
Systemadministration
Institut für Entwicklungsgenetik
HelmholtzZentrum münchen
bernd.len...@helmholtz-muenchen.de
phone: +49 89 3187 1241
fax:   +49 89 3187 3826
http://www.helmholtz-muenchen.de/idg
Im Kampf um das Unerreichbare verliert das
Erreichte seinen Wert
 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

mysqldump or mysqlhotcopy?

2003-01-27 Thread Nicole Lallande 
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 a sample command.

TIA & Best regards,

Nicole




-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php