I'm trying to write a cron job to back up my databases. The manual says:
> Do a full backup of your databases:
>
> shell> mysqldump --tab=/path/to/some/dir --opt --full
>
> You can also simply copy all table files (`*.frm', `*.MYD' and`*.MYI'
> files), as long as the server isn't updating anything.The script
> mysqlhotcopy does use this method.
My question is, is it safe to use "mysqldump" to back up the database when
updates are occuring?
If not, how do I use mysqlhotcopy to back up every database, without
having to keep track of what the names of my databases are? The perldoc
for mysqlhotcopy shows that it needs a database name.
-Philip Mak ([EMAIL PROTECTED])
---------------------------------------------------------------------
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