Shipside Member Jun 2, 2015 #1 I'm currently backing up via CLI using: mysqldump --opt -Q -u USERNAME -p DBNAME > thatfile.sql Is there a reason you prefer to not use method? Your recommended is: mysqldump --opt -u USERNAME -p DBNAME
I'm currently backing up via CLI using: mysqldump --opt -Q -u USERNAME -p DBNAME > thatfile.sql Is there a reason you prefer to not use method? Your recommended is: mysqldump --opt -u USERNAME -p DBNAME
Paul B XenForo moderator Staff member Jun 2, 2015 #2 I prefer to use this for dumping: Code: mysqldump -u -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql Upvote 0 Downvote
I prefer to use this for dumping: Code: mysqldump -u -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql
Shipside Member Jun 2, 2015 #3 Can you please elaborate on your specific switch choice? Also, do you recommend mysqlcheck -r ? Upvote 0 Downvote
Paul B XenForo moderator Staff member Jun 2, 2015 #4 Someone far more knowledgeable than me provided that, which is why I use it. I've been using it for years without issue. Upvote 0 Downvote
Someone far more knowledgeable than me provided that, which is why I use it. I've been using it for years without issue.
Shipside Member Jun 2, 2015 #5 Ok thanks, and I assume essential to close board before backup? Database is over 1GB, is there any DB size issue? Upvote 0 Downvote
Ok thanks, and I assume essential to close board before backup? Database is over 1GB, is there any DB size issue?
Paul B XenForo moderator Staff member Jun 2, 2015 #6 It's not essential but it's probably a good idea if it's a very busy site. Upvote 0 Downvote
