+- Support Forums (https://www.supportforums.net)
+-- Forum: Categories (https://www.supportforums.net/forumdisplay.php?fid=87)
+--- Forum: Coding Support Forums (https://www.supportforums.net/forumdisplay.php?fid=18)
+---- Forum: Database Programming (https://www.supportforums.net/forumdisplay.php?fid=28)
+---- Thread: MySQL Database Backups (/showthread.php?tid=7375)
MySQL Database Backups - alfonzo1955 - 05-26-2010
I was worried that when I do a backup via MyBB, someone would post during the backup process and it would be inconsistent. I usually close my board when I do backups. Is this necessary?
RE: MySQL Database Backups - Buffy - 05-27-2010
I think that closing your board is not only necessary, but a very good practice. Now, you can not close the board while backing up the database; however, you might lose a post or three in the process of backing up.
RE: MySQL Database Backups - Omniscient - 05-27-2010
I do a backup of my 3gb database without closing the site. Not really a big big problem for the most part.
RE: MySQL Database Backups - alfonzo1955 - 05-28-2010
OK. Thanks for the support Omni, I won't close it while backing it up then.