In regards to:
Remounting MySQL under a new mount point
What would be the best way to backup MySQL data before moving the mount point? Can this be done with MySQL running? Would a simple rsync off to another server work?
Asked
Active
Viewed 1,002 times
3
-
WOuld you like to change just the mount point or also switch to another server ? – golja Oct 25 '12 at 12:06
-
Just changing mount point. / is full – Tiffany Walker Oct 25 '12 at 12:07
-
then the instruction from the post you already mentioned in your question are fine. – golja Oct 25 '12 at 12:09
2 Answers
2
Simple backup with MySQL downtime
- Stop MySQL -
/etc/init.d/mysql stop - Backup data directory -
tar czf /var/backups/mysql-2012-10-25.tar.gz /var/lib/mysql
Backup using XtraBackup
Percona XtraBackup can be used to take online hot (non-blocking) backups of your database.
pkhamre
- 6,120
- 3
- 17
- 27
-
Anyway to do this without stopping mysql? This is a production system with close to 3GBs worth of MySQL database information. That could be a lot of downtime to tar. – Tiffany Walker Oct 25 '12 at 12:06
-
-
XtraBackup is non-locking on InnoDB tables but requires a read lock on all tables to do MyISAM. If you have a mix of the two, the lock will only be in place while the MyISAM tables are being backed up. – Ladadadada Oct 25 '12 at 12:41
0
You can also backup your mysql database directory using rsync just add -a option in your command to preserve owner & permission.
rsync -arvz source destination.
user103373
- 198
- 6
- 19
-
2This may cause problems (including data corruption) if you do it while MySQL is running. – Ladadadada Oct 25 '12 at 12:38