Am 23.12.2011 21:14, schrieb Jim McNeely:
> Hello all, happy holidays!
> What is the best way to run a mysqldump to get the tables, the data, the triggers,
> the views, the procedures, the privileges and users, everything? It seems confusing in the
> online documentation, or is that just me?
echo "Prepare im laufenden Betrieb"
rsync --times --perms --owner --group --recursive --delete-after /mysql_data/
/sbin/service mysqld stop
rm -f /Volumes/dune/mysql_data/bin*
rsync --progress --times --perms --owner --group --recursive --delete-after /mysql_data/
/sbin/service mysqld start
so you have a REAL consistent backup with minimal downtime you can restore
on any machine and pull dumps of whatever you really need instead of
breaindead hughe dumps with long locking time while they are done or
withut locking inconsistent state
the first rsync runs while the server is online and the second one
after mysqld is stopped takes a few moemnts because only changed data
in the meantime have to be synced again
this way you can backup many GB of mysql-data with minimal downtime
and 100% consistence
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc