First page Back Continue Last page Overview Graphics
Backup Agents and Tools
The mysqlsnapshot perl script* is designed as way of easily backing up My/ISAM tables (only) on the same filesystem, especially for creating slaves. It will tar up all the DBs, bin-logs, and even gzip them by individual DB names.
For using mysqlsnapshot (My/ISAM only) and taring to tape:
# mysqlsnapshot -u root -p pass -s /root/mysql-snap/ -f -n --split \
&& tar cvf /dev/tape /root/mysql-snap \
&& echo All Done :\)