GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Hosting Gods: How do you keep a site up and running normally when performing a backup?

BestXXXPorn · 02-21-2011, 01:40 PM

borked is right... Best way is to back up from a slave however...

In the interim and if your site's traffic doesn't justify a separate slave box... There are a plethora of flags/options to set in mysqldump to make sure you aren't tanking your MySQL instance during a backup ;)

EDIT: Check out mysqlhotcopy

02-21-2011, 01:40 PM
BestXXXPorn Confirmed User Join Date: Jun 2009 Location: Asheville, NC Posts: 2,277	borked is right... Best way is to back up from a slave however... In the interim and if your site's traffic doesn't justify a separate slave box... There are a plethora of flags/options to set in mysqldump to make sure you aren't tanking your MySQL instance during a backup ;) EDIT: Check out mysqlhotcopy __________________ ICQ: 258-202-811 \| Email: eric{at}bestxxxporn.com Last edited by BestXXXPorn; 02-21-2011 at 01:42 PM..