I don't know how big your tables are, and if you can withstand any
downtime. Because we're using MyISAM tables, we use mysqlhotcopy,
which locks the database as it copies the tables to another location.
Once that's been done you can rely on your filesystem backup to keep
copies of the data files but know that they'll be a point-in-time
snapshot.
We also use mysqldump, which works for all table types and can do the
job if your tables aren't too large. Again, if you dump your tables
to another folder/disk, the fs backup is a good way to keep copies of
that data.
Mike
On Jun 25, 2005, at 1:32 AM, James Tu wrote:
What have people done in the past regarding backup strategies?
Is it adequate enough to rely on filesystem backups for mysql?
Basically
such that we can restore MySQL to the last filesystem backup. Is
there a
reason not to do this?
I don't have any mission critical data and data that is lost since
the last
backup is acceptable.
-James
Mike Kruckenberg
[EMAIL PROTECTED]
"ProMySQL" Author
http://www.amazon.com/exec/obidos/ASIN/159059505X
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
