MySQL Administration Commands Making A Binary Backup of your by mgb63241


									MySQL > Administration > Commands > Making A Binary Backup of your MySQL Databases

Written by laughzilla
Sunday, 22 June 2008 20:58 - Last Updated Tuesday, 28 October 2008 21:04

Sure, MySQL has a great mysqldump feature which makes live dynamic backups. Of course, if
your system isn't set up with mysqldump, or if it's not working for some other reason, well, there
is another quick-fix solution that really works, by making a binary backup of your mysql
databases directory.

Here's how to do it in just 3 steps (yup. really.):

# HOW TO DO A BINARY (non mysqldump) BACKUP of /var/lib/mysql in 3 Easy Steps:

1) Run:
    service mysqld stop

2) Then run:
    tar -cvzf mysqlbackupdate.tgz /var/lib/mysql/

3) Then restart mysqld.

That's it. Your binary backup is made. This solution is for MySQL 4.x and 5.x.

ATTENTION: Do Not Attempt To Migrate a Binary Backup to another physical MySQL
server. It may not work. MySQL handles mysqldump files much better for that sort of thing. The
solution on this page is for making a local backup in case you need to reinstall it locally, that is,
on the same MySQL server that you made it on.

# # # # #  LOVE YOUR DATA BACKUPS  # # # # #

more digital solutions found at:


To top